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

Category: General Integration Page 1 of 3

April 2023 – New Articles

Oracle will be running over the next couple of months a Webcast series about how to use OIC to connect and extend Oracle SaaS solutions covering ERP, HCM, Netsuite, and more. For more on these free events, go here.

Article / LinkAuthorSubject MatterConnecting
OIC – Create an API Gateway to call Oracle Integration REST serviceSanddyOICAPI Gateway
Secure your OIC Integration using OAuth Security PolicyManish Kumar GuptaOIC 
VBCS Fixed Credentials Configuration for backend API Service ConnectionManish Kumar GuptaVBCS 
How to call Oracle ESS Job and Register Callback in Oracle IntegrationAnkur JainOICEnterprise Scheduler
OPA 23.04 Release – Invoking OIC IntegrationsNiall CommiskeyOICOracle Process Automation
Creating a user in IDCS from OICNiall CommiskeyOICIDCS
OIC 23.04 New Features – OData AdapterNiall CommiskeyOIC 
OIC 23.04 New Features – Projects and ObservabilityNiall CommiskeyOIC 
OIC 23.04 New Features – Stage File ReadNiall CommiskeyOICFile
OIC 23.04 New Features – Configurable WAIT ActionNiall CommiskeyOIC 
OIC 23.04 New Features – OCI Functions ActionNiall CommiskeyOICFunctions
OIC 23.04 New Features – EventsNiall CommiskeyOIC 
Using Integrations natively with Process Automation based business processesArvind VenugopalOICOracle Process Automation
Accelerate Your Business Time-to-Value with Prebuilt Integration Recipes and a Low-Code Platform Designed for SaaS Extensions and ConnectionsFrank Della RosaOICSaaS
Deep Dive into Integration Retries during the failureMadhav PoosarlaOIC 
Oracle Integration Publish/SubscribeMilad ShirazOIC 
OCI Process Automation – File Manager ComponentStan TanevOICOracle Process Automation
What’s New in Oracle Integration 23.04 — April 2023Niall CommiskeyOIC 
New Adapters and Connectivity Enhancements in Oracle Integration – April 2023Madhav PoosarlaOICOData, Primavera, Postgres, Netezza, ServiceNow, SAP/4HANA, Amazon Selling Partner,
How To Design A Callback Integration In OIC (Oracle Integration Cloud)Fiza Khan OICERP
Uses Of Oracle VBCS And OICVancy ArokiaOICVBCS
How to call Oracle fusion ESS job from OIC OICESS
OIC Integration to Create Journals in Oracle GL Cloud from Concur Expense Invoices OICERP
Create OIC flow to update Oracle SaaS WO Header and DFF Attributes  OICERP
Oracle HCM cloud to OFS Integrations to Integrate Employees/Resources/Users (other OFS posts Activity Status, OFS Integration , Resource Data, Interrupt Activity) OICHCM, Oracle Field Services
Configuring a Disaster Recovery Solution for Oracle Integration CloudAtefeh (Ati) Yousefi-Attaei, Catalin AndreiOIC 

January 2023 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
OIC gen 2 upgrades to OIC 3Niall CommiskeyOIC3 
OIC Billing Metrics – how many messages is each integration consuming?Niall CommiskeyOIC 
OIC 22.12.1 Release – New Features –> Parallel ProcessingNiall CommiskeyOIC 
OIC integration with OCI QueuesNiall CommiskeyOICOCI Queue
OIC Mailchimp adapterNiall CommiskeyOICMailchimp
OIC QuickBooks Adapter – first stepsNiall CommiskeyOICQuickBooks
Configure connection between OIC and Autonomous Database in OCIDawaa TamanggOICAutonomous DB
Oracle Integration Cloud #1 in GartnerDaniel TeixeiraOIC 
Embedding Oracle Integration Insight dashboards : Quickly and EasilySandhya Lakshmi GopalanOIC 
Oracle Integration Generation 2 to Oracle Integration 3 Upgrades Are BeginningMilad ShirazOIC and OIC3 
Calling an Oracle Integration Cloud integration from OCI Data Integration Data flow using a Generic REST connection Part1, Part2, Part3Pavan RajalbandiOICOCI Data Integration
Access Oracle Autonomous Database (ADB) resides in Private Subnet via Oracle Integration Cloud (OIC) connectivity agentManish Kumar GuptaOICADB
Features of Oracle Integration 3Ankur JainOIC3 
Parallel Execution of ActionsAnkur JainOIC3 
Event based Streaming Integration for SCM Items LoadShreenidhi RaghuramOICFusion SCM Product Development (Product Data Hub – PDH)

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 

