Salesforce to Oracle Fusion Cloud Inbound Integration in OIC

 Can you walk me through any one of the complex integration which you have built recently?

High-Level Flow: 

Salesforce triggers → OIC maps and orchestrates → ERP Cloud creates accounts → OIC logs and monitors. This guarantees data consistency and automation across CRM and ERP systems

Short Answer: 

I recently build one "complex Integration" which is: Customer Account Details Sync Service/Interface/program from Salesforce to ERP Cloud:

Step by Step Flow:-

The integration connects Salesforce and Oracle ERP Cloud using OIC(Interface/PaaS/Middleware Tool). 

App Driven Style/Pattern

Method: Inbound(data flows from Salesfroce to Oracle ERP Fusion/Cloud)

When a customer account is created in Salesforce(Source), 

              a record-triggered flow sends the data to OIC. 

OIC maps and transforms the payload, then calls ERP Cloud(Target) services in sequence—

1.Process Location, 

2.Process Organization, 

and 3.Merge Customer Account — to create the account in Fusion. 

Authentication is handled via OAuth2.0 for Salesforce and Basic credentials for ERP. 

OIC also logs success or failure and supports error reprocessing(Global or Scope Fault Handlers). 

The result is real‑time, automated synchronization of customer accounts, enabling immediate AR invoice creation without manual effort.

========================

Long Answer:

I recently build one "complex Integration" which is: Customer Account Details Sync Service/Interface/program from Salesforce to ERP Cloud:

Step by Step Flow:-

An Integration is designed to automatically sync customer accounts from Salesforce into Oracle ERP Cloud using Oracle Integration Cloud (OIC). 

The flow starts when a new customer account is created in Salesforce. 

A record‑triggered flow in Salesforce sends an outbound message to OIC. 

OIC acts as middleware — it receives the payload, performs data mapping and transformation, and then calls ERP Cloud services.

On the ERP side, the sequence is: 

first create or update the Location, 

then create the Organization with Party and Party Site, and finally merge the Customer Account. 

Each step returns IDs that are passed forward until the Customer Account is successfully created in Fusion FSCM. 

Authentication is handled via OAuth 2.0+token-based credentials for Salesforce and Basic Authentication for ERP Cloud. 

OIC also provides monitoring and error handling — faults are logged in ATP tables for reprocessing.

The outcome is real‑time synchronization with zero manual effort, ensuring that customer accounts created in Salesforce are immediately available in ERP Cloud for AR invoice creation. 

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

Salesforce to Oracle Fusion Cloud Inbound Integration 

Source: Salesforce CRM Cloud App(Third-Party)

New Customer Account creation

Outbound Message Trigger

Interface: Oracle Integration Cloud (OIC)

Data Mapping & Transformation

API Call to ERP Cloud

Error Handling & Auditing

Target: ERP Cloud (Oracle Fusion) App

Process Location → Location ID

Process Organization → Party ID & Party Site ID

Merge Customer Account → Customer Account ID

ERP Cloud System

Customer Account Created/Updated

Status Response & Logs

===================

🔹 Source System: Salesforce

• Trigger: Record-triggered flow in Salesforce Process Automation.

• Outbound Message: Sends customer account data via WSDL endpoint.

• Authentication: OAuth 2.0 + Security Token.

• Adapter: Salesforce Adapter in OIC.

🔹 Middleware: Oracle Integration Cloud (OIC)

• Integration Type: App-driven inbound integration.

• Modules:

  • Inbound Trigger: Receives Salesforce payload.

  • Data Mapping Layer: Transforms Salesforce fields to ERP schema.

  • Transformation Logic: Handles merge/update operations.

  • Error Handling: Fault indicators logged in ATP custom tables.

  • Monitoring: OIC dashboard for success/failure tracking.

• Security: Basic or token-based authentication for ERP Cloud.

🔹 Target System: Oracle ERP Cloud (Fusion FSCM)

• Adapter: ERP Cloud Adapter (REST/SOAP).

• Sequence of Operations:

  1. Process Location → returns LocationId.

  2. Process Organization → returns PartyId, PartySiteId.

  3. Merge Customer Account Service → returns CustomerAccountId.

• Hardcoded Parameters:

• ChangeOperation = Merge

• PartialFailureAllowed = TRUE

• CreatedByModule = HZ_WS

• SetID = US1 BU

=======================================

🔹 Data Flow Summary

Step	Source	Middleware	Target	Output
1	Salesforce Account Creation	OIC Trigger	ERP Cloud	LocationId
2	Salesforce Payload	OIC Mapping	ERP Cloud	PartyId, PartySiteId
3	Transformed Data	OIC API Call	ERP Cloud	CustomerAccountId
4	ERP Response	OIC Monitoring	Salesforce	Success/Failure Log

=============================

Integration Security & Connectivity

Layer	Protocol	Authentication	Notes
Salesforce → OIC	HTTPS	OAuth 2.0 + Security     Token	Region/IP-based token validation
OIC → ERP Cloud	HTTPS	Basic/Token-based	ERP credentials stored securely
OIC Monitoring	Internal	Role-based Access	Integration logs & fault recovery

============================

Error Handling & Reprocessing

• Faults captured in OIC → logged in ATP custom tables.

• Reprocessing logic triggers retry for failed records.

• Alerts configured via OIC monitoring dashboard.

===================

Outcome

• Real-time synchronization between Salesforce and ERP Cloud.

• Zero manual intervention for customer account creation.

• Enables AR invoice generation directly in Fusion FSCM.

============================

For detailed flow and explanation, 

please "Click Here"