Upgrading from 12.1.1 to 12.1.3 (Patch 9239090) FAILED: file perdor.odf - The Index Cannot Be Created (Doc ID 1266529.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Human Resources - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 26-Dec-2014***

Symptoms

When attempting to upgrade from R12.1.1 to R12.1.3 (patch 9239090),
the following error occurs.

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.

 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Performing upgrade from R12.1.1 to R12.1.3 (patch 9239090)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms