I must admit: there are number of web resources that already address similar issues. However, I intend to delve into a rather specific case that extends the functionality that has been previously presented.
We need a custom BIP reports' ETEXT output to be distributed via email (or directly to FTP) according to the predefined bursting profile. This BIP report has several parameters thus tanking the Scheduled OTBI Job creation option off the table. We will have to create a new custom ESS Job for this task.
Let’s
break it down a bit:
1.
Create a BIP report with parameters that
generates ETEXT output.
I will not waste your time on this trivial task: creating a Data Model + ETEXT
template.
The following session by Naresh might be a good reference: https://www.youtube.com/watch?v=x1NYTefDbAg
The only two things worth mentioning are: the bursting profile for email distribution and storing the new reports' path we would require for ESS job creation:
a. To have an ETEXT file properly delivered, make sure to include the TEMPLATE_FORMAT and OUTPUT_FORMAT parameters inside the bursting query attached to the Data Model, e.g. 'ETEXT' as TEMPLATE_FORMAT, 'text' as OUTPUT_FORMAT.
b. Make sure to fetch the report path via reports for future usage in ESS jobs definition.
History->Report path:
2. Create a new custom ESS Job.
From Setup and Maintenance -> Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications (Manage Job Definitions TAB).
Another session by Naresh could serve as a good reference, so you are advised to watch it prior to the jobs' creation: https://www.youtube.com/watch?v=uDV3mDXR0bQ
Let's settle for a Job name: Custom ESS Job BLAH BLAH
3. The way I see it - the next step is the most critical for task completion:
We create a set of parameters for the ESS Job that are completely “synchronized” with the BIP reports’ parameters.
But first, let's create a LOV source (List of Values) for them (a good reference https://docs.oracle.com/en/cloud/saas/financials/24c/faiac/manage-list-of-values-sources.html#s20059933)
a. We will locate and edit our ESS Job
Setup and Maintenance -> Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications. Locate our ESS job:
select and edit:
4.
Now you can run the " Custom ESS Job BLAH
BLAH " from Tools--> Scheduled Processes.
The ETEXT (txt) output file would be delivered to the email mentioned in the bursting profile.