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

Tag: OCI Page 1 of 2

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

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

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)

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

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

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

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 

Oracle Hospitality OIC Adaptor

Oracle Integration Cloud is rich in adaptors for technology and major SaaS services both Oracle (E.g., HCM, ERP, CX) and non Oracle (e.g., Salesforce, ServiceNow). But the more observant may have noticed a new addition to the list of Oracle industry (vertical) adaptors joining the Utilities vertical is a new adaptor for Hospitality.

OPERA, and it’s integration service OHIP have been developing to bring first of all its 3000+ APIs upto date as RESTFUL and self service enabled as the OPERA product becomes a SaaS delivered solution. Not to mention provide a good developer experience with Apiary and resources such as Postman collections (more about this here).

The latest step (from 21.4.2) has been to further the simplify the development process through the use of low code integration OIC provides. You can read some initial blogs about it here, and I’m sure there will be more to come.

Today the Adaptor just supports the Property Management System (PMS) that is for us uninitiated the system element handling the hotels core operations such as rooms, housekeeping and associated tasks – the heart of a hotel based business. Areas such as marketing, cruise ships, point of sale (PoS) etc fall out side of PMS and are not covered today.

Why OHIP and OIC

OHIP and OIC really comes into its own because it is very easy to wire the hotel management solution to common services such as ERP and HCM functions.

For example if you’re operating a group of hotels, then each hotel will use an OPERA instance, but the group may well make use of ERP Cloud for the overall accounting, taking the costs etc identified in the hotel operations via OPERA and then those figures are put into the group ERP to provide the overall financial controls and picture.

Adaptor Foundations

The OIC Adaptor builds on top of the OHIP APIs, as a result the same restrictions on invocations, security needs exist as going to the native API. Like all OIC integration development we need to establish a connection definition which needs the URL of you OHIP instance, plus the same credentials you would use for a rest connection.

Connection Palette in OIC with oracle Hospitality highlighted

Page 1 of 2

Powered by WordPress & Theme by Anders Norén