EGL: CANNOT CREATE UNIQUE INDEXES IN APPLICATION DESIGNER FOR CHARTFIELD1, CHARTFIELD2 AND CHARTFIELD3
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***
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
1. Ensure chartfield1 and chartfield2 are set as active on Standard Chartfield Configuration page.
2. Run chartfield configuration
3. Build indexes
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
A unique index cannot be created because the table contains rows which are duplicates with respect to the values of the identified columns.
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