Implementing Oracle Integration Cloud

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

How to create Confidential Applications in OCI IAM for Invoking Fusion Apps Endpoint using OAuth

When seeking a more secure connection method to access Fusion Apps Endpoints (e.g., REST API or Integration Cloud Adapter) beyond basic authentication, OAuth 2.0 is the preferred choice. To implement OAuth 2.0 with Fusion Apps to connect Integration Cloud, you must configure two confidential applications in OCI IAM (formerly known as IDCS – Identity Cloud Service). This article provides a step-by-step guide on setting up these applications for a Fusion Apps Endpoint.

In this introductory blog post, we’ll address how to seamlessly connect Oracle Integration Cloud to Fusion Apps, like ERP Cloud, using OAuth 2.0. Our journey begins with establishing a confidential application in OCI IAM. This crucial step aids in accessing the Fusion Apps Endpoint URL. 

September 2023 – New Additions

Article / LinkAuthorSubject MatterConnecting
Oracle Integration (Gen2): Connecting to UiPathAmy Simpson-GrangeOIC2UIPath
Quick and Short Overview of Oracle Business Intelligence Cloud ConnectorBizinsight Consulting OIC 
Processing HCM Extract data file with OIC ( Oracle Integration Cloud) OICHCM
How To Configure Disaster Recovery Solution For Oracle Integration Cloud?Vancy ArokiaOIC 
How to Regulate access to a project SanddyOIC3DB
Best Practice – Run large number of scheduled integrations at the same time SanddyOIC 
Gen3 – Parallel action | what is the maximum concurrent / parallel OIC scheduled flows limit?SanddyOIC3 
Different types of Translation failure in the mapper using XSD structure of the file contentsSanddyOIC 
Upgrade JDK in your OIC connectivity agentElizabeth EarleOIC 
OIC Integration Dependencies – who calls what?Niall CommiskeyOIC 
OIC3 Factory api – Confidential App ConfigurationNiall CommiskeyOIC3 
Data Sync Strategies with the OIC SFDC AdapterNiall CommiskeyOIC 
What’s New in Oracle Integration 23.10Niall CommiskeyOIC 
New Adapters & Connectivity Enhancements in Oracle Integration Oct’23Niall CommiskeyOICVarious
Lab – Oracle Integration Cloud – Integration, Process and Insight OIC 

OIC-related downloads from Oracle CloudWorld Las Vegas:

August 2023 – New Additions

Article / LinkAuthorSubject MatterConnecting
Scope In Oracle Integration CloudTechtutorstiOIC 
OIC: Reverse Versioning IntegrationsJan KettenisOIC
How to convert XML data to Json data and store it in a variableSanddyOIC
XSD – How to validate if any field is empty while reading the file | add restriction to a schema fieldSanddyOIC
Oracle Integration Cloud – Role-Based Control Access with ProjectsAna Lucero AlvaradoOIC 
How to delete an Orphan Fusion Apps Subscription created by OICJin ParkOIC 
OCI Toolkit for Visual Studio CodeDaniel TeixeiraAdvanced Protection: OIC generation 2 & File Server 
Oracle Integration Cloud – Role Based Control Access with ProjectsDaniel TeixeiraOIC 
Oracle Integration Cloud – ERP Integration Patterns – Real-Time InboundDaniel TeixeiraOIC 
Provision and configure Oracle Integration Cloud instance using TerraformOmid IzadkhastiOICTerraform
Intelligent Document Processing with Oracle Integration Cloud and OCI AI Vision ServiceJerry Mbamo, Nolan Trouvé, Niall CommiskeyOICAI
OCI Logging Analytics OOTB OIC DashboardsNiall CommiskeyOICLogging ANalytics
SFDC User Sync with OIC and other things SFDC adapterNiall CommiskeyOICSFDC
OIC3 Service MetricsNiall CommiskeyOIC3 
OIC 3 Billing Metrics and AlarmsNiall CommiskeyOIC3 
OIC 23.08 New Features (Object Storage, OIC Events, HCM Adaptor, Project Stats, Adaptors)Niall CommiskeyOIC 
OAuth In Oracle Integration CloudTechtutorstiOIC 
Retry In Oracle Integration CloudTechtutorstiOIC 
Oracle Integration Cloud SFTPTechtutorstiOIC 
New Features in Oracle Integration 3! (23.08)Amy Simpson-GrangeOIC3
Syncing Oracle Content Management Documents from PROD to DR using OICBimandsOIC 
Oracle BICC Work Flow with auto file extraction from BICC UCM Server – OICeoracleappsOICBusiness Intelligence Cloud

