1/11/24, 9:09 PM (23) Oracle ERP SCM Cloud Integration Design Patterns with OIC | LinkedIn
23 Reactiv
Home My Network Jobs Messaging Notifications Me For Business Premium: 5
Oracle ERP SCM Cloud
Integration Design
Patterns with OIC
Ayyappa Dasam 1 article Follow
Oracle Cloud Solution Architect
May 18, 2023
Open Immersive Reader
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.
Inbound
Realtime Sync – rest API/soap web services
FBDI
B2B
Outbound
Realtime Sync - business events
BI Publisher
BICC
B2B
Inbound Pattern - Realtime Sync
https://www.linkedin.com/pulse/oracle-erp-scm-cloud-integration-design-patterns-oic-ayyappa-dasam/ 1/6
1/11/24, 9:09 PM (23) Oracle ERP SCM Cloud Integration Design Patterns with OIC | LinkedIn
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 API 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
•OIC can also meter requests to HCM cloud REST API.
- The first integration transforms and enriches the requests
and puts them in a queue. This can be a message queue or
a database table.
- The second integration consumes the messages from the
queue at a steady rate and invokes HCM REST API.
- Second integration can be made configurable to adjust
the rates of calls to HCM REST API
https://www.linkedin.com/pulse/oracle-erp-scm-cloud-integration-design-patterns-oic-ayyappa-dasam/ 2/6
1/11/24, 9:09 PM (23) Oracle ERP SCM Cloud Integration Design Patterns with OIC | LinkedIn
Inbound Pattern - Bulk Import (FBDI)
Key Takeaways
1. Inbound Batch Pattern
2. Use capabilities of ERP Adapter to simplify FBDI import
and callback
3.FBDI Imports have asynchronous callbacks(business
event) to monitor the status of import
4. 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
https://www.linkedin.com/pulse/oracle-erp-scm-cloud-integration-design-patterns-oic-ayyappa-dasam/ 3/6
1/11/24, 9:09 PM (23) Oracle ERP SCM Cloud Integration Design Patterns with OIC | LinkedIn
Outbound Pattern - Realtime Sync (Event Driven)
Key Takeaways
1. Events can only be used with OIC. Cannot be used with
any other third-party listener
2. Events make use of the Event Handling Framework
3. Not all business events are supported through the Events
Framework
4. 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
1. Use BIP only when REST and SOAP Services are not
available
2.DO NOT use runReport() service in high volume
transaction
3. Use BIP Reports in an asynchronous pattern using
scheduled-based integrations
https://www.linkedin.com/pulse/oracle-erp-scm-cloud-integration-design-patterns-oic-ayyappa-dasam/ 4/6
1/11/24, 9:09 PM (23) Oracle ERP SCM Cloud Integration Design Patterns with OIC | LinkedIn
•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.
Report this
Published by
Ayyappa Dasam
Oracle Cloud Solution Architect 1 article Follow
Published • 7mo
https://www.linkedin.com/pulse/oracle-erp-scm-cloud-integration-design-patterns-oic-ayyappa-dasam/ 5/6
1/11/24, 9:09 PM (23) Oracle ERP SCM Cloud Integration Design Patterns with OIC | LinkedIn
Oracle ERP SCM Cloud Integration Design Patterns with OIC
Like Comment Share
Abishek Adulapuram and 70 others
71 3 comments
Reactions
+59
3 Comments
Most relevant
Add a comment…
Ramesh Peruka • 2nd 7mo
OIC Certified | Oracle Integration Cloud(OIC) | ICS | SOA | OSB |
I enjoyed reading your blog post. The information was well-organized and
presented in a clear and concise manner.
Like Reply
Ashish Mangukiya (He/Him) • 2nd 7mo
Oracle Integration Certified Specialist | OIC | VBCS | Oracle PaaS | Oracle
Fusion Technical | Ex-Infosense | Ex-Mastekeers
It’s useful 👍
Like Reply
Load more comments
Ayyappa Dasam
Oracle Cloud Solution Architect
Follow
About Accessibility Talent Solutions Questions? Select Language
Visit our Help Center.
Community Guidelines Careers Marketing Solutions English (English)
Privacy & Terms Ad Choices Advertising Manage your account and privacy
Go to your Settings.
Sales Solutions Mobile Small Business
Safety Center
Recommendation transparency
Learn more about Recommended Content.
LinkedIn Corporation © 2024
https://www.linkedin.com/pulse/oracle-erp-scm-cloud-integration-design-patterns-oic-ayyappa-dasam/ 6/6
