You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

REST API for ESS Jobs In Oracle Fusion Not Returning All the columns Data

edited 4:37PM in Fusion Applications Administration

Summary:

As a part of our audit requirement we need to get the logs of all the ESS jobs that have errored for every hour.
We have utilized the REST API below & did an POC to get all the errored ESS jobs from one of our non-prod instance & it returned most of the columns data as null except the request id & state.

REST API-Query job requests: ess/rest/scheduler/v1/requests
Documentation-Link: https://docs.oracle.com/en/cloud/saas/applications-common/25d/farca/op-ess-rest-scheduler-v1-requests-get.html

Request operation we used while invoking API (GET): https://<Fusion-URL>/ess/rest/scheduler/v1/requests?q=state eq "ERROR" and submissionTime gt "2025-12-01T12:00:00Z" and submissionTime lt "2025-12-08T16:56:00Z"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!