Audit Trail Update Table Program Failed with Error 'ORA-00955: name is already used by an existing object' (Doc ID 2065012.1)

Last updated on OCTOBER 12, 2015

Applies to:

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

Symptoms

Enabling the audit trail on some custom tables and these custom table names are similar and some tables characters exceed 24 characters.

Example: Table names are:

XXXXX_FC_LASER_INSCRIBER

XXXXX_FC_LASER_INSCRIBER_SN

 

When running the Audit trail update table program, the request completed with error.  The following below error messages in the log file:

----->Create New Table
CREATE TABLE XXXXX_FC_LASER_INSCRIBER_A (AUDIT_TIMESTAMP DATE NOT NULL, AUDIT_TRANSACTION_TYPE VARCHAR(1) NOT NULL, AUDIT_USER_NAME VARCHAR2(100) NOT NULL, AUDIT_TRUE_NULLS VARCHAR2(250), AUDIT_SESSION_ID NUMBER NOT NULL, AUDIT_SEQUENCE_ID NUMBER NOT NULL,AUDIT_COMMIT_ID NUMBER NOT NULL, ROW_KEY NUMBER )
ORA-00955: name is already used by an existing object
ORA-00955: name is already used by an existing object
/u01/tst/apps/apps_st/appl/fnd/12.0.0/bin/FNDATUPD
Program was terminated by signal 11

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