Oracle Applications E-Learning Lab

 In this article, we will learn how to reuse or call already built integration into another integration.  Use case:  REST integration needs to be developed with the capability to read data from an on-prem database instance and generate the CSV file based on the on-premise database instance in an external FTP server  To achieve the use case we need the following things needs to be done 1. Drop the REST Trigger  2. Drop the database connector and configure the SQL statement to read data from the On-Premise instance 3. We have already built an integration 

When the integration service gives a call to transfer data from one system to another system, there is a high possibility of integration running into an erroneous state due to unknown errors. Therefore it becomes imperative to handle errors for the smooth run of integration services.  In this article we will learn what are the different types of exception management are there in OIC and how we can use them Use Case: New REST API will be created to insert data into On-Prem Database Instance.  Create a New Integration, fill in the mandatory details as shown in the snippet Drop the REST trigger to the pallette  Fill in the mandatory details  Select the operation as POST  provide the sample JSON payload  request provide the sample JSON payload  request response Click on the Done button  Now we will drop for a loop since we will go to insert multiple records into the on-premise database table through JSON Payload  Provide the name for the For loop...

 In this tutorial, we will develop a REST API and upon the call of it, CSV File with data will be generated at FTP Server Create a connector for the FTP  Fill the the mandatory details as shown in the screenshot Enter FTP Server details on which you want to copy files Test the connection Now let's create the integration  Select App Driven Orchestration  Fill the relevant details  Drop REST Connector on the pallette  Fill the endpoint name which you want to call  Select the Operation Post and provide the desired URI name Click on JSON Sample   copy the below format { "UserData":[         {          "id":"",          "firstname":"",          "lastname":"",  "email":"",          "qualification":""       },       {          "id":"",          ...