Jmfgtado.sql Is Failing While R12.1.3 Upgrade 9239090 Patch Running On VISION Instance (Doc ID 1630175.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Outsourced Mfg for Discrete Industries - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

sqlplus -s APPS/***** @/opt/oracle/VIS/apps/apps_st/appl/jmf/12.0.0/patch/115/sql/jmfgtado.sql &batchsize
Connected.
DECLARE
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
ORA-06512: at line 44


This error is due to script is checking for SYNONYMS in "%APPS" schemas in script jmfgtado.sql
becasue the JMF_GTA% synonyms exists in MSCAPPS schema
 

Solution

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