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

Tag: Oracle Page 2 of 7

February 2023 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
Invoke NHS using JWT Assertion in Oracle IntegrationMadhav Poosarla / Akshaya HebbarOIC 
OIC3 New Features announcementNiall CommiskeyOIC3 
Rapid start on ERP & HCM Integrations with Oracle MICROS Simphony Labor using OIC PrebuiltsPrakash MasandOICERP, HCM, Micros Simphony
New Adapters & Connectivity Enhancements in OICMadhav PoosarlaOICNetezza, SAP Concur, Shopify
Embedding Oracle Integration Insight dashboards : Quickly and EasilySandhya Lakshmi GopalanInsights 
Check out these two new tutorials for the Oracle Integration GEN 3!Daniel TeixeiraOIC 
Run Child integration or PL/SQL procedure in batches in Oracle IntegrationPawan LakhotiaOICDB
OIC and OCI Logging AnalyticsNiall CommiskeyOICOCI Logging
OIC 23.02 Release (Part 1, Part 2)Niall CommiskeyOIC 
Enhancing OCM Document OIC workflow process with an integrated Assets UXJohn SimOICOCM
Enhancing OCM Document OIC workflow process with an integrated Assets UXJohn SimOICOCM

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)

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 

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

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

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

May 22 – New OIC Articles

May means we see another quarterly release with new features as we can see by the types of blog posts collected this month

Article / LinkAuthorSubject MatterConnecting
OIC and OCI Logging ServiceNiall CommiskeyOICOCI Logging
End to End Business Process Automation with OIC Part INiall CommiskeyOIC (Integration & Process)OCI Events, Object Store, Notification Service
May 2022 Oracle Integration UpdateNiall CommiskeyOICVarious
Native Payload Support in Activity Stream with May’22 ReleasePrakash MasandOIC 
OIC May 22 release New Features – QuickBooks AdapterNiall CommiskeyOICQuickbooks
How to Update Java on Oracle Integration Cloud On-premise AgentHritik Tyagi OIC 
Suppliers to Oracle VB synch using Oracle IntegrationAnkur JainOICERP
Convert string date from one format to another in Oracle IntegrationAnkur JainOIC 
Use of Root Certificates in OIC, a Best PracticeMilad ShirazOIC 
Read files from Object Storage in Oracle IntegrationAnkur JainOIC 
Push records in batches to target service in Oracle IntegrationAnkur JainOIC 
May’22 Oracle Integration-Third Party Adapters EnhancementsMadhav PoosarlaOICJIRA, Magento, SAP, Zendesk
Migrate Oracle Integrations with Security artifactsAnkur JainOIC 
How to extract data from Oracle Fusion using REST APIs in OICAnkur JainOICERP
OIC – Export an Integration Using REST API SanddyOIC 
OIC – limitation of using Staging areaSanddyOIC 
https://soalicious.blogspot.com/2022/05/oic-schedule-bi-publisher-report.htmlSanddyOIC 

Sources of knowledge and learning provided by Oracle

The resources provided by Oracle for learning about their technologies are substantial but distributed. This to an extent is another manifestation of Conway’s Law.

I have however tried to compile and describe those resources here. This list does extend beyond OIC but we hope it helps build on top of our monthly summary.

Page 2 of 7

Powered by WordPress & Theme by Anders Norén