PurgeAudits Batch Is Not Purging The Records From Audit Related Table ACTIVITY_HISTORY (Doc ID 2143286.1)

Last updated on JUNE 27, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.


"PurgeAudits" batch is not purging the records from audit related table (ACTIVITY_HISTORY), instead the adhoc count purge procedure is being called in the server application.

The logs of the server application is as follows:


The issue can be reproduced at will with the following steps:

1. Make sure to have audit records in ACTIVITY_HISTORY table eligible to be purged (CREATE_DATE is older than parameter DAYS_TO_HOLD_AUDIT_RECORDS value)
    To find the value of the parameter use:  SELECT VALUE FROM CONFIG_SYSTEM WHERE NAME ='DAYS_TO_HOLD_AUDIT_RECORDS';
2. Run PurgeAudits batch
3. Observe that no record in ACTIVITY_HISTORY is purged

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms