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

MOSC Banner

The index cannot be created as the table has duplicate keys - Patch 16000686

edited Aug 20, 2021 10:04AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

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

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