My Oracle Support Banner

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 OCTOBER 12, 2020

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.