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 JANUARY 03, 2023
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
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document