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

Author: Phil Wilkins Page 2 of 7

TOGAF 9 Certified Enterprise Integration Architect & Oracle Ace Associate
UKOUG Middleware Special Interest Committee Member
- https://uk.linkedin.com/in/philwilkins
- https://blog.mp3monster.org
- https://www.packtpub.com/books/info/authors/phil-wilkins

October 21 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
Field Level Encryption with Oracle Integration and OCI VaultStan TanevOIC, Vault 
Process Excel files with OIC + Oracle FunctionsStan TanevOICExcel
Setup Email Notifications with the Oracle Integration CloudDaniel TeixeiraOICOCI Email
Oracle Integration Cloud – Twilio Adapter for SMS and WhatsAppDaniel TeixeiraOICTwilio
Visual Builder – A Crash Course by Shay ShmelzerShay ShmelzerVBCS 
Configuring OIC NotificationsNiall CommiskeyOICOCI Notifications
Leveraging Grafana for OIC MetricsNiall CommiskeyOIC 
Using OIC Logging Analytics for searching OIC Activity Stream logNiall CommiskeyOICOCI Log Analytics
Surfacing OIC Design Time audit logs in OCI Logging AnalyticsNiall CommiskeyOICOCI Log Analytics
Using OCI Logging for searching OIC Activity Stream LogNiall CommiskeyOICOCI Log Analytics
OIC docs link for restricting access to OIC instancesNiall CommiskeyOIC 
Create a fixed-length file in Oracle IntegrationAnkur JainOIC 

September 21 – New OIC Articles

Latest updates, lots about use of Streaming with OIC ….

August 21 – New OIC articles

Article / LinkAuthorSubject MatterConnecting
Oracle Assistant for OICNiall CommiskeyDigital Assistant to help with using OICN/A
OIC & Blue Prism Part 3 – Invoking an OIC Integration from Blue PrismNiall CommiskeyOICRPA (Blue Prism)
Tracing and Monitoring Business Objects in Visual BuilderShay ShmeltzerVBCS 
New Features in Visual Builder – August 2021Shay ShmeltzerVBCS 
OIC Activity Stream to OCI Log analyticsShreenidhi RaghuramOICLog Analytics
Extending Oracle Fusion SaaS with OCI – IntegrationAngelo SantagataOICHCM, CX, ERP
Extending Oracle Fusion SaaS with OCI – User InterfaceAngelo SantagataOICHCM, CX, ERP
Extending Oracle Fusion SaaS – Best PracticesAngelo SantagataOICHCM, CX, ERP
Advisor Webcast: OIC JDeveloper PluginTanya HeiseOIC 
Migrate Your Oracle Integration Cloud Classic Services to Oracle Cloud Infrastructure (OCI)Elizabeth EarleOIC 
CI/CD for Oracle Integrations with Visual Builder StudioShay ShmeltzerOICOVBS
OIC Integration Lifecycle Using REST EndpointsAmy Simpson GrangeOIC 
Create Free Trial OIC Instance for one MonthKabir YadavOIC 
Tips and Tricks for handling numbers in BPEL or OICPranav DavarOIC 
Convert JSON to String in Oracle IntegrationAnkur JainOIC 
https://oracle-integration.cloud/2021/08/26/oic-scheduling-for-end-of-month-style-processes-tip-11/Phil WilkinsOIC 

OIC Scheduling for End of Month style processes – Tip #11

Setting up calendar schedules that aren’t simply reoccurring, such as a specific date in a month like 28th or third Friday, become more of a challenge with the OIC Scheduler. The calendar works with the ical standard set by the IETF standard 2445. If you review the standard’s section 4.3.0, this describes the reoccurrence options, whilst able, not able to address these needs.

Reoccurring on specific dates can, in theory, be set. If you review section 4.3.4, you will see a date has the potential to be defined as a comma-separated list. So multiple dates for month-end can be provided as a list. Note, this is predicated on the calendar attribute supporting date-mday (DATE). The DTSTART and DTEND attributes accept DATE with no indication that the date-mday is not supported.

Specifying the dates explicitly overcomes the problems of national holidays. The downside is that you need to know when the list needs to be extended and, in the case of OIC, the means to edit the scheduler format safely.

NOTE: we have not tested whether the OIC scheduler is compliant with the use of date-mday at the time of writing.

Versions 1 and 2 running concurrently

Complex formulas for scheduling and more manageable scheduling..

