12.2 Upgrade: Script jlzzap.odf CREATE UNIQUE INDEX JL."JL_ZZ_AP_INV_DIS_WH_U2" Failed

(Doc ID 2001475.1)

Last updated on OCTOBER 06, 2016

Applies to:

Oracle Financials for the Americas - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

You upgraded from 11.5.10.2 to R12.2 and receive the following error for jlzzap.odf:

ERROR
-----------------------
CREATE UNIQUE INDEX JL."JL_ZZ_AP_INV_DIS_WH_U2" ON
JL.JL_ZZ_AP_INV_DIS_WH_ALL (INVOICE_DISTRIBUTION_ID, SUPP_AWT_CODE_ID)
LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11
MAXTRANS 255 COMPUTE STATISTICS TABLESPACE APPS_TS_TX_IDX

Statement executed.


AD Worker error:

The index cannot be created as the table has duplicate keys.

Use the following SQL statement to identify the duplicate keys:


AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above

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