Creating ESS Jobs for Oracle Fusion BIP Reports

Topics:
1. Introduction to ESS Jobs
2. Creating ESS Jobs for Fusion BIP Reports
3. Running the ESS Job

In Oracle Fusion Cloud, an Enterprise Scheduler Service (ESS) job is a scheduled process that automates the execution of various business processes and tasks. ESS jobs enable users to manage, schedule, and monitor the execution of these processes without manual intervention, ensuring that tasks are performed consistently and on time.

Types of ESS Jobs: Predefined & Custom ESS Jobs

This will show all the steps to create Data Model and ESS Job for the BIP Report in Oracle Fusion Cloud

1. CREATING ESS JOBS FOR ORACLE
FUSION BIP REPORTS
BY GURPREET SINGH

2. TOPICS

3. INTRODUCTION TO ESS JOBS

4. WHAT IS ESS JOB?
In Oracle Fusion Cloud, an Enterprise Scheduler Service (ESS) job is a scheduled process that automates the
execution of various business processes and tasks. ESS jobs enable users to manage, schedule, and monitor the
execution of these processes without manual intervention, ensuring that tasks are performed consistently and on
time.

5. KEY FEATURES OF ESS JOBS
Scheduling and Automation - ESS jobs can be scheduled to run at specific times or intervals, automating routine
tasks such as data imports, exports, financial close processes, and report generation. Jobs can be scheduled to run
once, on a recurring basis (daily, weekly, monthly), or triggered by specific events.
Error Handling and Notifications - ESS jobs can be configured to send notifications upon completion or failure,
allowing administrators to quickly respond to issues.
Resource Management - Jobs can be assigned to different work shifts and resource pools to optimize resource
utilization and ensure that high-priority jobs get the necessary resources.
Integration - ESS jobs can be used to integrate different modules within Oracle Fusion Cloud and with external
systems, facilitating data movement and process synchronization.

6. TYPES OF ESS JOBS
ESS Jobs
Predefined
Jobs
Custom
Jobs

7. PREDEFINED ESS JOB

8. CREATING ESS JOBS FOR FUSION BIP REPORTS

9. CREATING DATA MODEL
•Login to BIP Catalog
•Click on New → Data Model

10. CREATING DATA MODEL
•Click on add New Data Set and select SQL Query

11. CREATING DATA MODEL
•Enter the Name of Data Set- Q1
•Select the Data Source- ApplicationDB_FSCM
•Type of SQL- Standard SQL
•SQL Query- SELECT owner,object_type,object_name FROM all_objects
WHERE object_type = NVL(:pObjectType, object_type)

12. CREATING DATA MODEL
•Select the check box to add parameter to the data model

13. CREATING DATA MODEL
•Parameter will be added, just change the Display Label

14. CREATING DATA MODEL
•Go to List of Values option and click add button to add new List of Values

15. CREATING DATA MODEL
•Provide the Name, select Type & Data Source and enter the SQL

16. CREATING DATA MODEL
•Go to parameter and select Parameter Type as Menu

17. CREATING DATA MODEL
•Select the List of Values from the list

18. CREATING DATA MODEL
•Save the data model and Click on View Data button, then save the sample data.

19. •Create report on the basis of this Data Model

20. •Click on More option and choose Schedule

21. •Copy the Report location

22. •Go to Setup & Maintenance

23. •Click on Tasks button and click Search option

24. •Search for Manage%Enter%Sched% and click on the below link

25. •Go to Manage List of Values Sources tab and click Create button

26. •Choose Application Name : Financials Common Module
•Enter LOV Name : ObjectTypeLOV
•LOVType : User Defined
•Provide the query:
SELECT object_type FROM (SELECT DISTINCT object_type FROM all_objects) ORDER BY
object_type

27. •Go to Manage Job Definitions and Click on the Create button

28. •Enter the Display Name: this will be used when you want to submit the ESS Job
•Name: this will be just like short name of ESS Job
•Job Application Name as FscmEss, Application as Financials Common Module, Job Type as BIPJobType
•Report Id will be the location of BIP Report which we copied earlier
•Add parameter and select created LOV and then click Save and Close

30. •Go to the Navigation Menu and click Scheduled Processes.
•In Scheduled Processes Screen click Schedule New Process button

31. •Enter the name of the ESS Job and press Tab
•Select the ESS Job from the list and click OK

32. •Choose the parameter and click Submit and ESS Job will be submitted