My Oracle Support Banner

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

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