Understanding Oracle's Integration Cloud and how to get the most out of your implementation

Tag: ERP Page 1 of 2

December 2022 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
Cheat sheet for XSL transformationAhmed AboulnagaXSL (OIC / SOA) 
OIC Regions expansion in 2022Ana Lucero AlvaradoOIC 
OIC – Twilio adapter – send SMS / WhatsApp from Oracle IntegrationSanddyOICSMS, WhatsApp
ERP – BI Report Output / Send to UCM / Send as Email AttachmentSanddyOICERP
OIC 22.12 Release – New Features –> ProjectsNiall CommiskeyOIC 
OIC 22.12 Release – New Features –> PostgreSQL AdapterNiall CommiskeyOICPostgreSQL
Integrating with OTM Cloud using the OIC Logistics AdapterNiall CommiskeyOICOTM
OIC 3 22.12 Release New FeaturesNiall CommiskeyOIC 3 
OIC 3 Connectivity Agent install and REST APINiall CommiskeyOIC 3 
Seamless Opportunity to Order Integration for Oracle eBusiness Suite using OIC3Sujit NairOIC 3EBS
Parallel Flow in Oracle Integration 3Sujit NairOIC 3 
How to become a certified Oracle Cloud Platform expert?Jürgen KressOIC 
FBDI to upload AP into ERPAnkur JainOICERP Cloud
Observability (Run-Time Monitoring) in Oracle IntegrationAnkur JainOIC 
Download files from Oracle Universal Content ManagementAnkur JainOICUCM
Process millions of records from Oracle DatabaseAnkur JainOICDB

Not really specific to OIC, but important to just about any solution involving authentication is OAuth 2 – so here Aaron Parecki has compiled all the relevant RFCs together into a single PDF – neat idea.

November 2022 – New OIC Articles

Generation 3 of OIC has been out for a few quarters now, and we’re starting to see guidance published on migrating from Gen2 to Gen3 and articles about OIC v3 features.

Article / LinkAuthorSubject MatterConnecting
Oracle Integration 3 Upgrade – PaaS Partner Community Webcast November 29th 2022Milad Shiraz & Jürgen KressOIC v3 
How to Upgrade from OIC Gen2 to OIC3Ana Lucero AlvaradoOIC v3 
OIC 3 22.10 Release New FeaturesNiall CommiskeyOIC v3 
Exelon automates customer service with Integration & Digital Assistant. Learn from successful customer projectsJürgen KressOIC 
Oracle Integration 3 – Experiential – ERP Cloud Business Events LiveLab is Available!Subhani ItalapuramOIC v3 
OIC Error HandlingNiall CommiskeyOIC 
Working with the Adobe Sign Adapter Part I, Part IINiall CommiskeyOICAdobe Sign
Best Practices to Design an Oracle IntegrationGiri PrasadOIC 
Oracle Integration 3 IntroductionGiri PrasadOIC 
Process Automation helps you to rapidly design, automate, and manage business processes in the CloudCristian SilipigniOPA 
How to call DB Procedure AsynchronouslySanddyOIC 
Use REST adapter with multiple resources or Multiple Verbs in Oracle Integration CloudSanddyOIC 
Subscribe to business events raised within the ERP Cloud what happens in the background ERP after import from OICSanddyOICERP cloud
Oracle Integration Cloud Hybrid integrations with Oracle Connectivity AgentYves ChasseinOIC 
40+ Oracle Integration Cloud OIC Interview Questions 2023Mahir FayazOIC 
Integrating Oracle EBS With Oracle Cloud ApplicationsOICEBS & Oracle SaaS
Performance implications of Synchronous and Asynchronous patterns in large enterprise Oracle Integration Cloud implementations with SaaS ApplicationsShub LahiriOIC 

September 2022 – New OIC Articles

With Oracle Cloud World just around the corner, the annual Customer Advisory Board event can be attended. So if you’re in Las Vegas for the event – consider registering – it provides a chance to talk with product leadership and hear in detail product development.

