Unable To Capture The ESS Job Output Using financialUtilService Operation downloadESSJobExecutionDetails (Doc ID 2056845.1)

Last updated on SEPTEMBER 16, 2015

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

 Trying to submit an ESS Job request in Oracle Cloud environment from a custom ADF Application using Financial Utils Web Service. 

The job submission was successful and you are able to get the job Id in response of "financialUtilService.submitESSJobRequest()".

The requirement is to capture the output of the job using the "financialUtilService.downloadESSJobExecutionDetails()" operation of the web service.
The following method was written to capture the output content:

List<DocumentDetails> docDetails = financialUtilService.downloadESSJobExecutionDetails(RequestId.toString(), "out");
for(DocumentDetails documentDetails : docDetails )
{
System.out.println("Account: "+documentDetails.getDocumentAccount().getValue());
System.out.println("File Name: "+documentDetails.getFileName().getValue());
System.out.println("Document Title: "+documentDetails.getDocumentTitle().getValue());
System.out.println("DocumentName " + documentDetails.getDocumentName().getValue());
System.out.println("ContentType " + documentDetails.getContentType().getValue());
System.out.println("Content-Value: "+documentDetails.getContent().getValue());
System.out.println("Content: "+documentDetails.getContent());
System.out.println("Document Security Group: "+documentDetails.getDocumentSecurityGroup().getValue());
System.out.println("Document Author: "+documentDetails.getDocumentAuthor().getValue());
}

This returns the following output.
Account: null
File Name: null
Document Title: ESS_L_6776
DocumentName 6776.zip
ContentType zip
Content-Value: [B@109caa6
Content: javax.xml.bind.JAXBElement@1d78908
Document Security Group: Attachments
Document Author: user

However, the actual job output file does not get downloaded.

Note: The same method when called with the fileType parameter "log" it does download the log file for the job. The problem is only with the output (out) file.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms