OIC - ERP - Download ESS Job's output and log file using ErpIntegrationService web service in Oracle Integration

ErpIntegrationService web service can be used to start an ESS job in Fusion Applications, to monitor status and to download the output and log file. 

In order to retrieve the output and log file of an ESS request following two operations are available:

1. downloadESSJobExecutionDetails
2. downloadExportOutput

Usecase : 

Here, we will see how to download ESS job's output and log files using ErpIntegraionService and Oracle ERP Cloud connection in Oracle Integration.

Detailed steps with screenshots:

Step1:  create an Oracle ERP Cloud connection.

https://soalicious.blogspot.com/2023/03/oic-create-erp-cloud-adapter-connection.html

Step2: create an Integration to call the oracle ERP adapter and configure. Once get the response, call a sftp connecrion and map the response content or .zip file to a location.

Similarly we can call the downloadExportOutput operation, it will give us the same response.

Note: 

In real project scenario, we can do the following:

• Check the ESS job whether it is succes (operation: getESSJobStatus)
• If success, download the logs and output using operation : downloadESSJobExecutionDetails
• Write the response contents to a stage location.
• Unzip the files using stage
• Write the exact file needed to a sftp location or mail as attachment or use as enrichment to a map.

Following filetype predicate can be put to separate the file read.