Is there a generic ESS job that can submit any report dynamically
Generic ESS Job to submit any report job
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|
|Description||Generates an outbound report data file and uploads it to the Unified Content Management server for users to access.|
Below is the sample request payload:
|<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” |
<!–Zero or more repetitions:–>
ESS Job Submitted in Fusion:
- 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)