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


Symptoms

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
begin
*
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

Cause

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