patch 16226394 - CREATE UNIQUE INDEX BOM.BOM_STRUCTURES_B_U1 unique keys error
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