Implementing Oracle Integration Cloud

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

Introduction to B2B for Oracle Integration Cloud

In the fast-paced world of business, efficient and seamless integration between trading partners is not just a luxury—it’s a necessity. The B2B management platform for Oracle Integration Cloud provides a robust solution to streamline business-to-business (B2B) communication, ensuring smooth and secure data exchanges. This article is the first in a series where we will explore the various aspects of the B2B trading platform in Oracle Integration Cloud.

B2B in e-commerce, EDI and EDIFACT

Trading is a big part of Business-to-Business (B2B) e-commerce, where businesses extend their operations to seamlessly connect with trading partners. This approach includes traditional business practices, well-established business documents, and industry-proven messaging services. Successful B2B e-commerce demands a robust, unified business process platform that offers comprehensive end-to-end instance tracking, ensuring complete visibility and auditing capabilities.

FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet

There is a spreadsheet which is published by Oracle BI Cloud Adapter Development that documents Fusion ERP and SCM BI View Objects and their corresponding database tables and columns. This post is on community.oracle.com and for a lot of customers not accessible.

Customers can use this spreadsheet to search for BI View Objects (BIVO) to trace the lineage from a BIVO to database tables and columns or vice versa.

Includes R13 releases 13.19A, 13.19B, 13.19C, 13.19D,13.20A,13.20B, 13.20C, 13.20D, 13.21A, 13.21B, 13.21C, 13.21D, 13.22A, 13.22B, 13.22C, 13.22D, 13.23A, 13.23B, 13.23C, and 13.23D.

Download the spreadsheet (rel13_23.x_bicc_fscm_database_mapping_with_viewobjects.xlsx.zip) here instead.

March 24 – New Additions

Article / LinkAuthorSubject MatterConnecting
OIC 24.02 New Features – Observability / REST APINiall CommiskeyOIC3Observability
OIC Rapid Adapter Builder EnhancementsNiall CommiskeyOIC 
OCI Integration Fundamentals: Scope Fault HandlerAmy Simpson-GrangeOIC 
NEW FEATURES in Oracle Integration 3! (24.02)Amy Simpson-GrangeOIC3 
Connecting SuccessFactors to Oracle Fusion HCM via OIC OICSuccessFactors, HCM
Integrating Oracle Fusion SaaS applications with OIC OICFusion Apps
Harnessing Publish and Subscribe EventsMurari KalluriOIC3 
Why you should migrate to OIC Gen3bimandsOIC3 
OIC – XSLT – Find out the sum of all the invoice lines where each line having quantity and price using Call templateSanddyOIC 

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 

December 2023 – New Additions

As we enter 2024, we wish you all the best for the coming year. There is much to look forward to – Niall Commiskey’s 1000th blog post on Oracle Integration. will land soon.

The Oracle Integration Community continues to thrive – we continue to discover new people writing about the subject, and the PaaS Community – which has been there from the birth of what started as ICS remains the touchstone for all things Oracle Integration related from Visual Builder to Process Orchestration in the caring hands of Jürgen Kress.

Article / LinkAuthorSubject MatterConnecting
Oracle OIC Ariba Adapter Capabilities.BiCOICAriba
How To Use Schedule Parameters In OICRaj Baghel OIC 
OIC – ERP – Payables invoice callback – Custom reportSanddyOICERP
OIC – ERP – How to download Import Payables Invoices Report using ERP cloud Adapter SanddyOICERP
OIC – ERP – When to use Fusion Accounting Hub (FAH) vs GL Journal integrationSanddyOICERP
OIC – ERP – Import AP Invoice to Cloud ERP using FBDISanddyOICERP
OIC – Create a resuable integration to write or move and delete files from AWS S3 using RestSanddyOICAWS S3
Publishing OIC endpoints to OCI API Gateway in detailNiall CommiskeyOICAPI Gateway
OIC 23.12 Release New FeaturesNiall CommiskeyOIC 
Fusion Applications Integration with Microsoft Teams : Channel Naming in OICGreg MallyOICMS Teams
Fusion Applications Integration with Microsoft Teams : Custom Header Message in OICGreg MallyOICMS Teams
Oracle Integration Cloud : 5 mistakes to avoid in order to improve your ecosystemAntoine RenciotOIC 
40+ Oracle Integration Cloud OIC Interview Questions 2024Mahir FayazOIC 
Oracle Integration Cloud to SnowflakeFredrik FilipssonOICSnowflake
Create FTP Adapter Connection In OIC Integration 3: Step-By-Step Guide Murari Kalluri OIC3FTP

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

October 23 – New Additions

Article / LinkAuthorSubject MatterConnecting
OCI Process Automation and Oracle Artificial Intelligence in ActionCristian SilipigniOPAAI
Oracle Integration (OIC) Update ScheduleAna Lucero AlvaradoOIC & OIC3 
VB invoking OIC3 OIC3VB
OIC3 VB invoking Process Automation with Identity PropagationNiall CommiskeyOIC3VB
OIC HealthcareNiall CommiskeyOIC 
OIC Projects – RBACNiall CommiskeyOIC 
OIC Events EnhancementsNiall CommiskeyOIC 
OIC3 23.10 – xsl:for-each-groupNiall CommiskeyOIC 
Connecting OCI Process Automation (OPA) REST APIs in Visual AppsAparna GaonkarOPA 
What’s New in OCI Process Automation 23.10Stan TanevOPA 
Intelligent Document Processing in OCI Process AutomationStan TanevOPA 
(OIC)Dynamic Updation Of OIC Lookups Using Rest APIJoel RajiveOIC 
DB polling and logical delete from oracle database in Oracle IntegrationSanddyOICDB
Read file in segment – Set your own chunk sizeSanddyOIC3File
Create a Reusable integration to pass Request Payload into Database table as clob typeSanddyOICDB
Save Integration request payload XML/JSON into databaseSanddyOICDB
Connectivity agent basic authentication not supported – Support only OAuth 2.0 for Connectivity agentSanddyOIC3Agent
Split comma separated string values to Array – Use of create-nodeset-from-delimited-string() function in XSLTSanddyOIC 
How to create an HDL file and upload it to Oracle HCM using Oracle IntegrationAnkur JainOICHCM
Filter Unique records using for each group in Oracle IntegrationAnkur JainOIC 

Pre-requirements for creating Fusion ERP connection in Oracle Integration Cloud

To be able to successfully create a connection between Oracle Integration Cloud and Oracle Fusion Apps, for example ERP Cloud, there are some pre-requirements to perform. If we want to connect Integration Cloud with Fusion Apps it is in most cases required to import OAuth signing keys from the OCI IAM used by Integration Cloud into Fusion Apps Console. This article provides a step-by-step guide on setting up these pre-requirements.

In our last article, we tackled the process of linking Oracle Integration Cloud with Fusion Apps, like ERP Cloud, through OAuth 2.0. As we navigated the setup, we detailed the creation of two confidential applications in OCI IAM to tap into the Fusion Apps Endpoint URL. But before you dive into the Oracle Integration Cloud configurations, there are essential prerequisites to bear in mind. Neglecting these could lead you to grapple with numerous CASDK-0004 errors when you give the connection in Integration Cloud a test run.

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. 

Page 1 of 10

Powered by WordPress & Theme by Anders Norén