ESS request history table : SQL query to find the ESS job History in Oracle Fusion
In this Post , We will discuss about ESS request history table. With the help of this table we can see the Old ESS jobs history from Fusion application. This is the Same thing like Find_Concurrent_requests table to find the history of the Concurrent Programs submitted by the user. Here below is the ESS request history tables sql Query and Detail Description.There are two ESS request history table
FUSION.ESS_REQUEST_HISTORY
FUSION.ESS_REQUEST_PROPERTY
SQL query to find the ESS job History in Oracle Fusion
select r.requestid, USERNAME, PROCESSSTART, PROCESSEND, EXECUTABLE_STATUS, v.name, v.value
from fusion.ess_request_history r,
fusion.ess_request_property v
where r.application = 'CrmEss'
and definition = 'JobDefinition://oracle/apps/ess/cdm/dataquality/sync/'
and r.requestid = v.requestid
and v.name like 'submit.argument%'
order by r.requestid, v.name
