Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Query Regarding Job Names in ESS_REQUEST_HISTORY and ESS_REQUEST_PROPERTY Tables

Accepted answer
125
Views
3
Comments
Syed-1
Syed-1 Rank 1 - Community Starter
edited Aug 13, 2024 7:08PM in Oracle Fusion Data Intelligence

Hi,

We are creating a BI Report to fetch the ERROR and WARNING jobs during the day by looking into the tables ESS_REQUEST_HISTORY and ESS_REQUEST_PROPERTY. However, we could not find any column that shows the "job name," such as "Create Accounting," "Synchronize Notification Data from BPM to HCM," "Learn Migration," etc.

We found a question raised by someone earlier for the same scenario in January 2021:
https://community.oracle.com/products/oracleanalytics/discussion/11021/ess-job-name-is-empty-in-ess-request-history-table?utm_source=community-search&utm_medium=organic-search&utm_term=Query+ESS+job+

In the meantime, has Oracle fixed the job name in any table?

Regards

Syed Hussain

Best Answer

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach
    Answer ✓

    Hi @Syed-1 ,

    Sounds good. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the community members who might have a similar concern find the answer easier.

    Regards,

    John

Answers