Oracle Fusion/Technical/ESS

ESS_REQUEST_HISTORY

Fusion scheduled process (ESS) request history — one row per job submission with state and timing.

Key Columns

REQUESTIDDEFINITIONSTATEREQUESTEDSTARTPROCESSSTARTPROCESSENDPARENTREQUESTID

Child Tables

ESS_REQUEST_PROPERTY

Name/value properties of an ESS request — submission parameters, submitting user, and internal flags.

Common Joins

ESS_REQUEST_PROPERTYvia REQUESTID

The submission parameters and system properties of the request.

Used In

ESS

Notes

STATE is numeric — 3 = RUNNING, 7 = SUCCEEDED, 8 = ERROR, 9 = WARNING, 10 = CANCELLED (varies by release).

Finding scheduled job / concurrent request runs

In EBS, job runs are FND_CONCURRENT_REQUESTS (program in FND_CONCURRENT_PROGRAMS), keyed by PHASE_CODE / STATUS_CODE. In Fusion, scheduled processes are ESS_REQUEST_HISTORY with parameters in ESS_REQUEST_PROPERTY.