My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.