SSO with Specified Partner Application Name Fails with PLS-00201 in APEX 4.x

(Doc ID 1442777.1)

Last updated on NOVEMBER 14, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.0 and later
Information in this document applies to any platform.
Checked for relevance on 17-Oct-2013

Symptoms


When running with APEX 4.x, attempting to use an application with SSO authentication the following error occurs.


"ORA-06550: line 2, column 1: PLS-00201: identifier 'WWSEC_SSO_ENABLER_PRIVATE.GENERATE_REDIRECT' must be declared ORA-06550: line 1, column 45: PL/SQL: Statement ignored"


The problem can be reproduced regardless of whether the instance is a new install of APEX 4.x or if it is an upgrade from a previous version: for example. APEX 3.2.1.


SSO was configured according to the instructions in Note 562807.1. There were no errors in the configuration.




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