- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.1K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
SQL Query to get all the Scheduled Processes in Oracle SaaS (and also Process ID)
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.