ORA-00955: name is already used by an existing object

(Doc ID 1948825.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Agile Product Collaboration - Version 9.3.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 9.3.3.0 version, Item & BOM
AUT Logs have the following errors

create table aa_nodetable as select * from nodetable
  [exec] *
  [exec] ERROR at line 1:
  [exec] ORA-00955: name is already used by an existing object



  [exec] ALTER TABLE MANUFACTURERS drop column CONTACTID
  [exec] *
  [exec] ERROR at line 1:
  [exec] ORA-00904: "CONTACTID": invalid identifier



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