How to audit data changes made by HDL — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to audit data changes made by HDL

We need a way to query and audit data changes made by FUSION_APPS_HCM_ESS_LOADER_APPID.

If a data change was made by FUSION_APPS_HCM_ESS_LOADER_APPID, we need a way to know which HDL Data Set the update came from and which user loaded the HDL file into HCM.

I have tried querying the table HRC_DL_DATA_SETS and it gives me the information about the Data Set and who created it but I can't find a way to link this table to another table like PER_ALL_ASSIGNMENTS_M wherein LAST_UPDATED_BY is equivalent to FUSION_APPS_HCM_ESS_LOADER_APPID.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!