Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Report for scheduled Process
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
-
Moved to OBIEE forum.
0 -
You should be able to pull the details from ess_request_history table by select query.
Regards
Shravan kumar0 -
Hi Charan,
Please see below if it helps:
https://cloudcustomerconnect.oracle.com/posts/a56655eb87
Thanks.
0 -
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.
0 -
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.
0 -
Thank you so much Mandeep.
0 -
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
0 -
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.
0