Oracle Cloud Fusion HCM Solutions

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' ) ;

If you find that a worker's user account is in suppressed status, it means the username is already assigned to another user. Use following query to check the status of user account in LDAP. SELECT  PAPF.PERSON_NUMBER,         PPNF.LAST_NAME,         PPNF.FIRST_NAME,         PU.USERNAME,         PU.ACTIVE_FLAG,         LDAPU.REQUEST_STATUS,         LDAPU.USERNAME LDAP_USERNAME,         LDAPU.REQUEST_TYPE,         LDAPR.ACTIVE_FLAG LDAP_ACTIVE_FLAG,         LDAPR.REQUEST_DATE,         LDAPR.LDAP_REQUEST_ID FROM PER_ALL_PEOPLE_F PAPF,      PER_PERSON_TYPE_USAGES_M PPTUM,      PER_PERSON_NAMES_F PPNF,      PER_USERS PU,      PER_LDAP_REQUESTS LDAPR,      PER_LDAP_USERS LDAPU WHERE PAPF.PERSON...