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 FEBRUARY 01, 2023
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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |