Oracle fusion ess tables

Oracle fusion ess tables

 

In this Post , We will discuss about Oracle fusion ess tables. 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 Oracle fusion ess tables sql Query and Detail Description.

 

 

There are two Oracle fusion ess tables.

 FUSION.ESS_REQUEST_HISTORY
 FUSION.ESS_REQUEST_PROPERTY

SQL query Using Oracle fusion ess tables

 

 

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