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

Tag: ICS Page 1 of 4

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

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

April 22 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
OIC & OAuth 2.0 (Part 1, Part 2, Part3)Niall CommiskeyOIC 
OIC Responsys AdapterNiall CommiskeyOICResponsys
OIC On OCI Status PageElizabeth EarleOIC 
Create Schedule Service SOAP ConnectionKabir YadavOIC 
Schedule BI Publisher Report through OIC Kabir YadavOICBI Publisher
Subscribe to HCM Updates ( via ATOM Feed ) Kabir YadavOICHCM
Configure Oracle HCM Cloud Adapter ConnectionKabir YadavOICHCM
Subscribing to Business Events in OICYan ScorrerOIC 
Split a CSV file into multiple based on a column in OICAnkur JainOIC 
https://www.techsupper.com/2022/04/how-to-call-oracle-saas-ess-job-using-oracle-integration.htmlAnkur JainOIC 
How to create and test custom ESS job in Oracle SaaSAnkur JainOIC 
Reading the latest file from SFTP in OICAnkur JainOIC 

December 21 – New OIC Articles

December is always a quiet month having had updates in November, but this month has been particularly so. One bit of good news, the handy resource links have been updated with a lot more additional resources – see right of the page.

Article / LinkAuthorSubject MatterConnecting
CI/CD working with EiPaaS Oracle Integration (OIC)Cristian SilipigniOICCI/CD
Speed up your Accounting Closing Cycle with automated loading of Payable Invoices into Oracle ERP Cloud, using Oracle Integration CloudJuan CarlosOICCX/ ERP/ ServiceCloud
Quarterly UpdatesPhil WilkinsOIC 
Using the Oracle Cloud Infrastructure Streaming Service Adapter with Oracle IntegrationOICStreams
Build retry logic in Oracle IntegrationAnkur JainOIC 
Call VB Business Objects from Oracle IntegrationAnkur JainOIC 

Jan 21 – new OIC articles

Article / LinkAuthorSubject MatterConnecting
Invoke BI Report in OICKabir YadavOICBI
Read BI Report base64 encoded responseKabir YadavOICBI
OIC: The Micro Process Feature Making Life EasierJan KettenisOIC
API Gateway Integration: Quick and EasyVarinder KaurOICAPI
Automatic reactivation of Integration after a connection updateShubham AgrawalOIC
Replace Trigger in OrchestrationVijay KendaiOIC
Unlock new patterns of integration by controlling the HTTP Response status in OIC REST based integrationsAnuj KaushalOIC
February 2021 Oracle Integration UpdateAntony ReynoldsOIC
The OCI Designer Toolkit Documentation Generation (Not tested but assumed to also work with OIC)Andrew HopkinsonOCI
OIC February 21 New Features – B2B Trading Partner ManagementNiall CommiskeyOICB2B
OIC –> Process ArchivingNiall CommiskeyOICObject Storage
OIC –> JSON ObfuscationChris PeytierOIC
Simple Fusion ERP – OIC DemoNiall CommiskeyOICFusion Apps (ERP)
OIC – Tagging Instances for Feb 21 upgradeNiall CommiskeyOIC
OIC and Oracle Hospitality (OHIP)Niall CommiskeyOICOracle Hospitality
Protecting your OIC apis with OCI API GatewayNiall CommiskeyOICOCI API
Consolidate tasks from Oracle applications cloud and other applications into a single list of tasksMani KrishnanOICSaaS
Integration Insight in Oracle IntegrationThanos Terentes PrintziosOICInsights

July 20 – New OIC Articles

Its been a busy month when it comes to blogging for the folks at Oracle, as July saw a new quarterly release with new usability improvements and connectors.

