Report for scheduled Process

Charan Kollipara

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.

Julian Challenger-Oracle

Moved to OBIEE forum.

Shravan S Kumar-Oracle

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

Regards
Shravan kumar

MandeepKGupta

Hi Charan,

Please see below if it helps:

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

Thanks.

Charan Kollipara

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

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

Thank you so much Mandeep.

Andrada-Oracle

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

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.