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

Tag: Integration Page 3 of 6

October 2022 – New OIC Articles

With Oracle Cloud World behind us and the customer/partner forum that occurred on the Monday before the main conference. I think we can expect to see more content following soon.

Article / LinkAuthorSubject MatterConnecting
Oracle Integration 3 invoking OCI Process AutomationNiall CommiskeyOIC3OPA
OCI Process Automation -> DecisionsNiall CommiskeyOPA 
Process Automation – Invoking Child Processes and Business KeysNiall CommiskeyOPA 
OCI Process Automation – LocalizationNiall CommiskeyOPA 
Secure Oracle Integration Cloud (OIC) using OCI WAF (Web Application Firewall)Omid IzadkhastiOICWAF
Monitoring Integrations in Oracle Integration Cloud (OIC) Part1, Part2, Part3, Part4Amy Simpson-GrangeOIC 
Autonomous Transaction Processing (ATP) Adapter in OICGiri PrasadOICATP
Structured Process Custom Fault Handling PatternJan KettenisOIC 
OIC Basics – Using the Mapper Code WindowYan ScorrerOIC 
How To Call DB Procedure Asynchronously From OICAyyappa MaturiOICDB
Invoke BIP Report with Parameters in OICPawan LakhotiaOICBIP

September 2022 – New OIC Articles

With Oracle Cloud World just around the corner, the annual Customer Advisory Board event can be attended. So if you’re in Las Vegas for the event – consider registering – it provides a chance to talk with product leadership and hear in detail product development.

Article / LinkAuthorSubject
Matter
Connecting
Create a Retry logic – To overcome putting file to AWS S3 bucket timeout issueSanddyOICAWS S3
How to invoke OCI Function from Oracle Integration CloudSanddyOICOCI functions
Oracle digital assistant Best Practices Part 1, Part 2 (more to come)Daniel TeixeiraODA
Opaque Schema in OICKabir YadavOICfiles
Develop an Integration to get dynamic Email NotificationKabir YadavOICEmail
Schedule Parameters in OICKabir YadavOIC
Oracle Integration Generation 3 – PaaS Partner Community WebcastJurgen KressOIC3
How to confirm if a Fusion Apps Business Event was released to OICAna Lucero AlvaradoOICFusion Apps
https://blogs.oracle.com/fusionmiddlewaresupport/post/process-features-that-are-being-deprecated-in-future-releases-of-oracle-integrationElizabeth EarlePCS
Message Driven Processes with OPA – OAuth SetupNiall CommiskeyOPA
OIC -> Create Customer in Fusion ERPNiall CommiskeyOICFusion ERP
OIC – HCM Register for Training – Create Absence Use caseNiall CommiskeyOICHCM
Complementing Oracle Application Integration with OCI Data Integration Services – Overview and DemoMilomir VojvodicOICODI, Goldengate
Two New Oracle Integration 3 LiveLabs Are AvailableSubhani ItalapuramOIC3
De-mystifying Oauth using JWT user assertion in OICVernon SaldanhaOIC
How to File a Service Request for Oracle Integration 3 EnablementMilad ShirazOIC3
The power of Oracle Integration Cloud’s process automation with RPAAbhijit Ramachandran OIC
Oracle Integration Cloud (OIC): Evolution and Best PracticesAbhijit Ramachandran OIC

August 22 – New OIC Articles

August is a special month for OIC as we see the launch of Generation 3 of the product. The biggest differences are under the hood, with the core engine moving from a WebLogic basis to running on top of Cloud Native OCI services. As a result, the solution will be able to more efficiently leverage other OCI features to deliver enhancements. Not all of the Gen2 features are running on Gen3, we can expect things to follow quickly. When looking at documentation you’ll need to watch out for references to Oracle Integration Generation 2 vs. Integration Generation 3.

Not only do we have Integration Generation 3, but a new independent Process Automation solution was launched in March.

To help differentiate the articles, where we can we’ll continue to refer to the Process automation that resides within OIC as PCS using the legacy name. Anything referring to the new Process Automation service we’ll identify as OPA. Differentiating Integration Generation 2 or 3 will be OIC2 or OIC3, respectively. If there is no generation number, then at this stage, you can assume the answer is quickly true to both generations.