There are several options for managing reoccurring events, such as month-end, year-end accounting, payroll and expenses payments etc.

In most options, we assume that we have a simple reoccurring schedule that triggers an integration that determines whether the trigger is legitimate. This could be as simple as daily. If valid, then invoking the main integration with the business process.

Defining Dates in the database, we can wrap it with JET, Visual Builder or APEX to create a presentation layer. The task of managing the schedule to be taken on by the business.

This approach makes it very easy to adjust and test. Whether there are any more future schedule dates can also be overcome by having an integration that queries the table for the next date being set. If not date set, then the generate relevant alerts using OCI native tools.

The schedule is triggered regularly, e.g. daily, and the scheduler trigger invokes an integration then looks up the DB to see if the date appears in the list. When the date appears, then the integration is executed. It would be straightforward to extend this to trigger different schedules.

Automated option

If an algorithm can be described for when the month-end processes should be performed, we eliminate the need to manage a list of dates. There are some ways to implement a formula, and you have the option of trying to do it OIC, but using OCI Functions – the formula is coded in the language of your choice and then packaged and deployed. The Function is then invoked using a REST web service to confirm whether the process should run (more on how here).

Handling public and national holidays. Not all national holidays are locked into an algorithm, or the holiday is fairly complex. That said, there are several API sources available that can tell you these dates, for example, https://holidayapi.com; this makes things easier.

The beauty of this process is that the same Function could keep a company website up to date with the next run date. Be integrated into corporate notifications and so on. As a result, one point of truth.

Enhanced Automation (feature wish …)

Unfortunately, OIC doesn’t provide an API to add new schedules. We can’t simplify the integration logic until it does, which adds the next calculated date for the process to run as a one-off schedule.

iCal Resources (inc Tools)

July 21 – New OIC articles

Article / LinkAuthorSubject MatterConnecting
Oracle Integration Cloud (OIC) & octet-stream MIME-typeAmy Simpson-GrangeOIC 
delete a schedule from an IntegrationKabir YadavOIC 
How Granular Should My Microprocesses Be?Jan KettenisPCS 
How to perform FBDI GL File UploadDeb MukherjeeOIC 
Load FBDI and callbackDeb MukherjeeOIC 
Basic File Encryption and Decryption in OICDeb MukherjeeOIC 
Oracle Digital Assistant – Backend Integration with the Oracle Integration CloudDaniel TeixeiraOICODA
Oracle Integration Message Packs and PricingAnkur JainOIC 
Business Identifiers in Oracle IntegrationAnkur JainOIC 
FlexDeploy Support for Oracle CloudJurgen KressOICCI/CD
OIC & Blue Prism Part 1, Part 2Niall CommiskeyOICBlue Prism (RPA)
August 2021 Oracle Integration UpdateAntony ReynoldsOIC 
OIC Monitoring and Logging Analytics – adding Business Data to DashboardsNiall CommiskeyOICLog Analytics
OIC and Logging Analytics – steps towards fleet management and more stepsNiall CommiskeyOICLog Analytics
Logging Analytics for OICNiall CommiskeyOICLog Analytics
Event Driven Integration with Oracle Commerce CloudNiall CommiskeyOICCommerce Cloud
Turning SFTP Cloud NativeJohan LouwersOIC 
Authenticating Oracle Integration flows using OAuth token from 3rd party providerPrakash MasandOICOAuth
August 2021 New Third Party Application AdaptersPrakash MasandOICSAP, Zendesk

June 21 – New OIC articles

It appears to have been an unusually quiet month, but that could be a reflection of the OIC release cycle as we’ll probably hear about the next feature set updates late in July.

Article / LinkAuthorSubject MatterConnecting
OIC Recipe – SFDC Opportunity to Fusion ERP OrderNiall CommiskeyOICSFDC, ERP
Some Ideas for OIC Fleet ManagementNiall CommiskeyOIC 
OIC – SFDC -Bulk apiNiall CommiskeyOICSFDC
Improving the performance of Oracle Integration flows that use REST callsNick MontoyaOIC 
Connecting securely from Oracle Integration to Autonomous database using network access listShreenidhi RaghuramOICADB
Connect Oracle SaaS (ERP, HCM, CX) with Pre-Built Recipes – Accenture Oracle WebcastJürgen KressOICERP, HCM, CX 
Insight Mapping ImprovementsSanthosh KumarInsights 
Real time Synchronization of Suppliers leveraging Event Driven ArchitectureKishore KattaOICKafka
Oracle HCM Cloud – Payroll Sync with the Oracle Integration CloudDaniel TeixeiraOICHCM
Using REST APIs to manage Connections in OICPranav DavarOIC 
Enable Business Events for Payables Business Events/Payments in Oracle Fusion Finance CloudDeb MukherjeeOICERP
OIC – API Gateway – Logging –> the value add of OCINiall CommiskeyOICOCI (API, Logging etc)
Configuring Notifications in Oracle Integration Gen2Lavanya SiliveriOICOCI Email
Use Oracle Integration to Add Attachments to a Process InstanceBogdan EremiaOIC 
File Adapter Vs FTP Adapter in Oracle Integration CloudAnupam BartwalOIC
Oracle Integration Cloud (OIC) AdaptersKrishan KumarOIC

