ORA-00942: table or view does not exist - Apex Shared Components - Authentication Schemes (Doc ID 2156487.1)

Last updated on JULY 05, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.0.0.00.06 and later
Information in this document applies to any platform.

Symptoms

Problem :
========
1 - Log in to developer environment.
2 - Choose any application.
3 - Shared components page.
4 - Then select Authentication Schemes.
5 - Page is with list of authentication schemes.
6 - Chose one of them to get a detail information and end up with following error.

Error :
=======
Error during rendering of page item P4495_RAS_NAMESPACES (example).
ORA-06550: line 1, column 119: PL/SQL: ORA-00942: table or view does not exist ORA-00942: table or view does not exist ORA-06550: line 1, column 13: PL/SQL: SQL Statement ignored ORA-00942: table or view does not exist

Changes

 Apex was upgraded to Apex 5 and the Database was upgraded to 12c.

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