Article / LinkAuthorSubject
Matter
Connecting
Create a Retry logic – To overcome putting file to AWS S3 bucket timeout issueSanddyOICAWS S3
How to invoke OCI Function from Oracle Integration CloudSanddyOICOCI functions
Oracle digital assistant Best Practices Part 1, Part 2 (more to come)Daniel TeixeiraODA
Opaque Schema in OICKabir YadavOICfiles
Develop an Integration to get dynamic Email NotificationKabir YadavOICEmail
Schedule Parameters in OICKabir YadavOIC
Oracle Integration Generation 3 – PaaS Partner Community WebcastJurgen KressOIC3
How to confirm if a Fusion Apps Business Event was released to OICAna Lucero AlvaradoOICFusion Apps
https://blogs.oracle.com/fusionmiddlewaresupport/post/process-features-that-are-being-deprecated-in-future-releases-of-oracle-integrationElizabeth EarlePCS
Message Driven Processes with OPA – OAuth SetupNiall CommiskeyOPA
OIC -> Create Customer in Fusion ERPNiall CommiskeyOICFusion ERP
OIC – HCM Register for Training – Create Absence Use caseNiall CommiskeyOICHCM
Complementing Oracle Application Integration with OCI Data Integration Services – Overview and DemoMilomir VojvodicOICODI, Goldengate
Two New Oracle Integration 3 LiveLabs Are AvailableSubhani ItalapuramOIC3
De-mystifying Oauth using JWT user assertion in OICVernon SaldanhaOIC
How to File a Service Request for Oracle Integration 3 EnablementMilad ShirazOIC3
The power of Oracle Integration Cloud’s process automation with RPAAbhijit Ramachandran OIC
Oracle Integration Cloud (OIC): Evolution and Best PracticesAbhijit Ramachandran OIC

March 22 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
Get Report Parameters OIC 
How to Process ERP Cloud Business Events in Oracle IntegrationKishore KattaOICOICERP
Using OIC for Data Migration?Yan ScorrerOIC 
Oracle Integration, OCI API Gateway and OCI Logging & AnalyticsCristian SilipigniOIC 
OIC New Features March 2022 – Magento AdapterNiall CommiskeyOICMagento
OCI CIS Landing Zone: Advanced Configuration using Terraform OverridesOlaf HeimburgerOIC 
ERP Integration Callback Implementation in Oracle Integration CloudJack DesaiOICERP
Create IDCS user with OIC creation privilegesGabriele Cannas OICIDCS
Oracle Integration Update Webcast: CX Integration and Extension Best practicesJürgen Kress OICCX
Blending PaaS Data with SaaS Reporting Using OIC to Break Data SilosBhavesh ShahOICDB
Dynamically show changed fields in a Process Web FormArvind VenugopalPCS 
Import Suppliers using FBDI in Oracle IntegrationAnkur JainOICERP
Merging two CSV files into a single file in Oracle IntegrationAnkur JainOIC 
Enable Oracle Integration Activity Stream to OCI Logging serviceAnkur JainOICObservability

February 22 – New OIC Articles

Another month passed already, so here are Feb’s posts.

Article / LinkAuthorSubject MatterConnecting
Automating Accounting Hub Cloud Integration with Oracle IntegrationKishore KattaOICAccounting Hub
OIC – API Gateway – Logging –> the value add of OCINiall CommiskeyOICAPI Gateway, OCI Logging
OIC + OHIP + Simphony (part 1, part 2, part 3)Niall CommiskeyOICOracle Hospitality, Simphony, OHIP
OIC ecosystem – Integration & OCI Services – an OverviewNiall CommiskeyOICOCI
February 2022 Oracle Integration UpdateAntony ReynoldsOICMagento Commerce Cloud, Oracle Unity, Oracle Hospitality
New Third Party Application AdapterMadhav PoosarlaOICMagento Commerce Cloud
Oracle Integration Business Accelerator for Siebel Loyalty and CrowdTwistPrakash Masand & Venkat BhatOICSiebel
How to call the OCI AI Language Service from the Oracle Integration CloudDaniel Martins TeixeiraOICOracle AI Language Service
Oracle Hospitality Integration Platform (OHIP) Developer Portal gets a faceliftAmy Simpson-GrangeOHIP 
Integration to upload file to the UCM Server in HCM CloudKabir YadavOICHCM UCM
Steps to fetch Oracle Cloud SaaS Application CertificatesKabir YadavOIC 
How-to Do Error Handling When Integrating With Fusion ERPJan KettenisOICFusion ERP
Parallel Gateway and Multi-Threading, the Work-AroundJan KettenisOIC 
Token Based Authentication (TBA) Policy configuration for Oracle Integration Cloud NetSuite AdapterManish Kumar GuptaOICNetSuite
Publish messages in Stream using Oracle Integration & Connect Stream using OCI Streaming adapter in Oracle IntegrationAnkur JainOICStreams

December 21 – New OIC Articles

December is always a quiet month having had updates in November, but this month has been particularly so. One bit of good news, the handy resource links have been updated with a lot more additional resources – see right of the page.

