Oracle Fusion AI Data Platform

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion AI Data Platform› Oracle Fusion AI Data Platform

Categories

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ESS JOB Name is empty in ESS_REQUEST_HISTORY table

Received Response
1623
Views
1
Comments
Akula123
Akula123 Rank 1 - Community Starter
edited Aug 13, 2024 7:52PM in Oracle Fusion AI Data Platform

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.

Ess Job.PNG

Answers

  • Koteswararao Yenikepalli
    Koteswararao Yenikepalli Rank 3 - Community Apprentice

    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.