The index cannot be created as the table has duplicate keys - Patch 16000686
Dear Colleagues,
after upgrade from R12.0.6 to R12.1.1 i have to apply patch 16000686
this path stuck with an error "CREATE UNIQUE INDEX HR.HR_DOCUMENT_TYPES_U1 ON HR.HR_DOCUMENT_TYPES
(SYSTEM_DOCUMENT_TYPE) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 )
PCTFREE 0 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."
i found one note id :1446163.1 but i don't understand which document_type_id should i delete ?
see attched worker.log file
Any help?
Regards
Chaker