Article / LinkAuthorSubject MatterConnecting
CI/CD working with EiPaaS Oracle Integration (OIC)Cristian SilipigniOICCI/CD
Speed up your Accounting Closing Cycle with automated loading of Payable Invoices into Oracle ERP Cloud, using Oracle Integration CloudJuan CarlosOICCX/ ERP/ ServiceCloud
Quarterly UpdatesPhil WilkinsOIC 
Using the Oracle Cloud Infrastructure Streaming Service Adapter with Oracle IntegrationOICStreams
Build retry logic in Oracle IntegrationAnkur JainOIC 
Call VB Business Objects from Oracle IntegrationAnkur JainOIC 

June 21 – New OIC articles

It appears to have been an unusually quiet month, but that could be a reflection of the OIC release cycle as we’ll probably hear about the next feature set updates late in July.

Article / LinkAuthorSubject MatterConnecting
OIC Recipe – SFDC Opportunity to Fusion ERP OrderNiall CommiskeyOICSFDC, ERP
Some Ideas for OIC Fleet ManagementNiall CommiskeyOIC 
OIC – SFDC -Bulk apiNiall CommiskeyOICSFDC
Improving the performance of Oracle Integration flows that use REST callsNick MontoyaOIC 
Connecting securely from Oracle Integration to Autonomous database using network access listShreenidhi RaghuramOICADB
Connect Oracle SaaS (ERP, HCM, CX) with Pre-Built Recipes – Accenture Oracle WebcastJürgen KressOICERP, HCM, CX 
Insight Mapping ImprovementsSanthosh KumarInsights 
Real time Synchronization of Suppliers leveraging Event Driven ArchitectureKishore KattaOICKafka
Oracle HCM Cloud – Payroll Sync with the Oracle Integration CloudDaniel TeixeiraOICHCM
Using REST APIs to manage Connections in OICPranav DavarOIC 
Enable Business Events for Payables Business Events/Payments in Oracle Fusion Finance CloudDeb MukherjeeOICERP
OIC – API Gateway – Logging –> the value add of OCINiall CommiskeyOICOCI (API, Logging etc)
Configuring Notifications in Oracle Integration Gen2Lavanya SiliveriOICOCI Email
Use Oracle Integration to Add Attachments to a Process InstanceBogdan EremiaOIC 
File Adapter Vs FTP Adapter in Oracle Integration CloudAnupam BartwalOIC
Oracle Integration Cloud (OIC) AdaptersKrishan KumarOIC

April 21 – New OIC articles

Blink and it’s another month gone. But Oracle has been very very busy as we come around for the latest quarterly updates and the details published. Plus a lot about Oracle Hospitality Integration Hub (OHIP) which builds upon OIC.

Article / LinkAuthorSubject MatterConnection
May 2021 Oracle Integration UpdateAntony ReynoldsOIC 
May 2021 Third-Party application adapters updateMichael MeinerAdapters 
May 2021 Oracle Integration Fusion Application Adapters ImprovementsPrakash MasandSaaS Adaptors 
May 2021 Oracle Integration Database Adapter ImprovementsPakash MasandDB Adaptors 
May 2021 Enhanced Security in AdaptersMichael MeinerAdapters 
May 2021 Technology Improvements in AdaptersMichael MeinerAdapters 
Connect Oracle SaaS (ERP, HCM, CX) with Pre-Built Recipes – Accenture Oracle Webcast May 5th 2021Amit Tahilramani, Mani Choudhary and Amit Singh with Dhiraj ChhajerOracle SaaS Recipes 
Invoking Process Applications with Anonymous Users from VB Apps with Oracle IntegrationArvind Venugopal, Shay Shmeltzer, and Nathan AngstadtVisual Builder 
Extend Process Automation UI Components to JET-Based ApplicationsArvind Venugopal, Rameshkumar Arumugam, and Sacheth SavandurgaProcess 
Using an Event Based Pattern with Oracle IntegrationMichael MeinerOIC PatternShopify
Practical Guide to use HCM Data Loader with Oracle IntegrationPrakash Masand, and Harris QureshiOICHCM
Using UN/EDIFACT for B2B TransactionsArvind Venugopal, and Sunil ApteOIC 
Modelling Transport Integrations with Trading Partner ManagementArvind Venugopal, and Sunil ApteOICOICTrading Partner
May 2021 Oracle Integration Pre-built RecipesMichael MeinerOICNetSuite, ServiceNow, Facebook, Slack, docusign
Connecting securely from Oracle Integration to Autonomous database using network access listShreenidhi RaghuramOICAutonomous DB
OIC – Oracle Hospitality syncing Company/Guest with SFDC Account/ContactNiall CommiskeyOICOracle Hospitality
OIC May 21 Release – New Jira adapterNiall CommiskeyOICJIRA
OIC for File Transfer – Rename – Move to Target – Delete SourceNiall CommiskeyOICFTP
OIC –> Oracle Hospitality – refreshing OAuth TokenNiall CommiskeyOICOracle Hospitality
Box to HCM Cloud –> HDL File LoadNiall CommiskeyOICBox
Integrating Oracle Hospitality Cloud and 3rd party CRM (SFDC) via OIC and OHIPNiall CommiskeyOICOracle Hospitality
OIC and Oracle Hospitality (OHIP) – Getting the most out of Opera APIsNiall CommiskeyOICOracle Hospitality
Five key Oracle Integration lessons from handling billions of messages monthlyAmit Saxena & Daryl EicherOIC 
Working Around not Having Complex GatewayJan KettenisOIC 