July 2023 – New Articles

Article / LinkAuthorSubject MatterConnecting
How to become a certified Oracle Cloud expert? Advance your Career – free training and free certification!Jurgen KressOICEverything
Change Oracle Integration request parameters and Authentication using API GatewayOmid IzadkhastiOICAPI
OIC – How to use DB sequence (insert, access)SanddyOICDB
Exposing rest service supporting a file as attachment and JSON request SanddyOIC 
UCM using Oracle ERP Cloud adapter (download, upload)SanddyOICUCM
Transfer file to UCM using tech adaptors (REST upload, ErpIntegrationService SOAP Upload, ErpIntegrationService SOAP Download)SanddyOICUCM
ERP Integration Patterns – Bulk ImportDaniel TeixeiraOICERP
OIC3 OAuth with OCI DomainsNiall CommiskeyOIC3OCI
counting OIC messages for subsidiaries within an organizationNiall CommiskeyOIC 
OIC Projects RBAC – a simple exampleNiall CommiskeyOIC 
OIC & SFDC Streaming API and Platform EventsNiall CommiskeyOICSalesForce
Visual Builder invoking OCI Process AutomationNiall CommiskeyOICVB, OPA
What’s New in Oracle Integration 23.08Niall CommiskeyOICVarious
Oracle Cloud and the power of community in driving digital evolutionJurgen KressOIC 
Oracle Cloud Applications Integration (Part 1, Part 2, Part 3)Su Patel, Mike IsermanOICSaaS
Importing of Data into Oracle ERP Cloud using REST Services through OICRevanth RampellyOICERP

Training provision for OIC appears to be growing:

June 2023 – New Articles

Article / LinkAuthorSubject MatterConnecting
Import data into HCM cloud using HDL import jobKabir YadavOICHCM
Integration to get dynamic email notificationKabir YadavOICemail
Upload / Download file to UCM using GenericSoapPort web serviceSanddyOICUCM
Upload one or more attachments in REST APISanddyOIC 
Read Multi records of different types in a CSV file, and when no default valuesSanddyOIC 
Oracle Integration Cloud Gen3 (OIC3) has over 150 recipesDaniel TeixeiraOIC3Various
Understanding of Oracle Integration-3 EventAnkur JainOIC3 
Observability EnhancementsNiall CommiskeyOIC3 
New Features – Projects – RBAC and other new featuresNiall CommiskeyOIC3 
New Features –> B2BNiall CommiskeyOIC3 
OIC for Netsuite – leveraging the Netsuite REST APINiall CommiskeyOICNet Suite
Oracle Video Hub – IntegrationsOracle  
Oracle Cloud Integration – How Does It WorkRedress ComplianceOIC 
Smarter Apps with Oracle Integration Cloud and OCI AI Services – Partner Community WebcastJurgen KressOIC 
Oracle Cloud HCM Integration Using Oracle PaaS – Patterns & Use CasesRanveer TiwariOICHCM
Oracle Cloud Applications Integration – Part 1: Connecting and Extending Oracle Cloud Applications; Part 2: Built-in Integration FunctionalitySu Patel, Mike IsermanOICVarious
It’s an Oracle Integration popularity contest, and the winner is…Melissa HubbellOIC 
Update Lookup from Oracle Integration CloudBimandsOIC 
Dynamically Populate SMS content within OICBimandsOICSMS
Create Secret Vault to store your Keys and access from OICBimandsOICVault
Establish Secure File Transfer Protocol (SFTP) in OICBimandsOICSFTP

