Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Report for scheduled Process

345
Views
8
Comments

Summary

Required Report to pull details of Scheduled Processes

Content

Hi Experts,

 

I would like to know is there any seeded report or query available to pull the details of the scheduled processes.

We have the requirement to pull the scheduled processes details.

Regrads,

Charan teja.

Comments

  • Julian Challenger-Oracle
    Julian Challenger-Oracle Rank 6 - Analytics Lead

    Moved to OBIEE forum.

  • Shravan S Kumar-Oracle
    Shravan S Kumar-Oracle Rank 1 - Community Starter

    You should be able to pull the details from ess_request_history table by select query.

    Regards
    Shravan kumar

  • MandeepKGupta
    MandeepKGupta Rank 1 - Community Starter

    Hi Charan,

    Please see below if it helps:

    https://cloudcustomerconnect.oracle.com/posts/a56655eb87

    Thanks.

  • Charan Kollipara
    Charan Kollipara Rank 2 - Community Beginner

    Hi Mandeep,

    Thanks for the quick response.

    Could you please let me know from  which table we can pull the ESS job definition details (from Manage Enterprise Scheduler Job definition and Job sets for human capital management and related applications )

    Regards,

    Charan.

  • MandeepKGupta
    MandeepKGupta Rank 1 - Community Starter

    Hi Charan,

    As per MOS  -> What are the Tables Where the ESS Jobs and Custom Job Sets are Stored? (Doc ID 2430380.1)

    The Jobset and Job Definitions are not stored in any DB tables to query. They are xml documents stored in MDS DB which cannot be queried using SQL.

    Thanks.

  • Charan Kollipara
    Charan Kollipara Rank 2 - Community Beginner

    Thank you so much Mandeep.

  • Andrada-Oracle
    Andrada-Oracle Rank 1 - Community Starter

    Hi Charan,


    Please use the table: select * from fusion.ess_request_property and let us know if this will help.

    select * from fusion.ESS_REQUEST_PROPERTY where requestid in (select requestid from FUSION.ESS_REQUEST_HISTORY where absparentid='<ParentID>');


    regards

    Andrada

  • Andrada-Oracle
    Andrada-Oracle Rank 1 - Community Starter

    Fusion Apps - ER - Report Of ESS Job Parameters Under Scheduled JobSet Before First Execution (Doc ID 2557895.1)

    ENH 29952731 - ER - REPORT OF ESS JOB PARAMETERS UNDER SCHEDULED JOBSETS BEFORE FIRST EXECUTION

    Once you schedule a job, please allow the first schedule to complete for entries to be generated in fusion.ess_request_history & fusion.ess_request_property and you can verify the parameters submitted on the child Jobs through these tables.