[OIC] Purge Oracle Fusion Interface Data using OIC

 

This post will show how to Purge Oracle Fusion Interface Data using OIC.

 

Scenario - Consider a scenario that you have created OIC Interface to Import Journals into Oracle Fusion ERP. Now, you want that once import is completed, interface tables should purge automatically. So, follow the below steps to implement this:

 

• Callback integration of type Application Driven will be created which will be accepting the callback once "Import Journals" job will be completed. We will be using Oracle ERP Cloud Adapter Connection as trigger point of the integration with below configuration.
  

• Add another Oracle ERP Cloud Adapter Connection, just to get interface ID of import job

Also, get details for Purge job from Fusion by going to Setup and Maintenance -> Search -> Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications

 

InterfaceLoaderPurge

Purge Interface Tables

/oracle/apps/ess/financials/commonModules/shared/common/interfaceLoader/

 

 

• After getting these details you can delete this added action
  
• Now, use the Oracle ERP Cloud Adapter connection again with below options:

• This action will be used to submit the ESS job "Purge Interface Tables" which will actually clear the data from Interface Table
  
• Now map the below payload and right click Parameter List and select Repeat Node:

• Now map the below fields, here Param1 is Interface Id and Param2 is Load Request Id
  

/nssrcmpr:onEvent/inp1:ErpImportBulkDataEvent/inp1:JOBS[inp1:JOBNAME='Load Interface File for Import']/inp1:REQUESTID