Creating an Oracle Enterprise Scheduler (ESS) Job

You register the Oracle Business Intelligence Publisher report as an Oracle Enterprise Scheduler (ESS) Job to run an integration in asynchronous mode. This mode enables you to schedule a job to be executed at specific intervals not subject to timeout restrictions.

To create an ESS job and run an extract in asynchronous mode:

1. In BI Publisher, navigate to My Enterprise, and then select Setup and Maintenance.

   

2. From the Subject Area drop-down, select Financials.

   

3. Click Search.

   

4. Search for Manage Enterprise Scheduler and then select Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications.

   

5. On the Manage Job Definitions page, click to add or create a new ESS job.

6. On the Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications page, complete the following fields:

   1. Display Name—Enter a user-defined name for the extract. This name is displayed under Scheduled Processes.

   2. Name—Specify an alphanumeric name without spaces and special characters.

      This name is used for the ESS Job Name in Data Integration application options.

   3. Path—Specify the path where to save the ESS job.

      This path is created as a subfolder of /oracle/apps/ess/custom. For example, if you specify epm, then the ESS Job path is /oracle/apps/ess/custom/epm.

      The path entered here populates the ESS Job Path field in Data Integration application options.

   4. Job Application Name—Select FscmEss.

   5. Job Type—Select BIPJobType.

      This is a mandatory parameter because Data Integration can only trigger ESS jobs of the type – BIPJobType.

   6. Default Output Format—Select XML.

      The XML output format parameter is output in addition to the CSV format but does not change the CSV format and is not streamed to the Oracle Enterprise Performance Management Cloud.

   7. Report ID—Specify the report path of the custom report defined in the Creating the BI Publisher Report Extract step.

      For example, specify /Custom/MyReport.xdo

   8. Enable submission from Scheduled Processes—Check to enable.

      This option enables you to invoke the job manually and to troubleshoot it in case of a data mismatch.

      

7. On the Data Model components pane, then Parameters , click Create Parameter page.

8. Create parameters for each of the custom report parameters defined in BI Publisher in the same order that they were created for the report.

   

9. On the Parameters page, reorder parameters using the up/down arrow if necessary.

   

10. In the Oracle ERP Cloud, view or submit the BI Publisher job by selecting Schedule New Process.