nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Query Regarding Job Names in ESS_REQUEST_HISTORY and ESS_REQUEST_PROPERTY Tables

Syed-1

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

Find more posts tagged with

Fusion AI Data Platform

Accepted answers

JohnW-Oracle

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

All comments

JohnW-Oracle

Hi @Syed-1 ,

Nothing has really changed since the last Community post you mentioned.

You could log an Enhancement Request via the Ideas Lab.

It is here: https://community.oracle.com/products/oracleanalytics/categories/idealab-fusion-analytics and the link is in this KM Article: (Doc ID 3021611.1)

Regards,

John

Syed-1

Hi John,

Thanks for the quick update!

I will raise an Enhancement Request via the Ideas Lab.

Regards

Syed Hussain

JohnW-Oracle

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