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.
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:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
This happens on the following tables:
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