May 21 – New OIC articles

Article / LinkAuthorSubject MatterConnecting
Integrate ICS with a third party OAuth Protected REST service using the generic REST adapter (Part 2) (Part 1)Anuj KaushalOIC 
Oracle Integration Latest FeaturesAntony ReynoldsOIC 
Integration Insight for Process automationSandhya Lakshmi GopalanPCS, Insights 
DevOps and Release Automation for Oracle Integration Cloud – Webcast May 13th 2021Juergen KressOICFlexDeploy
Help! I can’t find my OIC instances anymoreSimone GeibOIC 
May 2021 Oracle Integration Enterprise Messaging Adapters ImprovementsPrakash MasandOICMessaging
May 2021 Oracle Integration Fusion Application Adapters ImprovementsPrakash MasandOICApps
May 2021 Oracle Integration Database Adapter ImprovementsPrakash MasandOICDB
Oracle Integration Cloud – Kafka Adapter with Apache AVRODaniel TeixeiraOICKafka
Process Automation with Process Cloud Service (PCS) – Part 5 – (Publish & Activate) (Part 1, Part2, Part3, Part4)Daniel TeixeiraPCS 
Integration Insight – Business Analytics for the Oracle Integration CloudDaniel TeixeiraOIC, Insights 
Private connectivity to Oracle Integration Cloud next generationOmid IzadkhastiOIC 
Package in OIC |Add package for IntegrationKabir YadavOIC 
Package Migration or Multiple Integration Migration |OIC Integration MigrationKabir YadavOIC 
Run OIC scheduled integration using RESTAnkur JainOIC 
OIC Connectivity Agent PatternsNiall CommiskeyOIC 
SOA Suite to OIC – how easy is it? Part 1 Part 2 Part 3Niall CommiskeyOICSOA Suite
New Recipes – FTP to Netsuite File CabinetNiall CommiskeyOICNetSuite
ATP Bulk Data ImportNiall CommiskeyOICATP
Integration Insight AlertsNiall CommiskeyInsights 
Integration Insight -> embed Dashboards in Visual BuilderNiall CommiskeyInsights 
Process & Integration InsightNiall CommiskeyInsights, PCS 
B2B support for UN EDIFACT Part 1, Part 2Niall CommiskeyOIC 

Reflecting on community

If you’ve attended an Oracle conference or just aware of the wider Oracle ecosystem, then you’ll know of the Oracle APEX community and probably one of the communities’ highly respected and much-loved contributors, Joel Kallman. Sadly, Joel has passed on, another victim of Covid19. Our thoughts go out to Joel’s family and the community who have lost someone they value so much.

https://apex.oracle.com/pls/apex/apex_pm/r/joel/memories

April 21 – New OIC articles

Blink and it’s another month gone. But Oracle has been very very busy as we come around for the latest quarterly updates and the details published. Plus a lot about Oracle Hospitality Integration Hub (OHIP) which builds upon OIC.

