OIC provides a large set of connectors/adapters to connect to Oracle’s SaaS and on-prem applications and many third-party cloud and on-prem applications.
Oracle ERP Cloud Adapter is used to connect to Oracle Cloud ERP. Oracle Cloud ERP offers the most complete and integrated Enterprise Resource Management solutions for operations, GRC and performance management.
In this post, I am going to give you an overview of what is ERP, ERP Cloud Adapter and how to use OIC to integrate with ERP with High-Level Steps for importing the data into ERP Cloud using OIC.
If you are new to Oracle Integration Cloud (OIC), then check out our blogs on Oracle Integration Cloud (OIC) For Beginners Overview.
What is ERP Cloud?
“ERP” stands for enterprise resource planning. It refers to a suite of software that organizations use to manage day-to-day business activities, such as accounting, procurement, project management, risk management and compliance, and supply chain operations. A complete ERP suite also includes enterprise performance management, software that helps to plan, budget, predict, and report on an organization’s financial results.
ERP systems tie together and define a plethora of business processes and enable the flow of data between them. By collecting an organization’s shared transactional data from multiple sources, ERP systems eliminate data duplication and provide data integrity with a “single source of truth.”
Features of Orale Integration Cloud (OIC)
- Oracle Integration Cloud (OIC) can be leveraged to import data from external feeds (published in SFTP) to Oracle ERP Cloud.
- OIC simplifies how you build integrations in the cloud, letting you connect securely to applications and services both in the cloud and on-premises.
- OIC exposes a browser-based user interface through which the integration is first designed, then activated and managed.
- It also provides connectors/adapters to easily interact with a number of popular SaaS applications. One such connector that OIC provides is the Oracle ERP Cloud Adapter which is used to connect to Oracle Cloud ERP.
The diagram below describes the entire flow involving the various steps while importing
the data into ERP Cloud using OIC
The entire solution is divided into 3 steps. Each of these steps has an OIC flow associated. The solution design is shown below:
High-Level Steps for importing the data into ERP Cloud using OIC.
Step 1: Generate FBDI File
The first step is to generate a File-Based Data Import (FBDI) file for ERP’s consumption. Most of the bulk integration with ERP is through FBDI File.
The source application’s data file may not be in the FBDI format always. In this case the source application data format needs to be converted to FBDI format. This can be achieved by applying cross-references master data values from Oracle ERP cloud in a custom layer by either making the changes in the source system to burst out the data in FBDI template or by using procedures in a database layer and applying the transformation to get FBDI formatted files.
7 Steps to generate the FBDI format.
- Read Trigger File: This is scheduled OIC integration that gets triggered based on a scheduled configured. The first step is to read the trigger file that will be put in FTP location.
- Download Source Data File: downloading the source data file into OIC because chunking of the file on FTP Server is an expensive operation.
- Chunk Read and Transform to FBDI: Stage Read feature in OIC to chunk read file. Then every chunk is transformed from source format to FBDI format and then output FBDI file is written.
- List File: List file is needed for OIC to determine how many FBDI files are written out.
- Generate Property File and Write zip file: OIC uses ERP Adapter to upload FBDI file to ERP. Although the ERP Adapter makes uses of ERP provided web services internally, it obfuscates many complexities involved in the raw ERP web services.
- Archive Source File: The source file is archived for the future on an FTP location for re-submission purposes if necessary in the future.
- Archive Trigger File: The trigger file is archived for the future on an FTP location for re-submission purposes if necessary in the future.
Step 2: Upload to ERP
The second step is to consume the FBDI file generated in Step 1 and upload the file to ERP.
ERP exposes web services (mainly SOAP) to upload data to ERP. While these services can be made use directly using a SOAP call, there are some complexities involved in terms of dealing with a binary file like zip file to upload data and receive data.
Retrieving and uploading the zip files using a simple SOAP call maybe little cumbersome. Fortunately, OIC has an ERP Adapter that abstracts several of these complexities. So, for all the cases, the ERP Adapter is used.
Step 3: Receive Callback from ERP
In this OIC flow, a callback from ERP is received. It is possible to receive a callback on SUCCESS, ERROR or BOTH.
Receive Callback from ERP
The flow is triggered when ERP asynchronously calls back OIC. The callback was configured when the ERP adapter is configured to invoke.
Write Result File
The callback from ERP contains a zip file that has all the results of the jobs that ran on the ERP. This can be written out on to a FTP location.
- OIC orchestration pattern helps us in designing complex integration scenarios.
- ERP Adapter helps to integrate with Oracle ERP Cloud.
- ERP Adapter provides encapsulation especially dealing with batch integration using FBDI.
- OIC is the prefered service when it comes to integrating between SaaS and SaaS or On-prem and SaaS. OIC offers the depth of integration capabilities dealing with Oracle SaaS.
- Oracle Integration Cloud (OIC) For Beginners Overview
- [Free Masterclass] Oracle Integration Cloud Services
- 6 Docs Every Oracle Cloud Integrator Must Read
- 25 Free Exam Question Guide [1Z0-1042] Oracle Cloud Platform Application Integration 2019 Associate
- Enterprise resource planning
- Enterprise performance management
Check out our FREE Guide on “25 Exam Questions for Oracle Integration Cloud Service” that will help you to clear your doubts and concepts about OIC before starting your career in this. Click on the Below image to download the free guide.
Click on the Image below to join our FREE Community group.