Oracle SCM Integration Design Patterns with OIC

OIC is a perfect fit for building integrations when Oracle Apps(ERP, SCM, HCM, CX, DB, DBaaS, ADB, etc.) are in the landscape. It is even greater if there is a requirement to create business workflows and custom web apps. All of these work very well together.

In this blog we will look at the various integration patterns available with OIC to integrate with Oracle Supply Chain management cloud.  

Inbound (Send to SCM)

• Realtime Sync – rest API/soap web services
• FBDI

Outbound (Fetch from SCM)

• Realtime Sync - business events
• BI Publisher
• BICC

Inbound Pattern - Realtime Sync

Key Takeaways

• Use for real-time integrations
• Two flavors SOAP and REST.
• Preference is REST over SOAP.
• Use SOAP only if functionality is not available in the REST
• REST APIs are growing in numbers
• REST API "Batch Action" can be used to process multiple records in one shot
• SOAP services have Async web services with callbacks. These services are useful for implementing Async patterns
• Plan for Rest API limits
• Paginate to overcome limits on records/call
• Use batch action to combine multiple operations into a single HTTP request (batch actions) to improve performance.
• Transform & Enrich payload in OIC using information from other applications

Can use Oracle REST APIs to view and manage data stored in Oracle Supply Chain Management Cloud. You can view a list of all REST endpoints

Inbound Pattern - Bulk Import (FBDI)

Key Takeaways

• Inbound Batch Pattern
• Use capabilities of ERP Adapter to simplify FBDI import and callback
• FBDI Imports have asynchronous callbacks(business event) to monitor the status of import
• Widely used pattern in ERP and SCM world
• Import bulk data operation does end-to-end process – upload file to ucm, submit load, and import job.
• Need not create an explicit Interface WSDL to implement on job completion operation
• Event is natively supported by Oracle ERP Cloud Adapter which protects from any changes in the ERP Cloud interface changes just in case.
• Needless to mention we can avoid all the additional steps to capture JSON and parse the same. Event payload is parsed and readily available in the trigger message to fetch the report from UCM
• When an Event-based integration is activated OIC creates a subscription entry in Oracle ERP Cloud. For some reason, if the Event-based Integration Flow is not reachable ERP Cloud will re-try the events multiple times with an exponential time gap. In the URL-based callback, re-try cannot happen as it is a fire and forget from ERP Cloud

Outbound Pattern - Realtime Sync (Event Driven)

Key Takeaways

• Events can only be used with OIC. Cannot be used with any other third-party listener
• Events make use of the Event Handling Framework
• Not all business events are supported through the Events Framework
• If there are no events for a specific Business Object or if the use case in question is Batch Processing, then use BIP/BICC

Outbound Pattern - Bulk Export (BI Publisher)

Key Takeaways

• Use BIP only when REST and SOAP Services are not available
• Do not use runReport() service in high volume transaction
• Use BIP Reports in an asynchronous pattern using scheduled-based integrations
• Export bulk data operation does – submit ess job(bip) and transfer output and log files to ucm.
• Need not create an explicit Interface WSDL to implement onJobCompletion operation
• Event is natively supported by Oracle ERP Cloud Adapter which protects from any changes in ERP Cloud interface changes just in case.
• Needless to mention we can avoid all the additional steps to capture JSON and parse the same. Event payload is parsed and readily available in the trigger message to fetch the report from UCM
• When an Event-based integration is activated OIC creates a subscription entry in Oracle ERP Cloud. For some reason, if the Event-based Integration Flow is not reachable ERP Cloud will re-try the events multiple times with an exponential time gap. In the URL-based callback re-try cannot happen as it is a fire and forget from ERP Cloud

Outbound Pattern - BICC (BI Cloud Connector)

BICC is a cloud connector to extract business intelligence and other data in bulk. BICC can be configured to write the extracted data files to UCM or Cloud Object Store. BICC is available as part of the Oracle Applications Cloud subscription.

Oracle’s simplified solution of Oracle Integration Cloud (OIC) enables customers to easily exchange data with SCM Cloud.