Article / LinkAuthorSubject MatterConnection
May 2021 Oracle Integration UpdateAntony ReynoldsOIC 
May 2021 Third-Party application adapters updateMichael MeinerAdapters 
May 2021 Oracle Integration Fusion Application Adapters ImprovementsPrakash MasandSaaS Adaptors 
May 2021 Oracle Integration Database Adapter ImprovementsPakash MasandDB Adaptors 
May 2021 Enhanced Security in AdaptersMichael MeinerAdapters 
May 2021 Technology Improvements in AdaptersMichael MeinerAdapters 
Connect Oracle SaaS (ERP, HCM, CX) with Pre-Built Recipes – Accenture Oracle Webcast May 5th 2021Amit Tahilramani, Mani Choudhary and Amit Singh with Dhiraj ChhajerOracle SaaS Recipes 
Invoking Process Applications with Anonymous Users from VB Apps with Oracle IntegrationArvind Venugopal, Shay Shmeltzer, and Nathan AngstadtVisual Builder 
Extend Process Automation UI Components to JET-Based ApplicationsArvind Venugopal, Rameshkumar Arumugam, and Sacheth SavandurgaProcess 
Using an Event Based Pattern with Oracle IntegrationMichael MeinerOIC PatternShopify
Practical Guide to use HCM Data Loader with Oracle IntegrationPrakash Masand, and Harris QureshiOICHCM
Using UN/EDIFACT for B2B TransactionsArvind Venugopal, and Sunil ApteOIC 
Modelling Transport Integrations with Trading Partner ManagementArvind Venugopal, and Sunil ApteOICOICTrading Partner
May 2021 Oracle Integration Pre-built RecipesMichael MeinerOICNetSuite, ServiceNow, Facebook, Slack, docusign
Connecting securely from Oracle Integration to Autonomous database using network access listShreenidhi RaghuramOICAutonomous DB
OIC – Oracle Hospitality syncing Company/Guest with SFDC Account/ContactNiall CommiskeyOICOracle Hospitality
OIC May 21 Release – New Jira adapterNiall CommiskeyOICJIRA
OIC for File Transfer – Rename – Move to Target – Delete SourceNiall CommiskeyOICFTP
OIC –> Oracle Hospitality – refreshing OAuth TokenNiall CommiskeyOICOracle Hospitality
Box to HCM Cloud –> HDL File LoadNiall CommiskeyOICBox
Integrating Oracle Hospitality Cloud and 3rd party CRM (SFDC) via OIC and OHIPNiall CommiskeyOICOracle Hospitality
OIC and Oracle Hospitality (OHIP) – Getting the most out of Opera APIsNiall CommiskeyOICOracle Hospitality
Five key Oracle Integration lessons from handling billions of messages monthlyAmit Saxena & Daryl EicherOIC 
Working Around not Having Complex GatewayJan KettenisOIC 

March 21 – New OIC articles

Time flies, with a 1/4 of a year behind us already including the first quarterly release. Last month we’ve seen a lot of attention around Oracle Hospitality Integration Platform (OHIP) which brings together different Hospitality cloud services as well as using technologies such as Integration Cloud to make it easy to interface 3rd party solutions.

Article / LinkAuthorSubject MatterConnecting
OIC and Oracle Hospitality (OHIP) – Getting the most out of Opera APIsNiall CommiskeyOICOracle Hospitality
OIC –> Netsuite & HubSpot – User Events calling OIC to sync Price changesNiall CommiskeyOICNetSuite, HubSpot
OIC –> HubSpot to Netsuite – Product SyncNiall CommiskeyOICNetSuite, HubSpot
Accessing Object Storage from Oracle Integration   
    
How to define a Repeating Global VariableJorge HerreriaOIC 
Connecting HubSpot with Netsuite Part 1 & Part 2Niall CommiskeyOICNetSuite, HubSpot
Connecting to NetSuite using Token Based AuthenticationSubhani Sahib ItalapuramOICNetSuite
OIC & OCI NotificationsNiall CommiskeyOICNetSuite, HubSpot
Using Aggregate Functions Sum(), Count() while Processing Larger FilesPhaneendra BommisettyOIC 
OIC Scheduling REST APIsSumeet SinghOIC 
Defining OIC SchedulesSumeet SinghOIC 
Introduction to Trading Partner ManagementArvind Venugopal and Sunil ApteOIC 
B2B Tracking for Wire and Business Transactions in Oracle IntegrationArvind Venugopal and Sunil ApteOIC 
DocuSign Adaptor in Oracle Integration Cloud – Configuring & Automating WorkflowBhumika GogiaProcessDocusign
DocuSign Adaptor in Oracle Integration Cloud – Setup & IntegrationBhumika GogiaOICDocusign
Throw New Fault Action TestingKabir Yadav (alias Amit Suman)OIC 
Create Calculator SOAP connectionKabir Yadav (alias Amit Suman)OIC 
Somewhat “Hidden” Feature: Reusable SubprocessJan KettenisOIC 
OIC Process Correlation: Take Good Care of Your PropertiesJan KettenisOIC 

Page 2 of 7

Powered by WordPress & Theme by Anders Norén