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."
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.
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
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(*)
GROUP BY SNAPSHOT_ID, OBJECT_TYPE, OBJECT_NAME
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms