List of tables which are impacted by Scheduled Processes
List of tables which are impacted by Scheduled Processes

 530 total views

We normally run many Scheduled Processes in fusion. some of them to keep the users in sync, updating the search keywords, sending pending ldap requests, refresh manger hierarchy, etc to name a few.

If you are really interested in finding out the underlying tables which gets impacted by these processes, you can run the below query immediately after the process runs to success and check the tables for change in inserts/updates/deletes count.

Select * from all_tab_modifications order by timestamp desc

Sample result will look like:

If you have any questions, please feel free to reach out to me by posting in comments section.

If you are interested in learning Fusion Technical tools go through this post

If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

Leave a Reply