HRMS RUP7 patch application failed with error
Issue APPLYING an E-Business patch via ADPATCH
FAILED: file perdor.odf on worker 15
The table is missing the index HR_DOCUMENT_TYPES_U1
or index HR_DOCUMENT_TYPES_U1 exists on another table.
Create it with the statement:
Warning: Object "HR_DOCUMENT_TYPES" is not registered in table "FND_OBJECT_TABLESPACES".
Start time for statement below is: Mon Sep 22 2014 20:57:19
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.