Scheduled processes are the backbone of automation within Oracle Fusion Cloud Applications, facilitating tasks that would otherwise require significant manual effort. Oracle Fusion’s Enterprise Scheduler Service (ESS) automates complex, resource-intensive tasks like bulk data imports, record updates, and recurring notifications. ESS spans across ERP, SCM, CX, and HCM modules, ensuring seamless, efficient business operations.
REST API in oracle fusion apps, offering greater flexibility in managing ESS jobs. This REST API facilitates automation, orchestration, and integration by enabling operations like job submission, cancellation, and monitoring.
Options to Access ESS Processes
- Fusion Cloud Application UI – The Scheduled Processes work area allows users to submit and manage processes directly
- REST API / Web Services – Provides integration and automation capabilities by accessing ESS processes programmatically
ESS REST API Methods :
ESS Job details can be accessed through REST API using below APIs :
| Description | Method | REST Endpoint Example |
|---|---|---|
| List running jobs | GET | /ess/rest/scheduler/v1/requests/?q=state eq “RUNNING” |
| Get job details | GET | /ess/rest/scheduler/v1/requests/{requestId}?fields=@full |
| Cancel a job request | POST | /ess/rest/scheduler/v1/requests/{requestId}/cancel |
| Hold a job | POST | /ess/rest/scheduler/v1/requests/{requestId}/hold |
| Force cancel | POST | /ess/rest/scheduler/v1/requests/{requestId}/forceCancel |
ESS Job Scheduling Best Practices
- Plan and Schedule Strategically
- Run critical jobs during off-peak hours to avoid resource contention
- Space out job executions to minimise ESS queue overload
- Limit job sets to 20 jobs to simplify troubleshooting
- Optimise Performance
- Fine-tune the number of threads for critical jobs.
- Educate users to avoid redundant or unnecessary job scheduling.
- Governance and Maintenance
- Implement governance to centralise job scheduling.
- Leverage submission notes to document job details for easy maintenance.
- Monitor for failures periodically and address stuck jobs using the Cancel/Force Cancel options.
- Environment Refresh Considerations
- ESS Job Definitions do not migrate during environment refreshes. Reestablish custom jobs and reset necessary parameters post-refresh
Submitting an ESS Job Using REST API
Get Metadata of the job from Scheduled Process work area for the ESS Job you want to access via rest API
Metadata of Send Susbcription Billing Information to Receivables is SubscriptionBillingMainJob.
Request:
{
"description": "Testing from postman",
"jobDefinitionId": "JobDefinition://oracle/apps/ess/subscriptions/subscriptionManagement/billing/SubscriptionBillingMainJob",
"application": "CrmEss"
"requestParameters": [
{
"name": "submit.argument2",
"paramType": "STRING",
"value": "300000006931006"
}
]
}Response
{
"id": 4860510
}