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.
Last updated on JUNE 21, 2017
Applies to:Oracle Incentive Compensation - Version 220.127.116.11 and later
Information in this document applies to any platform.
@Currency check on Nov 23, 2015.
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.
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