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

Tag: articles Page 1 of 3

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

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

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

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 

Page 1 of 3

Powered by WordPress & Theme by Anders Norén