Audit Views with _AV# (#>100) Are Not Dropped by Audit Trail Update Table

(Doc ID 2341249.1)

Last updated on JANUARY 19, 2018

Applies to:

Oracle Application Object Library - Version 12.2 to 12.2.7 [Release 12.2]
Information in this document applies to any platform.


The "Audit Trail Update Table" concurrent program will not drop the audit views with _AV# (#>100) for audittrail group with status Disable-purge table.


The issue can be reproduced at will with the following steps. AR table has been provided just an example, these steps can be performed on any table with 100+ columns to audit.

1. Set audittrail on AR table:
1.1. Set the audit trail group status of AR.AR_SYSTEM_PARAMETERS_ALL to Enabled - requested.
1.2. Run the program "AuditTrail Update Tables"
1.3. Confirm AR_SYSTEM_PARAMETERS_ALL_AV# (# is from 1 to 129) have been created.
      SQL> select object_name from dba_objects where object_name like 'AR_SYSTEM_PARAMETERS_ALL_AV%';

2. Perform the audit trail status change in order to drop all audit trail related objects:
2.1. Do a status change. Set the group status of AR.AR_SYSTEM_PARAMETERS_ALL to Disable-purge table
2.2. Run program "AuditTrail Update Tables"
2.3. Confirm the views AR_SYSTEM_PARAMETERS_ALL_AV# have remained for # > 100.
      SQL>select object_name from dba_objects where object_name like 'AR_SYSTEM_PARAMETERS_ALL_AV%';


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