R12.2 Upgrade Driver Fails On GMEAMED.sql Error: PLS-00201: identifier 'AME_TRANS_TYPE_API.DELETE_AME_TRANSACTION_TYPE' must be declared (Doc ID 1585036.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.1 version, Installation Issues
When attempting to upgrade to 12.2 the following error occurs:

adworker log:
sqlplus -s APPS/***** @/d010/appltest/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/d010/appltest/fs1/EBSapps/appl/gme/12.0.0/patch/115/sql/gmeamedl.sql '
Connected.

PL/SQL procedure successfully completed.

from ame_calling_apps_vl
*
ERROR at line 17:
ORA-06550: line 17, column 10:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 15, column 3:
PL/SQL: SQL Statement ignored
ORA-06550: line 57, column 3:
PLS-00201: identifier 'AME_TRANS_TYPE_API.DELETE_AME_TRANSACTION_TYPE' must be
declared
ORA-06550: line 57, column 3:
PL/SQL: Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade to 12.2



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