Failed ESS jobs (last 30 days)
All ESS requests that ended in ERROR/WARNING in the last 30 days — incident triage and ITGC operations evidence.
Tables used
ess_request_history
Bind parameters
None — the statement runs as written; edit the literals in the WHERE clause to narrow it.
How to run it
Paste it into a BI Publisher data model as a SQL data set, or into QueryWell's Query Studio and run it against your pod with a reporting account. Results come back to a grid you can profile, chart and export with a SHA-256 hash.
SELECT r.requestid, r.application, r.definition, r.submitter, r.state, r.processstart, r.processend
FROM ess_request_history r
WHERE r.processstart >= SYSDATE - 30 AND r.state IN (8, 9, 10, 15)
ORDER BY r.processstart DESCA single read-only SELECT against Oracle Fusion Cloud's supported reporting surface. Column names and views can differ by release and by the roles your reporting account holds, so validate the result against a report you already trust before relying on it.
essfailureops
More Scheduler (ESS) queries
ESS scheduled jobs in last 24h
All ESS requests submitted in the last 24 hours with status — operations dashboard view.
Long-running ESS jobs (>30 min)
ESS requests whose runtime exceeded 30 minutes in the last 7 days — performance hotspots.
Currently active ESS jobs (running / waiting)
ESS requests in a non-terminal state (wait/ready/running/blocked/hold/paused). STATE is a numeric ESS code. Operations view of in-flight work.
Run it without the template cycle
QueryWell runs this and 81 other curated scripts against your own Fusion pod from one signed desktop app — grid, charts, profiling and hashed exports included. Perpetual licence, 14-day trial.