EGL: CHARTFIELD1_TBL Indexes Not Created Due to "Error: ORA-01452: Cannot CREATE UNIQUE INDEX; Duplicate Keys Found"
(Doc ID 966641.1)
Last updated on OCTOBER 23, 2019
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 8.4 to 9.1 [Release 8.4 to 9]
Information in this document applies to any platform.
Create index on ps_chartfield1_tbl failing during tools upgrade or while applying application bundle(s) with below error:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Steps to replicate:
1. Either during tools upgrade or while applying application bundle(s)
2. Tried to create indexes
3. Index scripts do not include the chartfield field name and fails with duplicate keys error
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