Oracle Fusion ess job definition tables

Oracle Fusion ess job definition tables

Oracle Fusion Ess job definition tables help to store the ESS job registration information’s in oracle fusion. We do get the information about, Job Name, Job Type, Job Report Path and ESS job parameters information’s. We can use these Ess job definitions tables to get the Ess Job Registration information in oracle fusion but in Oracle fusion SAAS environment, we cannot access the ess job definition table. The reason is Oracle fusion ess job definition do not store in any tables. These Info store as metadata in MDS repository which we cannot access in SAAS model.

Detail Discussion about oracle fusion ess job definition tables

As I said above, there is no DB table in oracle fusion to store the ess job definition tables. I would share the Oracle support Document id which is saying that Ess job definitions do not store in any DB tables in oracle fusion

Please refer metalink Note (What are the Tables Where the ESS Jobs and Custom Job Sets are Stored? (Doc ID 2430380.1))

The Job set and Job Definitions are not stored in any DB tables to query. They are xml documents stored in MDS DB which cannot be queried using SQL.

Here below I am sharing the oracle fusion ess job schedule processes tables which helps to extract the submitted ESS job requests in oracle Fusion.

1.ESS_REQUEST_HISTORY
2.ESS_REQUEST_PROPERTY

3. REQUEST_HISTORY

4. 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