Upgrading From R12.1 to 12.2 Fails With Error: The Table Is Missing The Index ENG_CHANGE_OBJECTS_TL_U1 Or Index
(Doc ID 2668333.1)
Last updated on MAY 13, 2020
Applies to:Oracle Engineering - Version 12.1.3 and later
Information in this document applies to any platform.
Find index missing after 12.2 Upgrade Failed With an Error
* Upgrading from 12.1.3 to 12.2.0 following <Note 1320300.1> - Oracle E-Business Suite Release Notes, Release 12.2
The table is missing the index ENG_CHANGE_OBJECTS_TL_U1 or index ENG_CHANGE_OBJECTS_TL_U1 exists on another table.
Create it with the statement:
AD Worker - GetIndexAttributes: INFO: ORA-00942: table or view does not exist
Error calling GetIndexAttributes(ENG,ENG_CHANGE_OBJECTS_TL_U1)
AD Worker error: Unable to compare or correct tables or indexes or keys because of the error above
Following steps from the <Note 1320300.1>:
3.1 Apply Consolidated Upgrade Patch and Run 12.2.0 Upgrade (required)
4. Apply the newly merged 12.2.0 upgrade driver : $ adpatch options=nocopyportion,nogenerateportion
* In between the merged patch we have applied the patch 21444745.
Upgrading from R12.1.x to R12.2.
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