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 laterInformation 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
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 |