During Upgrade to 12.2.0, Script CNSCA.ODF Fails - Create Index CN_SCA_RULE_ATTRIB_ALL_TL_U2 - The index cannot be created as the table has duplicate keys.
(Doc ID 1674721.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Incentive Compensation - Version 18.104.22.168 and later
Information in this document applies to any platform.
During the upgrade to 12.2.0, the script cnsca.odf fails with the following error :
The table is missing the index CN_SCA_RULE_ATTRIB_ALL_TL_U2
or index CN_SCA_RULE_ATTRIB_ALL_TL_U2 exists on another table.
Create it with the statement:
Start time for statement below is: Sat Jan xxxxxxxxx
CREATE UNIQUE INDEX CN."CN_SCA_RULE_ATTRIB_ALL_TL_U2" ON
CN.CN_SCA_RULE_ATTRIBUTES_ALL_TL (SCA_RULE_ATTRIBUTE_ID, ORG_ID, LANGUAGE)
LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11
MAXTRANS 225 COMPUTE STATISTICS TABLESPACE APPS_TS_SEED
AD Worker error:
The index cannot be created as the table has duplicate keys.
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