Forum Stats

  • 3,759,488 Users
  • 2,251,551 Discussions
  • 7,870,675 Comments

Discussions

SQL Query to get all the Scheduled Processes in Oracle SaaS (and also Process ID)

Hello fellas!


I would like to know if there is a table where I could get all scheduled processes from Oracle ERP Cloud.

I have tried FUSION.ESS_REQUEST_HISTORY and FUSION.ESS_REQUEST_PROPERTY but those only contains a column named "RequestId" which as far as I know is not the same as the Process Id shown on ERP Cloud Scheduled Processes page.


I did a little test looking for any of the requestids shown on that table through the Scheduled Processes page and couldn't find any. So they are not the same field.

I would also like to know where can I get the documentation for this tables:

FUSION.ESS_REQUEST_HISTORY and FUSION.ESS_REQUEST_PROPERTY


I looked for them on the HCM book and couldn't find them.

https://docs.oracle.com/en/cloud/saas/applications-common/20d/oedma/index.html


Cheers!

Tagged:
***=Luis=***