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.

Symptoms

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

ERROR
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

STEPS
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.

Changes

Upgrading from R12.1.x to R12.2.

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


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