Case study · Consumer Products
A field service app connected to Oracle SCM
How we build a cross-platform app for field teams to record inventory, orders and returns, synchronised with Oracle SCM Cloud through OIC and OCI API Gateway. The reference pattern where our two pillars meet.
- Client
- Reference architecture
- Industry
- Consumer Products
- Solutions
- Oracle SCMOracle IntegrationMobile Development
- Technology
- React NativeExpoSupabaseOracle Integration CloudOracle SCM CloudOCI API Gateway
Challenge
Field teams record stock counts, orders and returns on paper or in a legacy app, and someone re-keys them into the ERP later. Inventory in SCM drifts from inventory on the van, and the legacy app no longer passes store review. The enterprise system is fine; the last mile to the people using it is not.
Context
This is a reference engagement: the architecture we use whenever a mobile product has to read from and write to Oracle SCM or ERP. The same pattern applies to portals and web applications.
Architecture
Experience
- iOS
- Android
Product backend
- SupabaseAuth · Postgres · Realtime
- OCI API Gateway
Integration
Oracle Integration Cloud
Oracle SCM Cloud
- Inventory
- Order Management
Solution
The app is React Native with Expo, written for offline capture first: a warehouse has no signal, so every transaction is stored locally and synchronised when it can be. A product backend holds users, devices and the local transaction log. OCI API Gateway fronts a small set of integrations in OIC that call SCM's inventory and order APIs, so the app never talks to Fusion directly and every call is authenticated, throttled and logged.
- Idempotency keys on every write, so a retried sync never creates a duplicate order or count.
- Business exceptions from SCM (item not stocked at this sub-inventory, order on hold) come back to the user in plain language with the fix.
- Store builds through EAS with internal testers from the second week; JavaScript fixes ship over the air.
- The integration layer is versioned and promoted by pipeline like the rest of the Oracle estate.
Business impact
What changes: inventory in SCM matches inventory in the field because the field is entering it once, at the point of work; re-keying disappears along with its errors; and the enterprise system gains a modern product surface without being customised.
This page describes the reference engagement rather than one client, so it carries no client figures.
Key takeaways
- 01Design for offline first; the warehouse has no signal.
- 02Put an API gateway between the app and OIC.
- 03Ship to internal testers from week two.
Services involved
Oracle SCM Cloud
Inventory, Order Management, Manufacturing, Planning and Procurement on Oracle SCM Cloud, integrated with the WMS, MES, 3PL and EDI systems that move physical goods.
Oracle Integration Cloud
Application, scheduled and event-driven integrations on Oracle Integration Cloud, engineered with error handling, observability and CI/CD so they run for years, not just through go-live.
Mobile App Development
Native iOS, Android and cross-platform apps with the backend, authentication, payments, notifications and store deployment done properly, for consumers, employees and field teams.
Facing something similar?
We will walk you through how we approached this one and what would be different for you.