Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Jean DonairesNov 5 2020

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!

Added on Nov 5 2020

#business-intelligence-applications, #enterprise-metadata-management, #hcm, #system-management-and-integration, #table

0 comments

5,574 views