How to use an ESS Job for the BIP Reports' ETEXT output distribution according to predefined bursting profile

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:

e.g. /Custom/…/…/BLAH_BLAH_BLAH_report.xdo

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

Save and Close.

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:

b.        In the Manage List of Values Sources TAB feel free to define the custom LOV Sources (be advised to use simple queries):

c.        Back at the Manage Job Definitions TAB create (add) the parameters based on the LOV sources created 

before. Make sure the same names are used!!!

Save+Done

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.