OIC and Integrating Oracle SaaS

Handling integration between Oracle SaaS applications and modules has been something of an evolutionary journey. A couple of years ago if you wanted to intgrate say HCM and ERP you needed to ICS or OIC to perform the integration.

In many respects this wasn’t such a terrible thing. Technically as it meant that the back end database schema development for each app was not going to be slowed by needing to be mutually dependent with each other. As a result avoiding the complexities of managing a canonical model and ensuring any changes to that model are delivered in a manner that aligns across multiple development teams plans.

Although you can see from a marketing position it might not have seemed so great, as the customer incurs more cost and development effort to realize a process of managing people (HCM) and paying them (ERP) for example.

Things have moved on, and as long as SaaS apps reside in a Global Single Instance (GSI) (i.e. same region, account and deployment) then for the major products (e.g. ERP, CX, HCM, etc) are internally integrated so a person change in HCM will propagate to ERP as necessary. This certainly reduces the need for integration, saving effort (and the cost of needing OIC).

The problem now is understanding which entities in the SaaS apps are integrated out the box if you deploy using the GSI manner. If you have been working from an integration/technology view point with ICS and OIC for a while it is very easy to get sucked into thinking you need to repeat the integration. After all explicitly integrating the apps is how we started out.

Oracle also want to make it very easy for non Oracle products to integrate, so OIC documentation and the many very good blogs from product management and the engineering team focus on external integration which does (for me atleast) lead to thinking about the older way of working.

Recommendation

Look to see if you’re working with GSI deployment or not. If it isn’t a GSI setup then the old way of working is required. If it is, then determine whether the entity or processes are out the box integrated. This is probably best approached from the SaaS documentation today.

Useful Links:

May 20 – New OIC Articles

Plenty of good articles published in the last month …

Article / LinkAuthorSubject MatterConnecting
Automate ERP Purchase Order creation using Oracle IntegrationAnkur JainOICERP
HCM Data Extract Processing PatternNiall Commiskey (Oracle Product Mgmt)OICHCM
OIC for Netsuite –> mapping Custom FieldsNiall Commiskey (Oracle Product Mgmt)OICNetsuite
OIC May 2020 release – New FeaturesNiall Commiskey (Oracle Product Mgmt)OIC 
Integration, Process & Insight – Netsuite Data Sync Use CaseNiall Commiskey (Oracle Product Mgmt)OIC, InsightsNetsuite
Basic Error Handling in OIC & Testing of Basic Error Handling in OICAmit Kumar SumanOIC 
Oracle E-Business Suite Integrated SOA Gateway (ISG) In Oracle Cloud (OIC)Atul KumarOICEBS & SOA
Use REST Adapter With Multiple Resources & Verbs In Oracle Integration Cloud (OIC)Atul KumarOIC 
How To Export Business Data & Visual Builder Cloud Service (VBCS) & How To Import Business Data In Visual Builder Cloud Service (VBCS)Atul KumarVBCS 
Slack Adapter for OICDaniel Martins Teixeira (Oracle)OICSlack
Conditional Mappings in Oracle IntegrationThomas Hora (Oracle)OIC 
https://blogs.oracle.com/integration/4-ways-to-innovate-your-connected-erp-and-hcm-initiatives-with-accenture-and-oracleDaryl Eicher (Oracle)OICHCM, ERP
Triggering an OIC integration via OCI Events – the Oracle Functions ApproachStan TanevOICOCI
How to configure REST adaptor to extract bulk leads from MarketoShalindra SinghOICMarketo
How to Find Human Task by Correlation and How to Abort a Parallel TaskJan KettenisPCS 
OIC May 2020 release – New FeaturesNiall Commiskey (Oracle Product Mgmt)OIC 

Page 1 of 2

Powered by WordPress & Theme by Anders Norén