In one of my OA Frameowrk pages, i had encountered a deadlock saying that a process was trying to get a lock/inserting a row in the WF_LOCAL_ROLES table.
I've known my codes and definitely i'm not explicitly inserting on that table, so i guess there must be some other process running on the background or business event that inserts/calls the wf_directory packages.
The deadlock was reported in AWR and saying that a Business Event oracle.apps.global.user.change was running.
If this was not reported as a deadlock i would have not know that there was a bacground process inserting into WF_LOCAL_ROLES.
So right now im looking into the codes of our generic custom controller class and one of the functions that gets called is to GranFunctionAccess (Custom function not oracle seeded). I just inferred on the meaning of the function that this grants function to a user and therefore would "Change" some user details.
So the question do this code/line, trigger a user.change event?