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=”http://schemas.xmlsoap.org/soap/envelope/”

xmlns:typ=”http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/”>

<soapenv:Header/>

<soapenv:Body>

<typ:submitESSJobRequest>

<typ:jobPackageName>/oracle/apps/ess/financials/commonModules/shared/common/outbound

</typ:jobPackageName>

<typ:jobDefinitionName>FinOutboundProcess</typ:jobDefinitionName>

<typ:paramList>#NULL</typ:paramList>

<typ:paramList>/Custom/NB/Interfaces/SCM/Vizient/ADS/VizientItemMasterReport.xdo

</typ:paramList>

<typ:paramList>BIPONLY</typ:paramList>

<typ:paramList>#NULL</typ:paramList>

<typ:paramList>#NULL</typ:paramList>

<typ:paramList>1762</typ:paramList>

<!–Zero or more repetitions:–>

</typ:submitESSJobRequest>

</soapenv:Body>

</soapenv:Envelope>

Sample Screenshots:

Request:

ESS Job- Request

Response:

ESS Job Response

ESS Job Submitted in Fusion:

ESS Job Submitted Fusion

View Output:

Output- ESS Job

Limitation:

  • 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)