EGL: CHARTFIELD1_TBL INDEXES WILL NOT CREATE DUE TO UNIQUE CONSTRAINT AFTER TOOLS OR BUNDLE UPGRADE - Error: ORA-01452: Cannot CREATE UNIQUE INDEX; Duplicate Keys Found
(Doc ID 966641.1)
Last updated on MARCH 08, 2018
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.
***Checked for relevance on 28-Apr-2011***
***Checked for relevance on 19-Nov-2012***
***Checked for relevance on 29-Apr-2014***
***Checked for relevance on 08-Mar-2018***
Create index on ps_chartfield1_tbl failing during tools upgrade or while applying application bundle(s)
Sequence of events
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
Some tools upgrade or bundle scripts create indexes correctly
What does not work
Script for chartfield1_tbl does not complete successfully; instead fails with duplicate keys error
Tools upgrade or application of bundle(s) can not be completed in development, and thus can not be migrated forward to production
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!