Friday 2 October 2020

How to create an ESS Job in Oracle fusion for a BIP report

This post provides the details about how to create an ESS job for the Oracle BIP report. Below are the steps mentioned below. 

Before creating the ESS Job, get the details of the Report ID from the Oracle BIP catalogue.

Go to the OTBI catalog. Navigate to the Shared Folders -> Custom -> Required BIP Report.



In this case the path for the Test Report would be from Custom. You need to remove the Shared Folders.

Report ID would be : /Custom/TestFolder/Test Report.xdo

1. Navigate to the "Setup and Maintenance" in Settings Action.





2. Do the global search with the following value 

"Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications"




3. Once in the screen, click on '+' to create a New ESS Job





4. Provide the following details :





    a. Enter the Display Name  : Display Name

    b. Name 

    c. Path 

    d. Description

    e. Job Application Name

    f. Report ID :  Provide the BIP details with the above details.

  5. Enable submission from Scheduled Processes

  6  Enter the Input parameters if any for the BIP report

      Click on '+'




      Enter the Parameter Prompt

      Data Type

      


            


  7. Save and close.

This would create the ESS job, which you can submit it from the Scheduled Process



      

No comments:

Post a Comment