ENABLE AUDIT FOR HCM DATA LOADER AND HCM SPREADSHEET DATA LOADER

ENABLE AUDIT OF DATA LOADED:

From new releases 18C we can audit the changes made to objects, that we loaded using HCM Data loader or HCM spread sheet data loader.

In Configure HCM Data Loader, we can set the Enable Audit Data parameter on the HCM Data Loader parameters tab.

By default, this parameter is No, we need to override to Yes.

Or

We can pass below line in .dat file

SET ENABLE_AUDIT_DATA Y

Similarly, for HCM spread sheet data loader:

In Configure HCM Data Loader, we can set the Enable Audit Data parameter on the HCM spread sheet data loader parameters tab.

By default, this parameter is No, we need to override to Yes.

Or

We can enable it directly in relevant spreadsheet templates to Yes.

We can audit of data loaded in bulk. To do that:

 In Manage Audit Policies task à Enable auditing level. And we can audit to attributes level in configure Business object attributes.

Creation, update, and deletion of objects are audited when audit is enabled.

Audit of data loaded in bulk has negative impact on performance.

We can purge the audit data for any object by using SET PURGE_AUDIT_DATA Y instruction in .dat files or by using the Set the Purge Audit Data parameter to Yes in spreadsheet templates.

By default, the purging of audit data is set to No in enterprise level we can’t override this parameter.

We cannot enable and purge the audit at a time by using below instructions: (HDL and HCM Spreadsheet data loader)

SET PURGE_AUDIT_DATA Y

SET ENABLE_AUDIT_DATA Y

While purging of audit data to Yes in a .dat file or spreadsheet template, we must disable the audit at that time. SET ENABLE_AUDIT_DATA N

If SET ENABLE_AUDIT_DATA Y for a particular object, the we can't correct load errors for it on the HCM Data Loader Object Errors.

It may helpful for you. please visit blog for more information and share your ideas.

Thanks,

Sainath