PLS-00904: Insufficient Privilege To Access Object APEX_APPLICATION_PAGE_REGIONS (Doc ID 2252216.1)

Last updated on APRIL 11, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.0 to 5.1 [Release 4 to 5]
Information in this document applies to any platform.

Symptoms

When attempting to access URL: http://<host_name>:port/ords/f?p=<appid>
the following error occurs:

Error in PLSQL code raised during plug-in processing.

ORA-06550: line 11, column 37: PLS-00904: insufficient privilege to access object APEX_0X0X00.APEX_APPLICATION_PAGE_REGIONS ORA-06550: line 11, column 28: PL/SQL: Item ignored ORA-06550: line 20, column 37: PLS-00904: insufficient privilege to access object APEX_0X0X00.APEX_APPLICATION_PAGE_REGIONS ORA-06550: line 20, column 28: PL/SQL: Item ignored ORA-06550: line 21, column 37: PLS-00904: insufficient privilege to access object APEX_0X0X00.APEX_APPLICATION_PAGE_REGIONS ORA-06550: line 21, column 28: PL/SQL

 

STEPS
-----------------------
1. Enter in a Browser the apex url to execute a particular application
2. Get the errors instead of the page expected

Changes

Cloned the database with APEX including using the datafiles.

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