Audit on a user in Fusion HCM
If you want to know what all transactions was done by a user in your Fusion HCM Cloud, you need to query FND_AUDIT_USER_TABLE_ACCESS table to find list of tables any specific user has updated/inserted/deleted. If audit framework is enabled in your environment, you should also be able to capture the audit information whether a transaction was inserted, updated or deleted from the base table.
Step 1:
Use below sql to get the list of tables which are modified by the specific user.
select *
from FND_AUDIT_USER_TABLE_ACCESS
where user_name like 'abc';
Step 2:
Query shadow table to get the audit information. So, if the base table is PER_ALL_ASSIGNMENTS_M from step 1, query on the shadow table like below:
select *
from PER_ALL_ASSIGNMENTS_M_
where (last_updated_by = 'abc' or created_by = 'abc' ) ;
Step 1:
Use below sql to get the list of tables which are modified by the specific user.
select *
from FND_AUDIT_USER_TABLE_ACCESS
where user_name like 'abc';
Step 2:
Query shadow table to get the audit information. So, if the base table is PER_ALL_ASSIGNMENTS_M from step 1, query on the shadow table like below:
select *
from PER_ALL_ASSIGNMENTS_M_
where (last_updated_by = 'abc' or created_by = 'abc' ) ;
Those guidelines additionally worked to become a good way to recognize that other people online have the identical fervor like mine to grasp a great deal more around this condition. and I could assume you are an expert on this subject. Same as your blog i found another one Oracle Fusion Cloud Technical .Actually I was looking for the same information on internet for Oracle Fusion Cloud Technical and came across your blog. I am impressed by the information that you have on this blog. Thanks a million and please keep up the gratifying work.
ReplyDeleteThanks for your scripts. It helps.
ReplyDeleteThank You and that i have a keen supply: Where To Learn Home Renovation prefab home addition
ReplyDelete