EGL: CANNOT CREATE UNIQUE INDEXES IN APPLICATION DESIGNER FOR CHARTFIELD1, CHARTFIELD2 AND CHARTFIELD3 (Doc ID 967381.1)

Last updated on MARCH 14, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.4 to 9.2 [Release 8.4 to 9]
Information in this document applies to any platform.
***Checked for relevance on 09-Jun-2011***
***Checked for relevance on 05-Sept-2011***


Symptoms

When using Application Designer to Build The Current Definition (when chartfield1_tbl is open)and select Create Indexes, the system will produce SQL that does not include the field CHARTFIELD1 even though it belongs in two of the indexes.

Chartfield1 is used as an example. Sam e issue is also observed for chartfield2 and chartfield3


Steps:
-------
1. Ensure chartfield1 and chartfield2 are set as active on Standard Chartfield Configuration page.
2. Run chartfield configuration
3. Build indexes

Error:
------
CREATE UNIQUE INDEX UDBT11.PS_CHARTFIELD1_TBL ON UDBT11.PS_CHARTFIELD1_TBL (SETID, EFFDT DESC) USING STOGROUP PSSGIUPG PRIQTY 48 SECQTY 720 CLUSTER BUFFERPOOL BP3 CLOSE NO

SQL0603N
A unique index cannot be created because the table contains rows which are duplicates with respect to the values of the identified columns.
SQLSTATE=23515


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