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

Category: CollectedArticles Page 1 of 5

Feburary 24 – New Additions

Article / LinkAuthorSubject MatterConnecting
Adapting to Instance ID Changes when Upgrading to Oracle Integration 3Ravi ChablaniOIC3 
Hybrid Integrations with Oracle Platforms & ServicesKathiravan UdayakumarOIC 
OIC Healthcare UpdatesSteve TindallOICHL7 (Healthcare)
Build Your First Adapter with the Rapid Adapter Builder in Oracle IntegrationMadhav PoosarlaOIC 
Revolutionizing Integrations with the Rapid Adapter Builder (RAB) in Oracle IntegrationMadhav PoosarlaOIC 
Bulk loading data into Oracle Autonomous Data Warehouse (ADW) using Oracle Integration Cloud (OIC) and with improved performance OICADW
How To Call Schedule Integrations In OIC Using REST API?Priyanka PatraOI?C 
Two Methods to receive Callback/Business Events from ERP – OAuth(New) and CISF Keys(Old)SanddyOIC 
Detailed implementation steps to import transactions to ERP Fusion accounting hub or ERP FAH sub ledger accountingSanddyOICERP
How to select a Layout while invoking BI Report SanddyOICERP
Create a Reusable Outbound integration – Run outbound interface reports to create outbound filesSanddyOIC 
Understanding of Salesforce REST Adapter in Oracle IntegrationAnkur JainOICSalesforce
AS2 Trigger / InvokeNiall CommiskeyOICFile
OIC Service Metrics and OCI DashboardsNiall CommiskeyOIC 
https://niallcblogs.blogspot.com/2024/02/1007-oci-policies-for-devlive-lab.htmlNiall CommiskeyOICOCI Policies
OIC Rapid Adapter Builder resourcesNiall CommiskeyOIC 
Rapid Adapter Builder Part 3Niall CommiskeyOIC 
Leveraging Logging Analytics for Oracle Integration Cloud Logging and Monitoring (Part 1, Part 2)Royce Fu, Nolan Trouve  
Troubleshooting tips when hitting rate limits for Oracle Integration Cloud File Server and Oracle Identity Cloud ServicesNick MontoyaOIC 
Exploring JavaScript Libraries in OICMurari KalluriOIC 
Exposing SOAP Services in OIC 3Murari KalluriOIC3SOAP
How to Write Files using OIC FTP Adapter : Effortless File ManagementMurari KalluriOIC3File

January 24 – New Additions

Congratulations to Niall Commiskey – hitting that magic 1000 blog posts. As it happens, this author’s blog also hit that threshold. But has taken a lot longer.

Lots of exciting capabilities have been in the December feature update, so we’re expecting to see some interesting posts in the coming months

ArticleAuthorSubject MatterConnecting
Supplier Conversion from Oracle EBS or any Other On-Premise/Cloud system to Oracle Fusion with FBDI/OICOIC (FBDI)EBS to Fusion
Streamlining Expense Invoices Integration of Expense Invoices created Concur with Oracle General Ledger CloudOIC (FBDI)Concur
Upgrade to OIC3 :Some considerationsSanae BekkarOIC3 
OIC – Run a Schedule Integration now from oracle integration and retrieve Scheduled Integrations Run StatusSanddyOIC 
submit ess job – sending multiple parameters call BI Bursting – sending two reportsSanddyOICERP
create an integration to send outbound ERP File using BI bursting FTP delivery channel and ESS job (outbound)SanddyOICERP
Monitor Progress of ESS job and return statusSanddyOICERP
Send custom Invoice report using Ess Job call and BI bursting reportSanddyOICERP
Invoice BI Report SQL query to get custom detailed reportSanddyOICBI Report
Get Source Name for invoice callback SanddyOIC 
Cloning and Backing up the Oracle Integration InstanceAnjur JainOIC 
Advanced Oracle Integration Capabilities – Partner Community Webcast January 30th 2023Jurgen KressOIC 
Connect Oracle Cloud Applications (HCM, CX, ERP) with Oracle Integration – Webcast series January & February 2024Jurgen KressOIC 
What’s New in Oracle Integration 24.02Niall CommiskeyOIC 
Configure the OIC Connectivity Agent as a Windows ServiceRavi PintoOIC 
GCP Pub/Sub adapterNiall CommiskeyOICGCP Pub/Sub
GCP Storage AdapterNiall CommiskeyOICGCP Storage
Create your own adapter with the Rapid Adapter Builder (Part 1) Part 2Niall CommiskeyOIC 
Integrating with Monday.com using GraphQL adapterNiall CommiskeyOICMonday.com
24.02 New Features – Testing FeatureNiall CommiskeyOIC 
Oracle Integration Cloud (OIC) and OCI Process Automation (OPA) – OpenAPI SupportPeter ObertOIC 
Oracle Integration Cloud (OIC) as Low-code PlatformPeter ObertOIC 
Granting Instance Access in OIC Integration 3 [User Access Guide]Murari KailuriOIC 
Upgrade to JDK17Milad ShirazOIC 

November 2023 – New Additions

Sorry for the delay this month; things have been more than a little hectic. This month, we have content from the usual suspects, but the Oracle A-Team has also been very busy publishing details on connecting Oracle Fusion Cloud with Microsoft Teams. It may not be as groundbreaking as the recent news about the Oracle database in Azure, but for many, this will make a lot of difference.

Article / LinkAuthorSubject MatterConnecting
Creating an Oracle Integration 3 Instance in Oracle CloudAmy Simpson-GrangeOIC3 
OCI Integration: VersioningAmy Simpson-GrangeOIC 
Integration of Coupa and Oracle Payables Fusion Cloud via Oracle Integration CloudBizInsightOICCoupa, Payables
Oracle Integration: How to replace a Connection by one with a different role?Jan KettenisOIC 
How To Replace Connections In OIC?Bushra BanoOIC 
How To Apply Hold On Duplicate Invoices In Fusion Using Rest API In OIC?Fiza KhanOIC 
Oracle Integration (OIC) with Publish and Subscribe Pattern: How to Manage EventsCristian SilipigniOIC 
Get files from AWS S3 using Rest serviceSanddyOIC 
Update OIC lookups based on BI reports invoke and config fileSanddyOIC 
Import (Replace) a Lookup – Update an existing OIC Lookup based on base64 encoded CSV file as rest feedSanddyOIC 
Oracle Integration Cloud Standard vs EnterpriseNiall CommiskeyOIC 
Integration with RabbitMQ on CloudAMQPNiall CommiskeyOICRabbitMQ
OIC Healthcare: MLLP Adapter Part I, Part IINiall CommiskeyOICMLLP / HL7
Monitoring Fusion Events in OICNiall CommiskeyOICOCI Events
Fusion Applications Integration with Microsoft Teams: Modifying Fusion ApplicationsMaximilian FroeschlOICMS Teams, Fusiobn Apps
Fusion Applications Integration with Microsoft Teams Introduction to Extending the Sample, ArchitectureAngelo SantagataOICMS Teams, Fusiobn Apps
Oracle Fusion Applications Integration with Microsoft Teams now availableAngelo SantagataOICMS Teams, Fusiobn Apps
Fusion Applications Integration with Microsoft Teams : Adding a New Fusion Business Object to OICGreg MallyOICMS Teams, Fusiobn Apps

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

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 

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

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.

Page 1 of 5

Powered by WordPress & Theme by Anders Norén