Following are the oracle fusion job schedule processes tables which helps to extract the submitted ESS job requests:
- ESS_Request_History
- ESS_Request_Property
- Request_History
- Request_History_view
Here below is the Detail SQL query for the ESS job Schedule processes:
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 r.requestid = v.requestid
order by r.requestid, v.name
BI SQL Query sample to read data based on the last run date from the ess request history table:
https://soalicious.blogspot.com/2022/03/erp-bi-sql-query-to-fetch-output-based.html
No comments:
Post a Comment