Oracle Fusion scheduled process table

Oracle Fusion scheduled process table

In this post , we will be discuss about Oracle Fusion scheduled process table. Oracle Fusion schedule process tables helps to store the ess jobs submitted in oracle fusion application.With the help of ess job tables , we can see the Old ESS jobs submitted in Fusion application. This is the Same thing like Find_Concurrent_requests table to find the history of the Concurrent Programs submitted by the user. ess job tables helps to find out Here below is the ESS request history tables sql Query and Detail Description.

Oracle Fusion scheduled process table

2 Important Oracle Fusion scheduled process table

1.FUSION.ESS_REQUEST_HISTORY
2.FUSION.ESS_REQUEST_PROPERTY

SQL query using Oracle Fusion scheduled process table to Extract ESS job informations

 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

Oracle Fusion scheduled process table

Oracle Fusion scheduled process table

Oracle Fusion scheduled process table

In this post , We will be discuss about the Oracle Fusion Schedule process table. We do know that , Schedule processes helps to submit the ESS jobs in oracle fusion. To run any ESS job , We need to go to the Schedule process and then submit it from there. So in Schedule Processes , We do get the complete records of all the ESS jobs submitted in oracle fusion application in past. To extract this kind of Information , we do need the schedule process tables. Schedule process in oracle fusion is more like concurrent requests in oracle apps. So to find out all the submitted ess jobs in oracle fusion , either we need to go to the Schedule processes dashboard or use these oracle fusion schedule process tables.

 

2 Important Oracle Fusion scheduled process table

 1.ESS_REQUEST_HISTORY
 2.ESS_REQUEST_PROPERTY

 ESS_REQUEST_HISTORY :- 

In this table we do get the , Schedule processes which submitted in oracle fusion. We do get the Complete information's about the schedule process like the Name of the ESS job , Submitted Date , ESS job Status , User Who Submitted this Job.

ESS_REQUEST_PROPERTY :- 

In this table , We do get the Information's about the Schedule process parameters and its values. If we want to know , The said schedule process submitted with which parameters values , then we need to refer this Table.

SQL query Using Oracle Fusion scheduled process table

select r.requestid, r.name "ESS Job Name",r.EXECUTABLE_STATUS "JOB STATUS",R.USERNAME,R.APPLICATION,R.PRODUCT,R.REQUESTEDSTART,R.COMPLETEDTIME from fusion.ess_request_history r,fusion.ess_request_property v
 where 1=1
  --and definition = 'JobDefinition://oracle/apps/ess/cdm/dataquality/sync/'
  and r.requestid = v.requestid
order by r.requestid, v.name

 

Oracle Fusion scheduled process table