E1: CFR11: Unable to Enable Auditing On Table F03012 - Error <There is already an object named 'F03012_ADT_PK' in the database> (Doc ID 2908713.1)

Last updated on DECEMBER 21, 2022

Applies to:

Symptoms

Unable to enable auditing on table F03012 (Customer Master) after data refresh. Before data refresh, auditing was working fine in the affected environment and later it was disabled (this is part of the action when data refresh is done in an environment which has auditing enabled) . However while trying to enable auditing again, this process failed. The affected environment is a custom environment and data refresh was done from production environment to custom environment.

Steps to Replicate:

1. Login to the affected custom environment via Fat Client
2. Open P9500003 (Object and Table Configuration) application
3. Select table F03012 and disable auditing
4. Perform data refresh from production environment to custom environment. (This issue is not directly related to data refresh, this can happen when data refresh is not involved as well)
5. Try to enable auditing on F03012 via P9500003 application
6. This process fails with error "DB Audit Component Status Incomplete"

Below error is captured on the screen while trying to enable auditing on F03012 via P9500003

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.