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 SEPTEMBER 14, 2016

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***


Symptoms

Issue
====
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

What works
==========
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

Business impacts
==============
Tools upgrade or application of bundle(s) can not be completed in development, and thus can not be migrated forward to production

Error
====
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms