Is there a generic ESS job that can submit any report dynamically
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:
Response:
ESS Job Submitted in Fusion:
View Output:
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)