Seamless Sales Order Integration: Oracle APEX + Oracle Fusion Order Management with OIC

In today’s digital enterprise landscape, seamless integration across cloud-native platforms is the key to operational efficiency and enhanced user experience. This blog outlines a real-world integration scenario where Oracle APEX is integrated with Oracle Fusion Cloud Order Management using Oracle Integration Cloud (OIC). This integration empowers users to create, manage, and synchronize sales orders in real time across platforms.

Use Case Overview

Business Need
A mid-size enterprise wanted to provide their sales team with a simplified and user-friendly front-end interface for creating and managing sales orders—without sacrificing the robustness and compliance of Oracle Fusion Order Management. To address this, a custom UI was built in Oracle APEX (running on Oracle ATP), and Oracle Integration Cloud was used to orchestrate the interaction between APEX and Fusion.

Key Features of the Solution

• Custom Sales Order UI in Oracle APEX (powered by Oracle ATP)

• Real-Time Order Creation using Oracle Fusion REST APIs via OIC

• Two-Way Synchronization of order changes through OIC event subscriptions

• Support for Order Line Additions, Cancellations, and Modifications directly from APEX

• Event-driven updates from Fusion Order Management to keep APEX in sync

Technical Architecture

Components Involved:

• Oracle APEX (on ATP):

  • Custom UI to create and manage sales orders/database tables

  • Sales data is persisted in Oracle Autonomous Transaction Processing (ATP)

• Oracle Integration Cloud (OIC):

  • Receives and transforms data from APEX

  • Calls Fusion Order Management REST APIs

  • Subscribes to Order Change Events and syncs data with APEX

• Oracle Fusion Order Management:

  • Authoritative source for all Sales Order processing and status updates

End-to-End Flow

1. Order Creation via APEX UI

   • User enters customer, item, and order details in the APEX UI.

   • On clicking "Submit", an HTTPS POST request is sent to an OIC endpoint.

2. Order Processing in OIC

   • OIC parses and validates the payload.

   • Invokes Oracle Fusion REST API to create the Sales Order.

   • Response is returned to APEX, and ATP is updated with status.

3. Real-Time Event Sync

   • OIC subscribes to Oracle Fusion's Order Change Events.

   • On event trigger, OIC pushes the update back to the ATP tables to keep the UI current.

4. Order Maintenance from APEX

   • Users can add lines, cancel orders, or modify lines.

   • Each action triggers a call to OIC which updates Fusion accordingly.

Highlighted OIC Capabilities

• REST Adapter: Used to connect securely with Oracle Fusion SaaS APIs

• Event Subscription Framework: Enables OIC to react to Fusion-side changes

• ATP Integration: Writes status and responses to Custom tables (in ATP)  from OIC

• Rich Mapping Engine: Handles JSON/XML to structured data transformations

• Robust Error Handling: Ensures resiliency and alerts for integration issues

Benefits Achieved

• Unified Order Experience across custom APEX UI and Oracle Fusion

• Near real-time synchronization between ATP and Fusion OM

• Minimal manual intervention and error handling

• Scalable and Secure architecture with low-code development