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.
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
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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |