How to Create an ESS Job for a BI Report in Oracle Fusion

How to Create an ESS Job for a BI Report in Oracle Fusion

If you are working with Oracle Fusion Applications, you might often need to schedule or automate BI Publisher reports. This is done by creating an ESS (Enterprise Scheduler Service) job for the BI report. In this blog, we will walk through the step-by-step process of creating an ESS job for a BI report in Fusion with best practices.

---

What is ESS in Oracle Fusion?

ESS (Enterprise Scheduler Service) is the job scheduling framework in Oracle Fusion. It allows you to run, schedule, and monitor background processes like:

• BI Reports

• Data loads

• Batch jobs

• Integrations

Using ESS, you can automate BI Publisher report execution and distribute outputs in formats like Excel, PDF, or CSV.

---

Prerequisites

Before creating the ESS job, make sure you have:

• Access to BI Publisher (Reports & Analytics).

• A saved BI Report in a custom or shared folder.

• Role with BI Administrator / ESS Administrator privileges.

---

Steps to Create an ESS Job for a BI Report

1. Create the BI Report

1. Login to Oracle Fusion → Tools → Reports and Analytics.

2. Create or open the BI Publisher report you want to schedule.

3. Save the report in a custom folder (not seeded folders).

---

2. Note the Report Path

• Go to Catalog.

• Right-click the report → Click Properties.

• Copy the Report Path (e.g., Shared Folder/Custom/Report Name.Xdo).

---

3. Create the ESS Job Definition

1. Navigate: Setup and Maintenance → Search: Manage Enterprise Scheduler Job Definitions and Job Sets.

2. Click Create New Job Definition.

3. Fill the details:

• Name: Report Name

• Display Name: Report Display Name

• Job Type: BIPJobType (for BI Reports)

• Parameter List: Enter if the report has parameters.

• Report Path: Paste the BI Report path copied earlier.

• Output Format: PDF / Excel / CSV as needed.

4. Save and Deploy

• Click Save and Close.

• Your ESS Job is now available in the Fusion scheduler.

---

5. Run the ESS Job

1. Navigate: Tools → Scheduled Processes.

2. Click Schedule New Process.

3. Search by the Display Name you created.

4. Provide input parameters (if any).

5. Submit the process.

6. Monitor under Scheduled Processes page to check status and download output.

---

Best Practices

• Always save BI reports in Custom Folder, not Oracle’s seeded folders.

• Use clear job names for easy identification.

• For recurring jobs, set Schedule Options (daily, weekly, monthly).

• Test with small data before scheduling large reports.

---

Why Use ESS for BI Reports?

• Automates repetitive reporting tasks.

• Reduces manual errors.

• Ensures timely delivery of business reports.

• Supports multiple output formats for different stakeholders.

---

Conclusion

Creating an ESS job for a BI report in Oracle Fusion makes reporting automated, reliable, and efficient. Whether you want daily sales data, monthly payroll, or inventory reports, ESS ensures your reports run on time without manual intervention.

By following the steps above, you can easily integrate BI Publisher reports into Fusion’s scheduler and streamline business reporting.