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