u6678700.drv: FAILED: file zpbremcwm.sql

Action plan to avoid zpbremcwm.sql job issue:

Issue:

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:

The APPS user does not have execute privileges on the olapsys objects mentioned in the error message.


Solution:

The APPS user does not have execute privileges on the olapsys objects mentioned in the error message.

SQL> grant execute on OLAPSYS.CWM2_OLAP_METADATA_REFRESH to apps;
SQL> grant execute on OLAPSYS.CWM2_OLAP_CATALOG to apps;
SQL> grant execute on OLAPSYS.CWM2_OLAP_DIMENSION to apps;
SQL> grant execute on OLAPSYS.CWM2_OLAP_CUBE to apps;

Reference:

ZPBREMCWM.SQL Returns Error: PLS-00904: Insufficient Privilege To Access Object [ID 744973.1]

Restart the failed Worker using the adctrl utility in a second Shell session and continue.