October 2022 – New OIC Articles

With Oracle Cloud World behind us and the customer/partner forum that occurred on the Monday before the main conference. I think we can expect to see more content following soon.

Article / LinkAuthorSubject MatterConnecting
Oracle Integration 3 invoking OCI Process AutomationNiall CommiskeyOIC3OPA
OCI Process Automation -> DecisionsNiall CommiskeyOPA 
Process Automation – Invoking Child Processes and Business KeysNiall CommiskeyOPA 
OCI Process Automation – LocalizationNiall CommiskeyOPA 
Secure Oracle Integration Cloud (OIC) using OCI WAF (Web Application Firewall)Omid IzadkhastiOICWAF
Monitoring Integrations in Oracle Integration Cloud (OIC) Part1, Part2, Part3, Part4Amy Simpson-GrangeOIC 
Autonomous Transaction Processing (ATP) Adapter in OICGiri PrasadOICATP
Structured Process Custom Fault Handling PatternJan KettenisOIC 
OIC Basics – Using the Mapper Code WindowYan ScorrerOIC 
How To Call DB Procedure Asynchronously From OICAyyappa MaturiOICDB
Invoke BIP Report with Parameters in OICPawan LakhotiaOICBIP

August 22 – New OIC Articles

August is a special month for OIC as we see the launch of Generation 3 of the product. The biggest differences are under the hood, with the core engine moving from a WebLogic basis to running on top of Cloud Native OCI services. As a result, the solution will be able to more efficiently leverage other OCI features to deliver enhancements. Not all of the Gen2 features are running on Gen3, we can expect things to follow quickly. When looking at documentation you’ll need to watch out for references to Oracle Integration Generation 2 vs. Integration Generation 3.

Not only do we have Integration Generation 3, but a new independent Process Automation solution was launched in March.

To help differentiate the articles, where we can we’ll continue to refer to the Process automation that resides within OIC as PCS using the legacy name. Anything referring to the new Process Automation service we’ll identify as OPA. Differentiating Integration Generation 2 or 3 will be OIC2 or OIC3, respectively. If there is no generation number, then at this stage, you can assume the answer is quickly true to both generations.

