ESS JOB Name is empty in ESS_REQUEST_HISTORY table

Akula123

Content

Hi Experts,

I have Scheduled a Custom ESS Job. once the job is submitted. i am trying to retrieve the details from ESS_JOB_HISTORY table.

but when i try to query the table i can see that Name column is empty. can some one please suggest where can i get the ESS Job name and metadata name from fusion table.

Koteswararao Yenikepalli

as of now, oracle is not storing the scheduled job names in any other tables

FUSION_ORA_ESS.REQUEST_HISTORY
FUSION_ORA_ESS.REQUEST_PROPERTY

you will able to see the definition it means the report location, by using this we can decode the job named manually.