EGL: CANNOT CREATE UNIQUE INDEXES IN APPLICATION DESIGNER FOR CHARTFIELD1, CHARTFIELD2 AND CHARTFIELD3
(Doc ID 967381.1)
Last updated on SEPTEMBER 26, 2022
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.
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.
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