Article / LinkAuthorSubject MatterConnecting
OIC August 2022 Release New FeaturesNiall CommiskeyOIC 
Exposing OIC Process Task Payloads in Visual BuilderNiall CommiskeyPCS 
OIC & API Gateway – effective use of DeploymentsNiall CommiskeyOICAPI GW
OCI Process Automation now availableNiall CommiskeyOPA 
OCI Process Automation in more detailNiall CommiskeyOPA 
OCI Process Automation – ConnectorsNiall CommiskeyOPA 
Oracle Integration 3 – More than simply a New look and FeelNiall CommiskeyOIC3 
OCI Process Automation – Dynamic ProcessesNiall CommiskeyOPA 
OIC CX Event Subscription – Fusion and OIC SetupNiall CommiskeyOICCX
Oracle Integration – OCI MetricsNiall CommiskeyOICOCI Metrics
OCI Dashboards for OICNiall CommiskeyOICOCI Dashboards
Create User for Oracle Integration cloud in Oracle Cloud Infrastructure aka OCIDawaa TarmanggOICIAM
Get object from OCI object storage using OIC & OIC How to use OCI Object storage from the Oracle Integration Cloud SanddyOICOCI Storage
OIC Tracing | How to enable and use OIC TracingSanddyOIC 
OIC To ERP – Design steps for Import and Custom callback & Improved Custom CallBack Part 2SanddyOICEBS
Create a header file based on sequential unique lines Transaction numberSanddyOIC 
Create OIC Decision model from Scratch, Create a Decision model based on expressions, SanddyPCS 
The “MOVENOOP” IO operation for “/test/Emp_1.csv” failed: Oracle Integration File adapterAnkur JainOIC2 
Service Integration Account with No Password Expiration in OICAnkur JainOIC 
BASE64Decoder: Error in encoded stream: Oracle IntegrationAnkur JainOIC 
All About Oracle Integration AgentAnkur JainOIC2 
New OCI Process Automation Gen3 – Some of the UI Enhancements DemoMilomir VojvodicPCS3`
Use Oracle Integration to connect E-Business Suite with SOA to Financials Cloud, Use Oracle Integration to connect E-Business Suite with SOA to Financials CloudPaulo MotaOICEBS, Financials Cloud
Connect OIC with Public Load Balancer having DBaaS in private subnet as Backend setShivang PandyaOICOCI LB & DB
Promote Integrations across OIC instances using Visual Builder StudioVernon SaldanhaOIC 
Simplifying Oracle Unity Integration using OIC Unity AdapterMadhav PoosarlaOICUnity
Aug’22 Oracle Integration-Third Party Adapters EnhancementsMadhav PoosarlaOICVarious
Introducing Oracle Cloud Infrastructure Process AutomationArvind VenugopalOPA 
40+ Oracle Integration Cloud OIC Interview Questions August 2022Mahir Fayaz OIC 

July 22 – New OIC Articles

July’s big news is the connectivity between OCI and Azure for Oracle to streamline Azure users accessing Oracle databases (here), and more importantly, for OIC users is the addition of new Sovereign nation regions (here). For OIC users this means the possibility of handling data that is more sensitive to where the data resides.

Article / LinkAuthorSubject MatterConnecting
Extending Opera Cloud with OICNiall CommiskeyOIC & VBOracle Hospitality (OPERA)
End to End Business Process AutomationNiall CommiskeyOICAI Vision
Jira Adapter – Add Attachments etcNiall CommiskeyOICJIRA
Update Oracle Integration Cloud connection from primary to standby database dynamicallyOmid IzadkhastiOICDB
Git source code management for Oracle Integration Artifacts using VB StudioAshritha MalliOIC. VBS 
Making use of variables, properties and schedule parameters anYan ScorrerOIC 
Invoke OIC Integration from Process application (plus other short posts on OIC)SanddyOICPCS
Create process application with web form (plus other short posts on PCS)SanddyPCS 
OCI API GW & JWT to call OIC with/without Credentials (Part I & Part II)Ankur JainOIC 
Automation and AI – Oracle Process Automation with OCI AI ServicesMilomir VojvodicOICAI

October 21 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
Field Level Encryption with Oracle Integration and OCI VaultStan TanevOIC, Vault 
Process Excel files with OIC + Oracle FunctionsStan TanevOICExcel
Setup Email Notifications with the Oracle Integration CloudDaniel TeixeiraOICOCI Email
Oracle Integration Cloud – Twilio Adapter for SMS and WhatsAppDaniel TeixeiraOICTwilio
Visual Builder – A Crash Course by Shay ShmelzerShay ShmelzerVBCS 
Configuring OIC NotificationsNiall CommiskeyOICOCI Notifications
Leveraging Grafana for OIC MetricsNiall CommiskeyOIC 
Using OIC Logging Analytics for searching OIC Activity Stream logNiall CommiskeyOICOCI Log Analytics
Surfacing OIC Design Time audit logs in OCI Logging AnalyticsNiall CommiskeyOICOCI Log Analytics
Using OCI Logging for searching OIC Activity Stream LogNiall CommiskeyOICOCI Log Analytics
OIC docs link for restricting access to OIC instancesNiall CommiskeyOIC 
Create a fixed-length file in Oracle IntegrationAnkur JainOIC 

OIC Scheduling for End of Month style processes – Tip #11

Setting up calendar schedules that aren’t simply reoccurring, such as a specific date in a month like 28th or third Friday, become more of a challenge with the OIC Scheduler. The calendar works with the ical standard set by the IETF standard 2445. If you review the standard’s section 4.3.0, this describes the reoccurrence options, whilst able, not able to address these needs.

Reoccurring on specific dates can, in theory, be set. If you review section 4.3.4, you will see a date has the potential to be defined as a comma-separated list. So multiple dates for month-end can be provided as a list. Note, this is predicated on the calendar attribute supporting date-mday (DATE). The DTSTART and DTEND attributes accept DATE with no indication that the date-mday is not supported.

Specifying the dates explicitly overcomes the problems of national holidays. The downside is that you need to know when the list needs to be extended and, in the case of OIC, the means to edit the scheduler format safely.

NOTE: we have not tested whether the OIC scheduler is compliant with the use of date-mday at the time of writing.

Versions 1 and 2 running concurrently

Complex formulas for scheduling and more manageable scheduling..

There are several options for managing reoccurring events, such as month-end, year-end accounting, payroll and expenses payments etc.

In most options, we assume that we have a simple reoccurring schedule that triggers an integration that determines whether the trigger is legitimate. This could be as simple as daily. If valid, then invoking the main integration with the business process.

Defining Dates in the database, we can wrap it with JET, Visual Builder or APEX to create a presentation layer. The task of managing the schedule to be taken on by the business.

This approach makes it very easy to adjust and test. Whether there are any more future schedule dates can also be overcome by having an integration that queries the table for the next date being set. If not date set, then the generate relevant alerts using OCI native tools.

The schedule is triggered regularly, e.g. daily, and the scheduler trigger invokes an integration then looks up the DB to see if the date appears in the list. When the date appears, then the integration is executed. It would be straightforward to extend this to trigger different schedules.

Automated option

If an algorithm can be described for when the month-end processes should be performed, we eliminate the need to manage a list of dates. There are some ways to implement a formula, and you have the option of trying to do it OIC, but using OCI Functions – the formula is coded in the language of your choice and then packaged and deployed. The Function is then invoked using a REST web service to confirm whether the process should run (more on how here).

Handling public and national holidays. Not all national holidays are locked into an algorithm, or the holiday is fairly complex. That said, there are several API sources available that can tell you these dates, for example, https://holidayapi.com; this makes things easier.

The beauty of this process is that the same Function could keep a company website up to date with the next run date. Be integrated into corporate notifications and so on. As a result, one point of truth.

Enhanced Automation (feature wish …)

Unfortunately, OIC doesn’t provide an API to add new schedules. We can’t simplify the integration logic until it does, which adds the next calculated date for the process to run as a one-off schedule.

iCal Resources (inc Tools)

July 21 – New OIC articles

Article / LinkAuthorSubject MatterConnecting
Oracle Integration Cloud (OIC) & octet-stream MIME-typeAmy Simpson-GrangeOIC 
delete a schedule from an IntegrationKabir YadavOIC 
How Granular Should My Microprocesses Be?Jan KettenisPCS 
How to perform FBDI GL File UploadDeb MukherjeeOIC 
Load FBDI and callbackDeb MukherjeeOIC 
Basic File Encryption and Decryption in OICDeb MukherjeeOIC 
Oracle Digital Assistant – Backend Integration with the Oracle Integration CloudDaniel TeixeiraOICODA
Oracle Integration Message Packs and PricingAnkur JainOIC 
Business Identifiers in Oracle IntegrationAnkur JainOIC 
FlexDeploy Support for Oracle CloudJurgen KressOICCI/CD
OIC & Blue Prism Part 1, Part 2Niall CommiskeyOICBlue Prism (RPA)
August 2021 Oracle Integration UpdateAntony ReynoldsOIC 
OIC Monitoring and Logging Analytics – adding Business Data to DashboardsNiall CommiskeyOICLog Analytics
OIC and Logging Analytics – steps towards fleet management and more stepsNiall CommiskeyOICLog Analytics
Logging Analytics for OICNiall CommiskeyOICLog Analytics
Event Driven Integration with Oracle Commerce CloudNiall CommiskeyOICCommerce Cloud
Turning SFTP Cloud NativeJohan LouwersOIC 
Authenticating Oracle Integration flows using OAuth token from 3rd party providerPrakash MasandOICOAuth
August 2021 New Third Party Application AdaptersPrakash MasandOICSAP, Zendesk

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 

Page 1 of 3

Powered by WordPress & Theme by Anders Norén