Russia Localization, Patch 18722934 Is Failing with Error ORA-01452: Cannot CREATE UNIQUE INDEX; Duplicate Keys Found (Doc ID 2032216.1)

Last updated on DECEMBER 07, 2016

Applies to:

EMEA Add-on Localizations - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Russia Add-on Localizations

Patch 18722934 is failing with below Error
ERROR
-----------------------
Error ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
CREATE UNIQUE INDEX "CLE"."CLE~PF~TABLES~UI" ON "CLE"."CLE_PF_TABLES" ("R_ID", "ZD_EDITION_NAME")
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 4096 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"

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