How You Audit Objects Loaded in Bulk

You can audit changes made to objects when you bulk load them using either HCM Data Loader or HCM Spreadsheet Data Loader. When audit is enabled, the creation, update, and deletion of objects are audited.

This topic describes how to enable and manage audit for bulk-loaded objects.

Tip: Enable audit only for incremental updates and not during data migration.

Enabling Audit for Bulk-Loaded Objects

Auditing is optional. To audit bulk loading of objects, you must:

  1. Perform the Manage Audit Policies task in the Setup and Maintenance work area to select objects and their attributes for audit.

  2. Enable auditing in general on the Manage Audit Policies page.

  3. Enable auditing of bulk-loaded data, either for the enterprise or in individual .dat files and spreadsheet templates.

Enabling Audit for HCM Data Loader

The Enable Audit Data parameter on the HCM Data Loader parameters tab of the Configure HCM Data Loader page controls audit for the enterprise. By default, Enable Audit Data is set to No, but you can override that setting. Alternatively, you can enable audit selectively by including the following SET instruction in relevant .dat files:

SET ENABLE_AUDIT_DATA Y

Enabling Audit for HCM Spreadsheet Data Loader

The Enable Audit Data parameter on the HCM Spreadsheet Data Loader parameters tab of the Configure HCM Data Loader page controls audit for the enterprise. By default, the Enable Audit Data parameter is set to No, but you can override that setting. Alternatively, you can enable audit selectively by setting the Enable Audit Data parameter in the relevant spreadsheet template to Yes.

When to Enable Audit for the Enterprise

Setting the Enable Audit Data configuration parameters to Yes for the enterprise may affect performance. Consider enabling audit in this way only for ongoing integrations.

Purging Audit Data

You may want to purge audit data, typically when disposing of personally identifiable information in worker records. By default, the purging of audit data is disabled for the enterprise and you can't override this setting at the enterprise level. However, you can include the following SET instruction in individual .dat files:

SET PURGE_AUDIT_DATA Y

In spreadsheet templates, you can set the Purge Audit Data parameter to Yes. These instructions purge the audit data for the business objects in the .dat file or spreadsheet.

Restrictions exist on enabling audit and purging data at the same time. You can't include both of the following SET instructions in a single .dat file:

SET ENABLE_AUDIT_DATA Y
SET PURGE_AUDIT_DATA Y

Similarly, you can't include both of the following parameter values in a spreadsheet template:

Parameter

Value

Enable Audit Data

Yes

Purge Audit Data

Yes

To purge audit data when auditing is enabled for the enterprise, you must disable audit in the same .dat file or spreadsheet template. That is, you must do one of the following:

  • Include a SET_ENABLE_AUDIT_DATA N instruction in the same .dat file.

  • Set the Enable Audit Data parameter in the spreadsheet template to No.

Correcting Load Errors for Audited Objects

When audit is enabled for an object, you can't correct load errors for it in the HCM Data Loader user interface. For example, your .zip file may contain both Worker and Job objects. If you include the SET ENABLE_AUDIT_DATA Y instruction in the Worker.dat file only, then you can't correct load errors from that file in the user interface. However, you can correct errors in the Job objects, as audit isn't enabled in the Job.dat file.