E-CA: Step "Updating PeopleTools System Tables" Failed for Creating Table PSPTCS_MNULINKS With "ORA-00955: name is already used by an existing object" (Doc ID 2182474.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.51 and later
Information in this document applies to any platform.

Symptoms

On : 8.55 version, Change Assistant

In doing a PeopleTools only upgrade from 8.51 to 8.54, when attempting to run the step "Updating PeopleTools System Tables" in Change Assistant, the following error occurred:

ERROR
-----------------------
13:36:45 SQL>
13:36:45 SQL> CREATE TABLE PSPTCS_MNULINKS (PORTAL_NAME VARCHAR2(30) NOT NULL,
13:36:45 2 PORTAL_OBJNAME VARCHAR2(30) NOT NULL,
13:36:45 3 PTCS_MENUID VARCHAR2(30) NOT NULL,
13:36:45 4 PTCS_FOLDERID VARCHAR2(30) NOT NULL,
13:36:45 5 PTCS_SERVICEID VARCHAR2(30) NOT NULL,
13:36:45 6 PTCS_INSTANCEID INTEGER NOT NULL,
13:36:45 7 SEQNUM SMALLINT NOT NULL) PCTFREE 10 PCTUSED 80 INITRANS 1 MAXTRANS 255
13:36:45 8 NOCOMPRESS LOGGING
13:36:45 9 STORAGE(INITIAL 40960 NEXT 106496 MINEXTENTS 1 MAXEXTENTS 2147483645
13:36:45 10 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
13:36:45 11 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
13:36:45 12 TABLESPACE "PSIMAGE"
13:36:45 13 ;
CREATE TABLE PSPTCS_MNULINKS (PORTAL_NAME VARCHAR2(30) NOT NULL,
  *
ERROR at line 1:
ORA-00955: name is already used by an existing object

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the step "Updating PeopleTools System Tables in Change Assistant



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