Is there a generic ESS job that can submit any report dynamically

July 1, 2021 General
Generic ESS Job to submit

Generic ESS Job to submit any report job

Business Requirement:

Got a requirement for extracting a lot of data via multiple BIP reports for Enterprise Data Warehouse or any other vendor?

Creating ESS Jobs to schedule so many BIP reports is a tedious task. Also, they need to be created every time an instance gets cloned/refreshed… “Sounds like a pain?”

Well, no more, we have solution to all the misery of manual effort of creating multiple ESS jobs:

“Generate Data File for Export”

Yes! you heard it right, there is an ESS job provided by oracle to submit a report where the Report id is passed as parameter.

Below are the details:

Display Name Generate Data File for Export
Name FinOutboundProcess
Path /oracle/apps/ess/financials/commonModules/shared/common/outbound/
Description Generates an outbound report data file and uploads it to the Unified Content Management server for users to access.

WSDL: https:///fscmService/ErpIntegrationService?WSDL

Below is the sample request payload:

<soapenv:Envelope xmlns:soapenv=””















<!–Zero or more repetitions:–>




Sample Screenshots:


ESS Job- Request


ESS Job Response

ESS Job Submitted in Fusion:

ESS Job Submitted Fusion

View Output:

Output- ESS Job


  • This process can extract only CSV File Type as an Output file.
  • This process will not generate any Report history for obvious reasons.
  • This “Generate Data File for Export” ESS Job with these extended hidden parameters can be invoked only from web service.

Reference Oracle Documentation: How to Run the Processes to Extract Data from Fusion Financials (Doc ID 2316943.1)