Article / Link Author Subject Matter Connecting
Sugar CRM 2 Netsuite Integration with OIC REST Adapter Niall Commiskey (Oracle PM) OIC Sugar CRM, Netsuite
OIC integrating BigCommerce with Netsuite Niall Commiskey (Oracle PM) OIC BigCommerce, Netsuite
Shopify: (Adaptor Pagination, Product Inventory Updates) Niall Commiskey (Oracle PM) OIC Shopify
OIC – SurveyMonkey 2 Netsuite Synchronisation Niall Commiskey (Oracle PM) OIC Survey Monkey, Netsuite
OIC moving to a Quarterly Release Cycle Niall Commiskey (Oracle PM) OIC
OIC 4 Netsuite – Implementing a Generic Error Handler Niall Commiskey (Oracle PM) OIC Netsuite
See how OIC integrations are behaving at runtime Ankur Jain OIC
Oracle Integration Connectivity Updates August 2020 Prakash Masand (Oracle) OIC Various
Enhanced Integration with your Business Partners using OIC AS2 Adapter Michael Meiner (Oracle) OIC B2B
Convert Basic Routing style Integration to Orchestration style. Renukaradhya Dakshinamurthy (Oracle) OIC
User Friendly Names in Mapper Ishruthilaya Malarvizhi OIC
PeopleSoft Integration using Oracle Integration Cloud (Part 1, Part 2) Prakash Masand, & Jin Park (Oracle) OIC Peoplesoft
Jump-start your Integrations with the new Oracle Integration Home Page Michael Meiner (Oracle) OIC
Leveraging Oracle Integration File Server For File Based Integrations Kundan Vyas (Oracle) OIC
Promoting Your Code Antony Reynolds (Oracle) OIC
Adding Your Own Application Templates to Oracle Visual Builder Duncan Mills (Oracle) VBCS
Using OCI API signature authentication from Visual Builder Aparna Gaonkar (Oracle) VBCS
Invoking One Integration From Another – Call integration Action Harshit Yadav OIC
Visual Builder Studio Features (Part 1) Javier Mugueta VBCS/OIC
Integration b/w Oracle Engagement Cloud, Oracle CPQ & Oracle EBS Atul Kumar OIC Oracle Engagement Cloud, Oracle CPQ, EBS

May 20 – New OIC Articles

Plenty of good articles published in the last month …

Article / LinkAuthorSubject MatterConnecting
Automate ERP Purchase Order creation using Oracle IntegrationAnkur JainOICERP
HCM Data Extract Processing PatternNiall Commiskey (Oracle Product Mgmt)OICHCM
OIC for Netsuite –> mapping Custom FieldsNiall Commiskey (Oracle Product Mgmt)OICNetsuite
OIC May 2020 release – New FeaturesNiall Commiskey (Oracle Product Mgmt)OIC 
Integration, Process & Insight – Netsuite Data Sync Use CaseNiall Commiskey (Oracle Product Mgmt)OIC, InsightsNetsuite
Basic Error Handling in OIC & Testing of Basic Error Handling in OICAmit Kumar SumanOIC 
Oracle E-Business Suite Integrated SOA Gateway (ISG) In Oracle Cloud (OIC)Atul KumarOICEBS & SOA
Use REST Adapter With Multiple Resources & Verbs In Oracle Integration Cloud (OIC)Atul KumarOIC 
How To Export Business Data & Visual Builder Cloud Service (VBCS) & How To Import Business Data In Visual Builder Cloud Service (VBCS)Atul KumarVBCS 
Slack Adapter for OICDaniel Martins Teixeira (Oracle)OICSlack
Conditional Mappings in Oracle IntegrationThomas Hora (Oracle)OIC 
https://blogs.oracle.com/integration/4-ways-to-innovate-your-connected-erp-and-hcm-initiatives-with-accenture-and-oracleDaryl Eicher (Oracle)OICHCM, ERP
Triggering an OIC integration via OCI Events – the Oracle Functions ApproachStan TanevOICOCI
How to configure REST adaptor to extract bulk leads from MarketoShalindra SinghOICMarketo
How to Find Human Task by Correlation and How to Abort a Parallel TaskJan KettenisPCS 
OIC May 2020 release – New FeaturesNiall Commiskey (Oracle Product Mgmt)OIC 

Oracle Open World 18

