Planning ODS Load Worker Fails With Ora-01452: Cannot Create Unique Index on SYSTEM_ITEMS_U1_xxx (Doc ID 559998.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

While trying to run Data Collections, the Planning ODS Load Worker fails with:

28-MAR 11:16:54 : ERROR
28-MAR 11:16:54 : Unique index violated - SYSTEM_ITEMS_U1_TST
28-MAR 11:16:54 : ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
28-MAR 11:16:54 : ======= Below records violate the unique constraint =======
28-MAR 11:16:55 : PLAN_ID -1 / SR_INSTANCE_ID 2023 / ORGANIZATION_ID 84 / INVENTORY_ITEM_ID 26361
28-MAR 11:16:55 : ===========================================================
28-MAR 11:16:55 : <>
28-MAR 11:16:55 : <> CREATE UNIQUE INDEX SYSTEM_ITEMS_U1_TST ON
SYSTEM_ITEMS_TST(PLAN_ID,SR_INSTANCE_ID,ORGANIZATION_ID,INVENTORY_ITEM_ID) PARALLEL TABLESPACE
APPS_TS_TX_IDX STORAGE( INITIAL 1048576 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE
0) INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
28-MAR 11:16:55 : ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
28-MAR 11:16:55 : UNIQUE index creation on temporary table SYSTEM_ITEMS_TST has completed with
ERROR.
28-MAR 11:16:55 : User-Defined Exception
28-MAR 11:16:55 : User-Defined Exception
28-MAR 11:16:55 : User-Defined Exception
28-MAR 11:16:55 : Sending message :-9999999 to monitor.


Steps:
Run collections, and note that one of the Planning ODS Load Workers completes with a status of Error.

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