Process Description for Registering ESS Jobs

The following is a high level description on how to register Oracle Business Intelligence Publisher report extracts as ESS jobs.

1. Define the Data Extract SQL.

   The source for the BI Publisher report is a data model which defines the source query and the parameter definition. Before an extract may be defined, the source extract SQL must be defined.

   For more information, see Defining the Data Extract Process.

2. Create the data model for the BI Publisher report extract.

   For more information, see Creating the Data Model for the BI Publisher Report Extract.

3. Create the BI Publisher report extract.

   For more information, see Creating the BI Publisher Report Extract.

4. Create the Oracle Enterprise Scheduler (ESS) job to run in asynchronous mode.

   This step is only required when running the extract in asynchronous mode. You create a custom ESS job for the extract report.

   For more information, see Creating an Oracle Enterprise Scheduler (ESS) Job.

5. Create an integration in the Oracle Enterprise Performance Management Cloud using the BI Publisher report extract as the source.

   For more information, see Creating the Integration Definition Between EPM Cloud and the BI Publisher Report Extract.