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_HISTORY2.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
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 |
0 comments:
Post a Comment