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 JUNE 21, 2017

Applies to:

Oracle Incentive Compensation - Version 11.5.10.2 and later
Information in this document applies to any platform.
@Currency check on Nov 23, 2015.

Symptoms

 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

Statement executed.

AD Worker error:
The index cannot be created as the table has duplicate keys.



Cause

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