ESS request history table : SQL query to find the ESS job History in Oracle Fusion

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