Oracle Open World 2018 is upon us, and here are some suggested sessions:

  • Antipatterns for Integration: Common Pitfalls [PRO6175]
  • Deep Dive: Application Integration on Oracle Cloud [TRN6458]
  • Enhance your CX Applications with Oracle Integration Cloud [HOL6299]
  • Oracle SOA Suite Hybrid Options with Oracle Integration Cloud [TIP4530]
  • Accelerate DigitalOps with Oracle Integration Cloud and UiPath RPA [THT6590]
  • The Future of Integration with Machine Learning and Artificial Intelligence [TIP1372]
  • Extending and Connecting Applications with Oracle Integration Cloud [HOL6298]
  • FedEx Hybrid Cloud Integration Strategy [CAS3614]
  • Integrating Your ERP and HCM with Oracle Integration Cloud [HOL6314]
  • Simplify and Accelerate Digital Transformation with Oracle Integration Cloud [PRO4539]
  • The Path to a Digital Workforce with Oracle Integration Cloud [PRO4515]
  • American Red Cross Modernizes Disaster Relief with Oracle Integration Cloud [CAS4877]
  • Unleash Your Business Processes Your Way with Oracle Integration Cloud [PRO4536]
  • Quick Wins Your Business Will Love Using Oracle Integration Cloud [THT6824]
  • Simplify and Accelerate Digital Transformation with Oracle Integration Cloud [PRO4518]
  • Application Integration on Oracle Cloud [TRN6352]
  • DevOps: Oracle SOA, Oracle WebLogic, Oracle Integration Cloud, Oracle Java Cloud Service [CAS3896]
  • Get Insight into Oracle Integration Cloud/Oracle Java Cloud Service Performance [PRO4478]
  • AI-Powered Oracle Integration Cloud and Oracle API Platform Cloud Service [PRO6176]
  • Connect with Oracle ERP Cloud or Oracle HCM Cloud with Oracle Integration Cloud [PRO4538]
  • Oracle Integration Cloud Customer Panel: Real-World Digital Transformation Uses Cases [CAS5691]
  • Simplifying Oracle HCM Cloud Integrations [PRM3890]
  • Integrating with Oracle ERP Cloud Using Oracle Integration Cloud Service [THT6831]
  • Oracle Integration Cloud Best Practices Panel: Transforming to Hybrid Cloud [CAS5215]
  • Oracle Integration Cloud Customer Panel: Integrating SaaS into Your Application Network [CAS4491]
  • Broader, Better, Faster: Capgemini’s Blueprint for Oracle Cloud in UK Police [CAS3273]
In addition to the core ICS/ OIC / AIC sessions self service integration cloud is well covered this year.

ICS to OIC

We have had a number of interesting conversations of late about the transition from ICS to OIC and to spice the discussion whether it should be OIC or Autonomous OIC. The reality of the situation is that the transition between ICS and OIC is a relatively straight forward one using the export and import tooling.

The real challenge is the impact to organisations appears to be the change in licensing models as OIC works with the newer Universal Credit Model (UCM) where as ICS is in the older arrangement of traditional accounts where you buy the use of specific services, in some ways not too different from traditional Oracle traditional product licensing. For organisations that operate with corporate level buying teams this is organisationally more challenging. As just buying credits can feel like your giving the IT children pocket money and you don’t trust them to ensure the money is spent wisely and they don’t come running back a day later when they say spent all the money can we have some more.

IOC or Autonomous OIC

For the smaller customers where they’re generating less than 5000 Messages per hour (think Integration triggers where each message is <50k – which is fairly big for most needs. Although be aware but moving large files is going to eat through your messages as the transfer cost is file size / 50k = no. messages used (consumed or sent), of effectively 250MB per hour. The autonomous option is a no brainer for smaller use cases in terms of cost as it means on current pricing you have your integrations operating for a lot less than £500 per month (£0.5867 x 24 x 30 – using standard with the flex schemehttps://cloud.oracle.com/en_US/OIC/pricing). With that the SaaS adaptors are also included – that means you could operate say Workday to Oracle Financials for an SME without much problem.

Note: Presently June 2018 Edition of Oracle PaaS and IaaS Universal Credits Service Descriptions - does not clearly define KB and mixes KB and Kb. Having raised this with product management it has been confirmed to mean KiloBytes and NOT Kilobits

As the volumes increase, the differences are going to change, whilst we haven’t done the maths, we’d expect the increasing volumes to eventually favour traditional OIC.

The rules do go beyond simple messages when the Visual Builder (VBCS) and Process (PCS) elements gets involved. The formulas do boil down to users and message counts so the maths are relatively managable. Note the explination for concurrent users is a little more complex than may first appear, and worthy of a blog explination in its own right.

There are other considerations as well for Autonomous OIC vs standard OIC, such as whether you want to have more or less control on the processes such as absorbing updates, handling backups, whether you need to isolate the data from everyone else – and this is a question that is likely to be driven by compliance over anything else for most. Whilst we’ve just highlighted the list prices, when doing the calculations of the cost benefit, you need to factor in the skill sets involved in the different options and the ability to respond to dynamic demand.

Just to link it back to the book, whether its OIC or Autonomous OIC the integration engeine is essentially still the same as ICS. So reading about ICS is still going to help, of course there will be some cosmetic differences, but the fundamentals remain the same.

Page 1 of 4

Powered by WordPress & Theme by Anders Norén