ess job table name in oracle fusion

ess job table name in oracle fusion

In this post , We will be discuss about ess job table name 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 tables to get the ess Job Registration information in oracle fusion but in Oracle fusion SAAS environment, we cannot access the ess job table. The reason is Oracle fusion ess job tables do not store in any tables. These Info store as metadata in MDS repository which we cannot access in SAAS model.

ess job table name in oracle fusion

Detail Discussion about ess job table name in oracle fusion

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 table name in oracle fusion

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

ess job table name in oracle fusion