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.

Symptoms


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




Changes

 

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
Changes
Cause
Solution
References


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