Unique Index BOM_STRUCTURES_B_U1 Creation Error Due To Duplicate Keys (Doc ID 553020.1)

Last updated on FEBRUARY 18, 2017

Applies to:

Oracle Bills of Material - Version 11.5.10.0 and later
Information in this document applies to any platform.
This document includes all versions of Oracle EBS 11i and R12

BOM_STRUCTURES_B_U1


Symptoms

During upgrade to R12 from R11.5.10 get the following error:

CREATE UNIQUE INDEX BOM.BOM_STRUCTURES_B_U1 ON BOM.BOM_STRUCTURES_B
(OBJ_NAME, PK1_VALUE, PK2_VALUE, ALTERNATE_BOM_DESIGNATOR) 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.
ERROR
The index cannot be created as the table has duplicate keys.

 

Verified not these issues:

 

Changes

R12 upgrade  from 11.5.10.2

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