ORA-37002: Oracle OLAP failed to initialize while applying patch 6678700 (Doc ID 1314218.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demand Planning - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Mar-2014***

Symptoms

Oracle E-Business Suite (EBS) 12.1.1 version, AUTO UPGRADE ISSUES

Applying patch 6678700 errors out on below files, attached are worker logfile
***************
FAILED: file zpbcd_source_p.sql on worker 1.
FAILED: file zpbcd_member_p.sql on worker 2.
FAILED: file zpbcd_obj_prop.sql on worker 3.
FAILED: file zpbcd_params.sql on worker 4.
***************************

All of those fail with the same error:

ERROR

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 93
ORA-06512: at "SYS.DBMS_AW", line 122
ORA-06512: at "APPS.ZPB_AW_LOADER_PVT", line 66
ORA-06512: at line 4

 

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