Real-Time Integration Scenario: Supplier Data Sync Service for Fusion to EBS using OIC

Real-Time Integration Scenario: 

To ensure data consistency across environments, any supplier record created or updated by an end-user in Oracle Fusion Cloud ERP must beextracted, processed, and imported into the Oracle EBS applicationwithin 15 minutes of its creation.

Type: Outbound, Near-Real-Time (15-minute SLA), Scheduled Orchestration.

Source: Oracle Fusion Cloud ERP.

Target: Oracle EBS (On-Premises).

Middleware: Oracle Integration Cloud (OIC).

Step 1: Data Extraction (Oracle Fusion)

Develope Custom BIP Report in Fusion to extract complete, hierarchical Supplier data. 

(Suppliers: Headers, Sites, Contacts, and Bank Details).

Implement a Incremental Delta Logic using a LAST_RUN_DATE parameter so that 

At Each run, it extracts only suppliers created or updated within the last 15 minutes.

Step 2: Middleware Orchestration & Data Retrieval (OIC)

Go to OIC, Build a scheduled orchestration and configure to run for every 10 to 15 minutes.

Create Connection to Fusion using: Oracle ERP Cloud Adapter.

Add SOAP Adapter: Use service "ExternalReportWSDL" to run BIP report

We will get base64-encoded report output data in OIC.

Decode it, and parsed the XML data structure.

Step 3: Data Transformation & Mapping (OIC)

Perform data mapping and value conversion.

(Ex:Cross-referencing Fusion Payment Terms or LoVs to match EBS-specific IDs)

Step 4: Data Ingestion (Oracle EBS)

Connect securely to the on-premises EBS database(DBaaS) using the Oracle EBS Adapter via the OIC Connectivity Agent.

Validate data in OIC staging area and move into EBS Open Interface Tables(AP_SUPPLIERS_INT, AP_SUPPLIER_SITES_INT) rather than base tables to preserve EBS data integrity.

OR

Trigger the standard EBS Concurrent Program 

(Supplier Open Interface Import) to process and validate the interface records into EBS base tables.

Step 5: Exception Handling & Reporting

Implement a global fault handler within the OIC flow to capture for technical or data validation failures.

Designed an automated email notification at the end of the run that sends Reporting Statistics (Total Processed, Success Count, Failure Count) along with a detailed error log directly to the Supplier Administrator for immediate action.

----------------------

Why did you used BIP reports instead of REST APIs? 

BIP allowed me to extract a massive, nested data structure (Supplier + Sites + Contacts) in a single database pass, minimizing API performance overhead.

How was the 15-min SLA met your requirement? 

By keeping the integration lightweight through high-frequency scheduling combined with strict timestamp-based delta filters.

How did you connected to on-prem EBS app securely?

I have used the OIC Connectivity Agent to establish a secure, outbound-only connection from the on-premises EBS database to the cloud, eliminating the need to open risky firewall ports.

                                                                                                                --Documented by Venkat