May 2023 – New Articles

Article / LinkAuthorSubject MatterConnecting
Oracle Fusion Cloud Data Extraction Tools OIC eycSaaS
Fortify Visual Builder and Oracle Integration With CloudflareIvan DelićOIC 
Integration Pattern: On-Prem to/from Cloud Integration via OICSanae BekkarOIC 
OIC – ERP Bulk Import – Do we always need to provide manifest or .properties file for a import jobSanddyOICERP
OIC – How to continue FOR EACH loop for any failure caseSanddyOIC 
https://soalicious.blogspot.com/2023/05/oic-convert-csv-file-data-to-json.htmlSanddyOIC 
XSD – Convert XML payload to XSD Schema onlineSanddyOIC 
NEW Oracle Integration Cloud Gen 3Daniel TeixeiraOIC3 
Save request payload into databaseAnkur JainOICDB
OData adapter in Oracle Integration-3Ankur JainOIC3 
DevOps and CI/CD for OCI Integration and API GatewayJürgen KressOIC 
OIC Projects – excellent introductionNiall CommiskeyOIC 
OIC for Oracle CPQ Introduction Niall CommiskeyOICCPQ
OPA 23.04 Release – Invoking OIC IntegrationsNiall CommiskeyOIC 
OIC3 – now includes ProcessNiall CommiskeyOIC3OPA
Simplify development with full life cycle management in OCI Integration (OIC) ProjectAntony ReynoldsOIC 
What’s New in Oracle Integration 23.06Niall CommiskeyOIC3 
Connectivity Enhancements in Oracle Integration – June 2023Madhav PoosarlaOIC 
40+ Oracle Integration Cloud OIC Interview Questions 2023Mahir FayazOIC 
Oracle Integration Cloud (OIC) Courses OIC 

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 

March 2023 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
Secure your OIC Integration using OAuth Security PolicyManish Kumar GuptaOIC 
5 Steps to OIC Observability with Logging AnalyticsTam NguyenOICOCI Observability & Management
OIC ERP – BIP Report Bursting using Email Delivery ChannelSanddyOICERP/BIP
OIC – ERP – Download ESS Job’s output and log file using Erp Integration Service web service in Oracle IntegrationSanddyOICERP
OIC – ERP – Import Account Payable Invoice to Oracle Cloud ERP – FBDI import and Callback (part of a series of posts)SanddyOICERP
IOC and ChatGPT post 958 & 959Niall CommiskyOICChatGPT
Enabling Visual Builder in OICNiall CommiskyOICVisual Builder
OIC B2B – Anatomy of a simple X12 P850 docNiall CommiskyOICB2B
OIC 23.02.2 update – Welcome Visual BuilderNiall CommiskyOIC 
New and Improved Recipes PageKevin HopkeOIC 
Securing Oracle Integration Cloud REST Endpoint For Trigger with OCI IAM OAuth 2.0 Device Authorization GrantAmit ChakrabortyOIC 
SCM Order Management Order Status Integration Best practicesShreenidhi Raghuram & Patrick Mc ErleanOICSCM

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

Oracle Named a Leader and Positioned Highest for Ability to Execute in Gartner® Magic Quadrant™ for Integration Platform as a Service, Worldwide

We are excited and humbled to share that Gartner has named OIC a Leader and Positioned Highest for Ability to Execute in Gartner® Magic Quadrant™ for…

Oracle Named a Leader and Positioned Highest for Ability to Execute in Gartner® Magic Quadrant™ for Integration Platform as a Service, Worldwide

Page 2 of 10

Powered by WordPress & Theme by Anders Norén