R12.2 OPM Upgrade GMEMGCRI1.sql ORA-00942 CREATE index GME.PM_BTCH_HDR_BAK_MIG1 on GME.PM_BTCH_HDR_BAK ( BATCH_ID ) (Doc ID 2171599.1)

Last updated on AUGUST 11, 2016

Applies to:

Oracle Process Manufacturing Systems - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade from 12.1.3 to 12.2.5 English driver(u10124646.drv),
the following error occurs.

ERROR
sql /.../gme/12.0.0/patch/115/sql/GMEMGCRI1.sql &un_apps &pw_apps &un_gme &pw_gme &un_gmf &pw_gmf
Set the Module name & Client id successfully for file 'GMEMGCRI1.sql'
...
CREATE index GME.PM_BTCH_HDR_BAK_MIG1 on GME.PM_BTCH_HDR_BAK ( BATCH_ID )

AD Worker error:
The following ORACLE error:

ORA-00942: table or view does not exist


occurred while executing the SQL statement:

CREATE index GME.PM_BTCH_HDR_BAK_MIG1 on GME.PM_BTCH_HDR_BAK ( BATCH_ID )

Error occurred in file

/.../gme/12.0.0/patch/115/sql/GMEMGCRI1.sql

with arguments '&un_apps &pw_apps &un_gme &pw_gme &un_gmf &pw_gmf'.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms