Patch 4440000 Fails on BOMSTRC.odf Create Unique Index Bom.Bom_structures_b_u1 (Doc ID 464701.1)

Last updated on OCTOBER 15, 2015

Applies to:

Oracle Bills of Material - Version: 11.5.10.0 to 11.5.10.0 - Release: 11.5 to 11.5
Information in this document applies to any platform.
*** Checked for relevance 07-Jun-2010 ***

Symptoms

During R12 upgrade main <Patch 4440000> fails with the following BOM error.

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.

Steps
  1. Apply R12 <Patch 4440000> with adpatch.
  2. Receive the 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