- About Us
- Events and Webinars
- Contact Us
Oracle Cloud ERP Release 12 has provided multiple ways to integrate and exchange data from/to external systems. More details about each of the available options can be found in the Oracle Enterprise Repository: http://www.oracle.com/webfolder/technetwork/docs/HTML/oer-redirect.html
Centroid has implemented many Cloud ERP integrations relevant to a particular business use case for many clients.
With this post, we will share a few recent examples. We recently implemented an integration of GL journal data from an external source to Oracle Cloud ERP using our in-house built tool we call “Centroid Integrator.” The implementation of this integration took less than one week to complete the full cycle i.e. design, build, test and deploy and one week for stabilization.
We would like to share the approach for performing the integration step by step.
Our customer has multiple business systems that they maintain for a variety of business activities each of which generates large volumes of financial transactions on a daily basis. Our customer required all of these externally generated transactions to be automatically integrated into Oracle Cloud ERP to post to the General Ledger providing a single consolidated view.
And for this purpose, our customer wanted an interface designed to integrate the daily GL journal transactions from the external systems to Oracle Cloud ERP via data files. And these transactions should be processed every day scheduled at specific times. Below is the delimited data format provided by the customer:
|Converted Debit Amount|
|Converted Credit Amount|
|Journal Entry Creation Date|
|Journal Line Description|
In addition to the above, our customer also wanted to have the following functionality included in the design of the integration.
The first and foremost step for any integration in Oracle Cloud ERP is to determine whether Oracle has provided any pre-built options that can be leveraged in support of your requirements. We follow a simple process to help make an approach decision.
After our initial analysis, we found that Oracle Cloud ERP provides both FBDI and SOAP web service for the purpose of uploading GL Journal data.
As the inbound data is sent as a delimited file and data can also vary, we evaluated both options to determine the best fit.
And based on the type of interface and customer requirements, we chose the FBDI template approach as it supports bulk data loads.
As per the flowchart above, the format and contents of the source data files provided by the customer do not match directly with the FBDI template required by Oracle Cloud ERP. For this purpose, we have to transform the data file to the corresponding FBDI template format. During the design and development of this interface, we faced several challenges and some of them are highlighted below.
Below is our solution approach:
With Centroid Integrator, we can create our own PLSQL custom program units to validate the data per your specific requirements and mark the records with a status of Success or Failure.
This step is the heart and soul of the Centroid Integrator. This step will use the WebService required to interface the compressed file to Cloud ERP and in turn receives the response. This is all automated using Centroid Integrator simplifying the work required by the user.
Note: Oracle Cloud ERP has BI publisher webservices available to execute the reports and to download the report data. For this requirement, there is just an option to check in the Centroid Integrator for the above steps. Once enabled, Centroid Integrator will take care of the process for you.
Centroid Integrator is a cloud-based software-as-a-service integration platform developed by Centroid specifically designed for Oracle Cloud ERP applications and is a proven tool for converting key pillar and historical data and integrating key transactional data with Oracle cloud applications like ERP, SCM, Financials, PPM, HCM and CRM.
Like the example above, these integrations can be completed and production ready in less than a week using Centroid Integrator. It uses a combination of familiar technologies such as, SQL Loader, SQL, PLSQL, host scripts, Java based Web services SOAP/REST, and emailing features to accommodate the integrations. Business users just need to upload the file to a designated location and the rest of the functionality will be taken care by the integrator. A very simple and easy to use tool.
All the above features are default features and capabilities of the Centroid Integrator and are reusable components for all of your integration needs.
Still have questions? Contact Centroid to learn more about Oracle Cloud ERP Integrations and how Centroid can help.
Centroid is a cloud services and technology company that provides Oracle enterprise workload consulting and managed services across Oracle, Azure, Amazon, Google, and private cloud. From applications to technology to infrastructure, Centroid’s depth of Oracle expertise and breadth of cloud capabilities helps clients modernize, transform, and grow their business to the next level.