Upgrading PeopleTools - Alter Index Script Fails On Project and Contract Tables With ORA-01452: Cannot CREATE UNIQUE INDEX (Doc ID 2024541.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9 to 9.2 [Release 9]
PeopleSoft Enterprise FIN Project Costing - Version 9 to 9.2 [Release 9]
PeopleSoft Enterprise PT PeopleTools - Version 8.51 to 8.54 [Release 8.4]
Information in this document applies to any platform.

Symptoms

On : PeopleTools 8.54 and Financials 9.1

In doing the upgrade from 8.51.25 to 8.54.12 on FSCM 9.1 Demo database, when running INITALTAUD_alttbl.sql and INITALTAUD_crtidx.sql, the following error occurs for several tables during the latter script:

ERROR
-----------------------
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

This happens on the following tables:

PS_CA_PR_SUMM
PS_CA_RECON_REV
PS_CA_SUM_IN_USE
PS_LEDGER_KK
PS_PC_SUM_USE_TAO
PS_PC_SUMMARY_TBL
PS_PROJ_CAT_SUB
PS_PROJ_CATG_TBL
PS_PROJ_RES_TYPE
PS_PROJ_RT_GRP_MAP
PS_PROJ_SUBCAT_TBL
PS_PROJ_TYPE_CAT

 

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