When running script MSDODPCODE.sql error ORA-37002 occurs
(Doc ID 467879.1)
Last updated on FEBRUARY 12, 2016
Applies to:Oracle Applications DBA - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Application Install - Version: 12.0.0 to 12.0.1
During upgrade to R12, by applying <Patch 5082400> , the script MSDODPCODE.sql fails and the following error occurs :
sqlplus -s APPS/***** @/apps/dmxsj/apps/apps_st/appl/msd/12.0.0/patch/115/sql/MSDODPCODE.sql
ERROR at line 1:
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP
ORA-33262: Analytic workspace EXPRESS does not exist.
ORA-06512: at "SYS.DBMS_AW", line 67
ORA-06512: at "SYS.DBMS_AW", line 131
ORA-06512: at "SYS.DBMS_AW", line 787
ORA-06512: at "SYS.DBMS_AW", line 762
ORA-06512: at "APPS.MSD_AW_LOADER", line 10
ORA-06512: at line 3
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!