My Oracle Support Banner

R12.2 Upgrade Driver Failed On wmsoqbkp.sql - ORA-00942 on MTL_ONHAND_QUANTITIES_D_BKP and MTL_ONHAND_DISCREPANCIES (Doc ID 1665950.1)

Last updated on OCTOBER 21, 2016

Applies to:

Oracle Warehouse Management - Version 12.2.3 and later
Information in this document applies to any platform.
*** Checked for relevance on 25-SEP-2015 ***

Symptoms

As part of 12.2.3 upgrade, while applying the 12.2 upgrade driver, patch session failed while running wmsoqbkp.sql:

sqlplus -s APPS/***** @/ohrdshr/appohrtest/122/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/ohrdshr/appohrtest/122/fs1/EBSapps/appl/wms/12.0.0/patch/115/sql/wmsoqbkp.sql &un_inv &pw_inv &un_apps &pw_apps'
Connected.

PL/SQL procedure successfully completed.

Connected.
DROP TABLE MTL_ONHAND_QUANTITIES_D_BKP
  *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP TABLE MTL_ONHAND_DISCREPANCIES
  *
ERROR at line 1:
ORA-00942: table or view does not exist


Connected.
DECLARE
*
ERROR at line 1:
ORA-20000: Call to GET_APP_INFO_OTHER() failed: USER=APPS, Status=N,
Industry=N, Schema=, STMT=declare x boolean; begin x :=
APPS.fnd_installation.get_app_info_other('INV', 'APPS', :status, :industry,
:oracle_schema); if x = TRUE then :dummy_boolean := 'TRUE'; elsif x = FALSE
then :dummy_boolean := 'FALSE'; else :dummy_boolean := null; end if; end;
ORA-06512: at "SYSTEM.AD_DDL", line 188
ORA-06512: at line 34

 

Changes

 

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.