Posts

Showing posts from 2020

Extending OOTB OIC Recipe - Extract New Hire Info (Continuation of Part 1)

Image
Background In the previous blog we have seen how to Install and Run a Recipe - Extract New Hire Info  from Oracle HCM Cloud. Extract definition is created and executed in HCM Cloud as a pre-requisite for the OOTB Recipe to work. In this blog we will create an Integration Flow in OIC to extend and automate the whole process of executing the Extract instead of having it done manually from HCM Cloud. Also, there has been incredible uptake of cloud storage buckets which provides a simple, low cost mechanism to store both structured and unstructured data. Data Archiving is one of the key use cases for extracts. We will store the extracts in an OCI Storage bucket as part of the Integration Flow. Usecase Flow Pre-requisites Oracle HCM Cloud Extract A Valid Oracle HCM Cloud Extract Definition Configure Webcenter Delivery Option and an Integration Name Note: Do not Submit the extract. We will invoke the same from OIC OCI Object Storage Bucket Login into OCI Console and Navigate to Object St...

Install and Run Oracle Integration Recipe - Extract New Hire Info from HCM Cloud

Image
Background Accelerators  and  recipes  are a great way to kick-start on building your integrations. Accelerators are run-ready business integrations or technical patterns you can configure and activate. Recipes are starter templates that give you a head start. Some of the recipes exist today as separate downloads via Oracle Marketplace and other repositories. Oracle-built recipes are harvested and they are made available as part of Oracle Integration instances. OIC new Home Page brings these right to your doorstep! For instance if we need to automate HCM Cloud extract and push it to an SFTP server there is a Recipe for that. As part of this blog series we will see how to customize the OOTB Recipe and modify the Integration Flow Here is the list of OIC Recipes integrating with HCM Cloud  Recipe Usecase There are many usecases where automation of HCM Cloud extracts plays a crucial role. Here are some examples from our Customer Scenarios in their Ent...

Automating End to End Bulk Export from Oracle ERP Cloud using Oracle Integration (Part 2- ERP Cloud Event based Callback)

Image
Background In Part 1 of the blog series we have seen how to Initiate Oracle ERP Cloud Data Extract process from OIC. We have also seen  how a callback url can be used to trigger the Callback Integration Flow after the BIP extract job is complete. In this blog we will witness the out of box event based mechanism to trigger the Callback Integration flow instead of a concrete callback endpoint. The best practice is to leverage event based mechanism as there is built in retry mechanism in ERP Cloud if the event is not delivered to OIC. Designing the Integration Flow Prerequisite Configuration Refer: Configure Section of ERP Cloud Modify the ERP Bulk Extract Integration flow (Flow 1- Refer Part1) Update the Map fields for erpBulkExport Operation to the following literal values jobOptions: "EnableEvent=Y" callbackURL: Do not provide anything. Delete the mapping if it exists Activate the Integration Flow Creating Event based Integration Flow (Flow 2) 1. Create an App Driven Integra...