ESS Job name not display in Report

Question

We are trying to build a report for the list of ess jobs scheduled but we are no able to get the full name of the ess job scheduled only a short name is available is there any table to hold the display name of the ess job?

If try to get from ess_request_history some schedule job name not populate.

Please let me know if any Query or solution for this.

Regards

Deepak

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/61433#Comment_61433

I don't think this is possible as these details are stored as METADATA not in direct tables.

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

There is an idea already submitted for the same. Please evaluate and upvote:

Required ESS Schedule Process Job Name — Cloud Customer Connect (oracle.com)

Thanks.

Narendra Simha Reddy · Answer

Hi Friends,

How can I get Ess Job Display Name, I tried History , Property Table(ESS_REQUEST_HISTORY,ESS_REQUEST_PROPERTY and FUSION_ORA_ESS.REQUEST_HISTORY) but no use, Is there any table??

Thanks

Mallikarjuna Kuppauru-Oracle · Answer

Hi @Deepak.h.singh-Oracle

ESS Job are related to Fusion apps/Oracle apps product, can you post your question using below link -

https://community.oracle.com/customerconnect

Regards,

Arjun