ORA-27486, ORA-06512 Running Materialized View Program for CPMI

(Doc ID 578454.1)

Last updated on MAY 03, 2017

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 to 12.0.0 [Release 11.5 to 12]
Information in this document applies to any platform.
Corporate Performance Management Intelligence (CPMI)
Reporting

Symptoms

When attempting to run Refresh Materialized Views concurrent program, the following error message occurs.

ERROR
FEM_REFRESH_MV module: Program - Refresh Materialized Views

ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 265
ORA-06512: at "SYS.DBMS_SCHEDULER", line 731
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 1853
ORA-27486: insufficient privileges in Package FEM_MV_Refresh_Pvt Procedure Refresh_MV
User-Defined Exception in Package FEM_MV_Refresh_Pvt Procedure Refresh_MV_CP

Steps to reproduce:
1. Submit Program -Refresh Materialized Views request as the Corporate Performance Management Intelligence responsibility.
2. Error message appears as shown above and a red X.

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