Empower-business-users-with-custom-ESS-jobs-in-HCM-cloud

Empower business users with custom ESS jobs in HCM cloud

Oracle Cloud Enterprise Scheduler Service (ESS) Jobs are programs based on PL/SQL, BIP Reports, Host, SQL Loader, and other technologies to execute business logic. There are many standards or seeded ESS jobs available in Oracle HCM Cloud. System provides an option to create custom ESS job based on customer needs accordingly.

Fusion Applications ESS Jobs allows to define, control and manage Oracle Enterprise Scheduler job metadata, including job definitions, job requests, job sets (a collection of job requests), incompatibilities and schedules governing the execution of job requests also allow user put parameter while creating ESS jobs and while running the process post creation of job.

The Scheduling process home page provides an overview of the performance of Oracle Enterprise Scheduler components and jobs, including component status, the number of completed job requests in the last hour, as well as the processing times for running jobs.

This page can be used for monitoring and administering Oracle Enterprise Scheduler process.

 

STEPS TO CREATE CUSTOM ESS JOB SCHEDULER:

  • Step 1: Navigate to set-up & maintenance then search for ‘Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications

 

custom-ess-hcm-2

Fig 1: Manage Enterprise Scheduler Job Definition and Job for HCM

 

  • Step 2: Click on + Symbol to create custom ESS job

 

custom-ess-hcm-3

Fig 2: Manage Job Definition

 

Step 3: Fill all the required fields in the below page mentioned in the screenshot to create new ESS Job

NOTE: Report path should be as below:

/oracle/apps/ess/custom/REPORT_NAME/

custom-ess-hcm-4

Fig 3: Create Job Definition

 

Step 4: Schedule job details fields should be as per the below screenshot.

 

custom-ess-hcm-5

Fig 4: ESS Job Details (Mandatory)

 

Step 5: Save and close after filling all the details in Fig 3.

Step 6: Navigate to tools > schedule process and search for the newly created ESS job name.

custom-ess-hcm-6

Fig 5: Schedule Process Overview

 

Step 7: Post successful schedule of the ESS job the result will be available in the output section as shown.

 

custom-ess-hcm-7

Fig 6: Output Section of Schedule Process

 

ADVANTAGES / BENEFITS:

  • Eliminate of access extension to user for reports.
  • System generated stats can be viewed on the no. of hits against custom reports.
  • ESS process is a boon to users to access all frequently used reports.
  • Custom ESS jobs are scheduled on required frequencies (Hourly, daily basis etc)

 

Author:
Prashanth Meti
Oracle HCM Cloud Consultant, Kovaion

Oracle HCM Service

Implement, Enhance, Update & Support Oracle HCM at Zero Cost!

Read More