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.
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
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
| Symptoms |
| Cause |
| Solution |