Create ESS Job from BIP Report in Oracle Fusion

In this post we will look at how to define an ESS Job Definition using BIP Report.

 

• For this create a Report with below data model. For detailed steps click here
  

• Now select the report and click More -> Schedule

• Copy the Report path (/Custom/ESSDemo/InvoiceReport.xdo), this will be the Report Id
  

•  Now go to Setup and Maintenance and search for the task "Manage Enterprise Scheduler Job". Click to open it.
  

• Click on Add button

• Manage Job Definitions screen will be opened. 

• Enter the below information

 

 

Name: Only alphanumeric characters with no spaces

Path: Name of the folder to store the job definition. This folder is created in /oracle/apps/ess/custom/

• Now add the parameter by clicking the add icon in Parameters tab. And click Save and Close once done

• Now click Save and Close to save the Job Definition

• Make sure that we get the below message:

• Now we can run this job from Scheduled processes as below:

• Enter the Invoice Source and click Submit button

• Job will be submitted and Request Id will be shown:

• You can query it in process screen

• The Job set and Job Definitions are not stored in any DB tables to query. They are xml documents stored in MDS DB which cannot be queried using SQL.
• Below are the tables to get information about ESS Request:

ESS_REQUEST_HISTORY

ESS_REQUEST_PROPERTY

Source: https://docs.oracle.com