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.

    Image shows the Setup and Maintenance option.

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

    Image shows the Setup page.

  3. Click Search.

    Image shows the Search option.

  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.

    Image shows the Search page.

  5. On the Manage Job Definitions page, clickImage shows the Add icon. 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.

      Image shows the Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications page

  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.

    Image shows Create Parameter page.

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

    Image shows the Parameters page.

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

    Image shows Search and Select Name page

    Image shows Process Details page.