Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Query Regarding Job Names in ESS_REQUEST_HISTORY and ESS_REQUEST_PROPERTY Tables

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
-
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
0
Answers
-
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: Doc ID 3021611.1)
and the link is in this KM Article: (Regards,
John
0 -
Hi John,
Thanks for the quick update!
I will raise an Enhancement Request via the Ideas Lab.
Regards
Syed Hussain
0