ess job tables in oracle fusion
In this post , We will be discuss about ess job tables in oracle fusion.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.
 |
| ess job tables in oracle fusion |
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
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
|
| ess job tables in oracle fusion |
2 comments:
If I want to do housekeeping on the request_history table, say I want to delete all old jobs in the database and only keep the current 2 months, can I do this with a simple delete ? will this not cause any issues with it ?
do you know what table stores the parameters/arguments ?
Post a Comment