12.2 Upgrade Patch 10124646 Worker Fails Creating Index FND_IMP_DEPOBJECTS_U1 in File afptch.odf with Error "The index cannot be created as the table has duplicate keys." (Doc ID 2116304.1)

Last updated on APRIL 13, 2016

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2.5 [Release 12.2Cloud to 12.2]
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2, Upgrade related issues

When attempting to apply the 12.2.0 upgrade patch (<Patch 10124646>), the following error is received:

FAILED: file afptch.odf on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.
CREATE UNIQUE INDEX APPLSYS."FND_IMP_DEPOBJECTS_U1" ON
APPLSYS.FND_IMP_DEPOBJECTS (SNAPSHOT_ID, OBJECT_TYPE, OBJECT_NAME) LOGGING
STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 22 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 SNAPSHOT_ID, OBJECT_TYPE, OBJECT_NAME, count(*)
FROM APPLSYS.FND_IMP_DEPOBJECTS
GROUP BY SNAPSHOT_ID, OBJECT_TYPE, OBJECT_NAME
HAVING count(*)>1

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