Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

patch 16226394 - CREATE UNIQUE INDEX BOM.BOM_STRUCTURES_B_U1 unique keys error

edited Nov 5, 2014 10:00AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

patch 16226394 results in 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.

Use the following SQL statement to identify the duplicate keys:

SELECT OBJ_NAME, PK1_VALUE, PK2_VALUE, ALTERNATE_BOM_DESIGNATOR, count(*)

   FROM BOM.BOM_STRUCTURES_B

GROUP BY OBJ_NAME, PK1_VALUE, PK2_VALUE, ALTERNATE_BOM_DESIGNATOR

    HAVING count(*)>1

AD Worker error:

Unable to compare or correct tables or indexes or keys

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center