ZPBREMCWM.SQL Returns Error: PLS-00904: Insufficient Privilege To Access Object (Doc ID 744973.1)

Last updated on DECEMBER 10, 2013

Applies to:

Oracle OLAP - Version 10.2.0.1 and later
Oracle Enterprise Planning and Budgeting - Version 11.5.9 to 12.0 [Release 11.5 to 12]
Information in this document applies to any platform.

Symptoms

R12 Upgrade (u6394500.drv) zpbremcwm.sql script fails with following errors:

sqlplus -s APPS/***** @/CRP/apps/apps_st/appl/zpb/12.0.0/patch/115/sql/zpbremcwm.sql
cwm2_olap_cube.drop_cube(G_SCHEMA, v_cube.name);
*
ERROR at line 235:
ORA-06550: line 235, column 6:
SQL>@ zpbremcwm.sql
cwm2_olap_cube.drop_cube(G_SCHEMA, v_cube.name);
*
ERROR at line 235:
ORA-06550: line 235, column 6:
PLS-00904: insufficient privilege to access object OLAPSYS.CWM2_OLAP_CUBE
ORA-06550: line 235, column 6:
PL/SQL: Statement ignored
ORA-06550: line 239, column 6:
PLS-00904: insufficient privilege to access object OLAPSYS.CWM2_OLAP_DIMENSION
ORA-06550: line 239, column 6:
PL/SQL: Statement ignored
ORA-06550: line 243, column 6:
PLS-00904: insufficient privilege to access object OLAPSYS.CWM2_OLAP_CATALOG
ORA-06550: line 243, column 6:
PL/SQL: Statement ignored
ORA-06550: line 247, column 4:
PLS-00904: insufficient privilege to access object
OLAPSYS.CWM2_OLAP_METADATA_REFRESH
ORA-06550: line 247, column 4:
PL/SQL: Statement ignored

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