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

Tag: ERP

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 

March 20 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
How to schedule OIC integration and iCal ExpressionAmit Kumar SumanOIC (Scheduling) 
Oracle Field Service Adapter and another part hereNiall Commiskey (Oracle PM)OICOracle Field Service
OIC – Service Bus integrationNiall Commiskey (Oracle PM)OICSOA OSB
Manage Custom Object in Salesforce using Oracle Integration Salesforce Adapter !!!Manish Kumar Gupta (Red Thunder)OICSalesforce
OIC Space Management simplifiedSindhu Suresh (Oracle Tech Lead)OIC 
Use Global Variables and Data Stitch to log request payloadsThomas Hora (Oracle Snr Dir of Development)OIC 
Use Data Stitch to simplify integrationsThomas Hora (Oracle Snr Dir of Development)OIC 
HDL(HCM Dataloader)support in HCM cloud AdapterAsawari Pawar (Oracle Tech Team)OICHCM
Interfacing to EPBCS with OICBarry Goodsell (Zomy)OICEPBCS
Invoke a Co-located Integration from a Parent IntegrationDaniel Martins Teixeira (Oracle Tech Solution Engineer)OIC 
When and How to Create an Integration to Call a Service from a Process?Jan KettenisOIC 
Object Storage with Oracle Integration Cloud – Part 2 (Part 1 – Jan 20)Red ThunderOICOCI
Machine Learning in Digital Process Automation — Part II (Part 1)Ralf Mueller (Oracle)OICOracle Machine Learning
See How Easily You Can Access Integration’s metadataVenkatesh Mohanram (Oracle)OIC 
Trigger OIC Integration Using OAuth Client CredentialsGreg Mally (Oracle A-Team)OIC 
Obtaining All Rows from a REST Action using Recursive Action Chain CallsDuncan Mills (Oracle)VBCS 
Oracle Integration Cloud pricing explained – OCI vs ClassicRobert van Molken (Amis)OIC 
Access OIC REST based Integrations using OAuth Token (No Password Expiry For Basic Auth User Anymore)Manish Kumar Gupta (Red Thunder)OICREST
Extract data based on multiple columns from lookup in OICAnkur JainOIC 
Simplified Test Driven Development With Oracle Visual BuilderShay Shmeltzer (Oracle PM)VBCS 
ERP Adapter in Oracle Integration CloudAnkur JainOICERP Cloud
Subscribe Oracle ERP Business Events in Oracle IntegrationAnkur JainOICERP Cloud
Netsuite Custom Field DiscoverySandeep Deshpande (Oracle)OICNetsuite
Implementing Search-As-You-Type in Oracle Visual BuilderDuncan Mills (Oracle)VBCS 
New Features In Oracle Visual Builder – March 2020Shay Shmeltzer (Oracle PM)VBCS 
Boost Your WebForm Productivity with our New Expression Builder FeaturesNicolas Damonte, and Kalyn Chang (Oracle)PCS 
New March OIC Released Features include Kafka ,Slack , NetSuite adaptors (NOB Other additions covered by blogs)OracleOICKafka, Slack, NetSuite (Async)
Kafka Adapter for OICDaniel Martins Teixeira (Oracle)OICKafka
FastConnect and VPN with Oracle Integration CloudJack Desai (Oracle)OIC 
Processing an Incident in ServiceNowNiall Commiskey (Oracle PM)OICServiceNow
Netsuite adapter – processing CustomersNiall Commiskey (Oracle PM)OICNetsuite
Weblogic JMS adapterNiall Commiskey (Oracle PM)OICJMS
Visual Builder – Understanding Backends and ServersAparna Gaonkar (Oracle)VBCS/OIC 

Powered by WordPress & Theme by Anders Norén