Integrating Oracle ESS Jobs through web services.
Oracle ESS Jobs otherwise known as Enterprise Scheduler Service in Oracle cloud are the Programs which are capable to perform various jobs in the cloud application these are analogous to Concurrent Programs in Oracle EBS applications.
While there are many standard ESS jobs delivered by oracle, to integrated these jobs with a third party applications we use web services. We can use any open source web service testing utility for service invocation.
In this Blog I will be demonstrating the ESS job invocation using below approaches.
1. SOAP UI
2. POSTMAN
3. Standalone Java Code.
Initial task to invoke any ESS job requires identifying required parameters (names/datatypes/values) of the ESS Job along with few important job definition values for the web service call to invoke a specific job.
Identifying the ESS Job Definition
To get the ESS Job definition, we have to Navigate through Navigator > Setup and Maintenance
Search for the tasks “Manage Enterprise Scheduler Jobs” for the respective offerings.
In this example I am using the
Workforce Deployment Offering for HCM application.
Click on the Manage Enterprise Scheduler Job Definitions and Job Sets … link
Search for the exiting Jobs, in this example I am using “Retry Payroll process” job definition as an example.
Click on Edit Icon to view the complete job definition
The Job definition is listed as below.
Navigate to User Properties to view the Parameters of the Job
The parameters which are not Read only can be passed through the webservice.
Below are the required to invoke the above job definition as a webservice.
|
Name |
JReRunJob |
|
Path |
/oracle/apps/ess/hcm/batchProcesses/core/ |
|
Job Application Name
|
EarHcmEss |
Parameters
|
Name |
Data
Type |
Default
Value |
|
pay.payroll_action_id |
Numeric |
|
|
EXT_PortletContainerWebModule |
String |
ORA_HCM_UI |
|
pay.pay_request_id |
Numeric |
|
Invoking Web service using SOAPUI
As initial step we will create a new SOAP Project
In the Project properties window, we should provide the hostname
The Methods which can be invoked are imported automatically.
Click on SubmitRequest method
Populate the Job definition values retrieved from the Job definition also pass the parameters values for which the request has to be submitted.
To add the application username and password, Click on Auth Tab and Choose “Add New Authorization”
Select Basic and Click on Ok. Provide the Username and password of the Fusion application
Rightclick on the Request editor and Add the WSS Username Token and select the PasswordText
Right click in the editor again and add WS-Timestamp
Now Select the WS-A tab and select the Randomly generated MessageID option
Now Run the request to submit the request
The Request ID of the Job Submission is listed as the SOAP response message
Navigate to the Navigator > Tools> Scheduled Processes
Search for the request id, ESS Job is submitted and scheduled from the SOAP UI.
