My Oracle Support Banner

When running script MSDODPCODE.sql error ORA-37002 occurs (Doc ID 467879.1)

Last updated on FEBRUARY 03, 2019

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
technical support.
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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.