Article / LinkAuthorSubject MatterConnecting
OIC August 2022 Release New FeaturesNiall CommiskeyOIC 
Exposing OIC Process Task Payloads in Visual BuilderNiall CommiskeyPCS 
OIC & API Gateway – effective use of DeploymentsNiall CommiskeyOICAPI GW
OCI Process Automation now availableNiall CommiskeyOPA 
OCI Process Automation in more detailNiall CommiskeyOPA 
OCI Process Automation – ConnectorsNiall CommiskeyOPA 
Oracle Integration 3 – More than simply a New look and FeelNiall CommiskeyOIC3 
OCI Process Automation – Dynamic ProcessesNiall CommiskeyOPA 
OIC CX Event Subscription – Fusion and OIC SetupNiall CommiskeyOICCX
Oracle Integration – OCI MetricsNiall CommiskeyOICOCI Metrics
OCI Dashboards for OICNiall CommiskeyOICOCI Dashboards
Create User for Oracle Integration cloud in Oracle Cloud Infrastructure aka OCIDawaa TarmanggOICIAM
Get object from OCI object storage using OIC & OIC How to use OCI Object storage from the Oracle Integration Cloud SanddyOICOCI Storage
OIC Tracing | How to enable and use OIC TracingSanddyOIC 
OIC To ERP – Design steps for Import and Custom callback & Improved Custom CallBack Part 2SanddyOICEBS
Create a header file based on sequential unique lines Transaction numberSanddyOIC 
Create OIC Decision model from Scratch, Create a Decision model based on expressions, SanddyPCS 
The “MOVENOOP” IO operation for “/test/Emp_1.csv” failed: Oracle Integration File adapterAnkur JainOIC2 
Service Integration Account with No Password Expiration in OICAnkur JainOIC 
BASE64Decoder: Error in encoded stream: Oracle IntegrationAnkur JainOIC 
All About Oracle Integration AgentAnkur JainOIC2 
New OCI Process Automation Gen3 – Some of the UI Enhancements DemoMilomir VojvodicPCS3`
Use Oracle Integration to connect E-Business Suite with SOA to Financials Cloud, Use Oracle Integration to connect E-Business Suite with SOA to Financials CloudPaulo MotaOICEBS, Financials Cloud
Connect OIC with Public Load Balancer having DBaaS in private subnet as Backend setShivang PandyaOICOCI LB & DB
Promote Integrations across OIC instances using Visual Builder StudioVernon SaldanhaOIC 
Simplifying Oracle Unity Integration using OIC Unity AdapterMadhav PoosarlaOICUnity
Aug’22 Oracle Integration-Third Party Adapters EnhancementsMadhav PoosarlaOICVarious
Introducing Oracle Cloud Infrastructure Process AutomationArvind VenugopalOPA 
40+ Oracle Integration Cloud OIC Interview Questions August 2022Mahir Fayaz OIC 

July 22 – New OIC Articles

July’s big news is the connectivity between OCI and Azure for Oracle to streamline Azure users accessing Oracle databases (here), and more importantly, for OIC users is the addition of new Sovereign nation regions (here). For OIC users this means the possibility of handling data that is more sensitive to where the data resides.

Article / LinkAuthorSubject MatterConnecting
Extending Opera Cloud with OICNiall CommiskeyOIC & VBOracle Hospitality (OPERA)
End to End Business Process AutomationNiall CommiskeyOICAI Vision
Jira Adapter – Add Attachments etcNiall CommiskeyOICJIRA
Update Oracle Integration Cloud connection from primary to standby database dynamicallyOmid IzadkhastiOICDB
Git source code management for Oracle Integration Artifacts using VB StudioAshritha MalliOIC. VBS 
Making use of variables, properties and schedule parameters anYan ScorrerOIC 
Invoke OIC Integration from Process application (plus other short posts on OIC)SanddyOICPCS
Create process application with web form (plus other short posts on PCS)SanddyPCS 
OCI API GW & JWT to call OIC with/without Credentials (Part I & Part II)Ankur JainOIC 
Automation and AI – Oracle Process Automation with OCI AI ServicesMilomir VojvodicOICAI

May 22 – New OIC Articles

May means we see another quarterly release with new features as we can see by the types of blog posts collected this month

Article / LinkAuthorSubject MatterConnecting
OIC and OCI Logging ServiceNiall CommiskeyOICOCI Logging
End to End Business Process Automation with OIC Part INiall CommiskeyOIC (Integration & Process)OCI Events, Object Store, Notification Service
May 2022 Oracle Integration UpdateNiall CommiskeyOICVarious
Native Payload Support in Activity Stream with May’22 ReleasePrakash MasandOIC 
OIC May 22 release New Features – QuickBooks AdapterNiall CommiskeyOICQuickbooks
How to Update Java on Oracle Integration Cloud On-premise AgentHritik Tyagi OIC 
Suppliers to Oracle VB synch using Oracle IntegrationAnkur JainOICERP
Convert string date from one format to another in Oracle IntegrationAnkur JainOIC 
Use of Root Certificates in OIC, a Best PracticeMilad ShirazOIC 
Read files from Object Storage in Oracle IntegrationAnkur JainOIC 
Push records in batches to target service in Oracle IntegrationAnkur JainOIC 
May’22 Oracle Integration-Third Party Adapters EnhancementsMadhav PoosarlaOICJIRA, Magento, SAP, Zendesk
Migrate Oracle Integrations with Security artifactsAnkur JainOIC 
How to extract data from Oracle Fusion using REST APIs in OICAnkur JainOICERP
OIC – Export an Integration Using REST API SanddyOIC 
OIC – limitation of using Staging areaSanddyOIC 
https://soalicious.blogspot.com/2022/05/oic-schedule-bi-publisher-report.htmlSanddyOIC 

March 22 – New OIC Articles

Article / LinkAuthorSubject MatterConnecting
Get Report Parameters OIC 
How to Process ERP Cloud Business Events in Oracle IntegrationKishore KattaOICOICERP
Using OIC for Data Migration?Yan ScorrerOIC 
Oracle Integration, OCI API Gateway and OCI Logging & AnalyticsCristian SilipigniOIC 
OIC New Features March 2022 – Magento AdapterNiall CommiskeyOICMagento
OCI CIS Landing Zone: Advanced Configuration using Terraform OverridesOlaf HeimburgerOIC 
ERP Integration Callback Implementation in Oracle Integration CloudJack DesaiOICERP
Create IDCS user with OIC creation privilegesGabriele Cannas OICIDCS
Oracle Integration Update Webcast: CX Integration and Extension Best practicesJürgen Kress OICCX
Blending PaaS Data with SaaS Reporting Using OIC to Break Data SilosBhavesh ShahOICDB
Dynamically show changed fields in a Process Web FormArvind VenugopalPCS 
Import Suppliers using FBDI in Oracle IntegrationAnkur JainOICERP
Merging two CSV files into a single file in Oracle IntegrationAnkur JainOIC 
Enable Oracle Integration Activity Stream to OCI Logging serviceAnkur JainOICObservability

February 22 – New OIC Articles

Another month passed already, so here are Feb’s posts.

Article / LinkAuthorSubject MatterConnecting
Automating Accounting Hub Cloud Integration with Oracle IntegrationKishore KattaOICAccounting Hub
OIC – API Gateway – Logging –> the value add of OCINiall CommiskeyOICAPI Gateway, OCI Logging
OIC + OHIP + Simphony (part 1, part 2, part 3)Niall CommiskeyOICOracle Hospitality, Simphony, OHIP
OIC ecosystem – Integration & OCI Services – an OverviewNiall CommiskeyOICOCI
February 2022 Oracle Integration UpdateAntony ReynoldsOICMagento Commerce Cloud, Oracle Unity, Oracle Hospitality
New Third Party Application AdapterMadhav PoosarlaOICMagento Commerce Cloud
Oracle Integration Business Accelerator for Siebel Loyalty and CrowdTwistPrakash Masand & Venkat BhatOICSiebel
How to call the OCI AI Language Service from the Oracle Integration CloudDaniel Martins TeixeiraOICOracle AI Language Service
Oracle Hospitality Integration Platform (OHIP) Developer Portal gets a faceliftAmy Simpson-GrangeOHIP 
Integration to upload file to the UCM Server in HCM CloudKabir YadavOICHCM UCM
Steps to fetch Oracle Cloud SaaS Application CertificatesKabir YadavOIC 
How-to Do Error Handling When Integrating With Fusion ERPJan KettenisOICFusion ERP
Parallel Gateway and Multi-Threading, the Work-AroundJan KettenisOIC 
Token Based Authentication (TBA) Policy configuration for Oracle Integration Cloud NetSuite AdapterManish Kumar GuptaOICNetSuite
Publish messages in Stream using Oracle Integration & Connect Stream using OCI Streaming adapter in Oracle IntegrationAnkur JainOICStreams

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 

Quarterly Updates

The update regime for Integration Cloud is well established in its quarterly pattern, but within that pattern are two update cycles, separated by two weeks. It is possible to choose which cycle your OIC instance update will be executed in. If you don’t specify which cycle then by default you will be put into the second cycle.

For production deployments of OIC that makes a lot of sense. But we would recommend that your non-production instance be part of the 1st update cycle. This allows you two weeks to validate and fix any issues in the event that the upgrade breaks any of your integrations. While that shouldn’t happen if you are exploiting an undocumented behaviour or something reported as a bug there is always a risk.

So the obvious question is how to define which update cycle should be used. For OCI Gen 2 (the majority of users should have migrated to now), the control is achieved by setting a freeform tag on the OIC instance. The tag needs to be called OIC_UPDATE_WINDOW1 (note – if you don’t read the Oracle documentation carefully you could end up omitting the numeral) and the value can be left blank. The tags are set on the OCI view for your OIC instance, which has a tabbed view as you can see below. Once the value is set then the OCI view will show an Updating status – this is not to be confused with the OIC instance being updated with the latest quarterly changes.

All of this shows up in blog (here and script fragment here) and a documentation (here). What is less apparent is the lead time needed for the tag to be in place. This is in the order of 7 or more weeks. This means you need to have your OIC dev instance in place almost a full quarter before the opportunity is available, and spinning up a new OIC instance and expecting it to immediately adopt the latest version during the maintenance window isn’t going to solve any problems.

How to confirm the instance version

The related question is where to look for the version of OIC is running. The information is only provided in the instance console rather then the OCI View of OIC. The version information is available as part of the drop down visible on the question mark icon at the top right of the UI, as the following screenshots show:

We do hope that Oracle will shorten this in the months to come.

Terraforming …

If you’re building your OIC deployment(s) using Terraform, then you could pass a variable into your Terraform module (hence the reference to var. or read from a configuration file in which case you will want a data block and the value becomes data.)

locals {
 updateWindow = (var.use_window1) ? "OIC_UPDATE_WINDOW1" : "--NOT-WINDOW1--"
}

resource "oci_integration_integration_instance" "test_integration_instance" {
    #Required
    compartment_id = var.compartment_id
    display_name = "ExampleOIC"
    integration_instance_type = var.integration_instance_integration_instance_type
    is_byol = false
    message_packs = 1

    consumption_model = var.integration_instance_consumption_model
    custom_endpoint {
        #Required
        hostname = var.integration_instance_custom_endpoint_hostname

        #Optional
        certificate_secret_id = oci_vault_secret.test_secret.id
    }

    freeform_tags = {"${local.updateWindow}"= ""}
    idcs_at = var.integration_instance_idcs_at
    is_file_server_enabled = var.integration_instance_is_file_server_enabled
    is_visual_builder_enabled = var.integration_instance_is_visual_builder_enabled
    network_endpoint_details {
        #Required
        network_endpoint_type = var.integration_instance_network_endpoint_details_network_endpoint_type


        }
        is_integration_vcn_allowlisted = var.integration_instance_network_endpoint_details_is_integration_vcn_allowlisted
    }
    state = var.integration_instance_target_state
}

As you can see in my example I have hardwired more values than the example provided by the Oracle Terraform documentation (here) as it helps show the legal values. Here to keep the declarations simple – I have set a freeform tag regardless, but changed in the local variable value to be used by the freeform tag depending on if a variable ( use_window1) is set.

November 21 – New OIC Articles

Another month and another raft of great content. Lot of activity springing up around the new Oracle Hospitality Integration Platform (OHIP) with its new OIC Adapter.

Article / LinkAuthorSubject MatterConnecting
Clone an Existing Integration Flow in OIC Basics of OICOIC 
OIC: Synchronous versus Fire-and-Forget Process to Process InvocationJan KettenisOIC 
Oracle Integration Cloud – Gmail AdapterDaniel TeixeiraOICGMail
Between Oracle Integration Cloud (OIC) And Oracle Cloud Infrastructure (OCI)Atul KumarOIC 
How to call the OCI AI Language Service from the Oracle Integration CloudDaniel TeixeiraOICOCI AI Language Service
Creating Custom Messages/Notifications in Visual BuilderShay ShmeltzerVBS 
FlexDeploy for Oracle Integration CloudJürgen KressOIC 
Connecting Opera Cloud to the World – PaaS Partner Community Webcast November 30th 2021Jürgen KressOICOPERA (Oracle Hospitality)
OIC November Release New Features – Oracle Hospitality AdapterNiall CommiskeyOICOPERA (Oracle Hospitality)
OIC November 21 Release New FeaturesNiall CommiskeyOIC 
DB adapter – overcoming 10 MB limitNiall CommiskeyOICDB
Leveraging OCI AI Language Service from Oracle Integration (Part 1) (Part 2)Niall CommiskeyOICAI Language Service
Fetch & update Integration lookup using Visual BuilderAnkur JainVBS & OIC 
OHIP and Oracle Integration Cloud: Simplifying hospitality integrations even moreLuis WeirOICOHIP (Hospitality Integration)
November 2021 New Third Party Application AdaptersMadhav PoosarlaOICSugar CRM, eBay
Delivering Real Customer Value with Agile Innovation: Heathrow rapidly moves to Oracle Cloud and connects with hybrid Integration – Webcast November 16th 2021Jürgen KressOIC 
November 2021 Oracle Integration UpdateAntony ReynoldsOIC 
Answers are never far away with Oracle AssistantKevin HopkeOIC 
Exporting Data from Oracle HCM Cloud using OICHemanth LavesattiOIC 
CI/CD for Oracle Visual Builder ApplicationsVijayaraj GovindharajVBSFlexDeploy
Decouple complex flows into simplified multiple resource REST flowMadhav PoosarlaOIC 

Page 3 of 6

Powered by WordPress & Theme by Anders Norén