Discoverer 11g Returns Error WWSSO_UTL error ORA-06508: PL/SQL: could not find program unit being called (Doc ID 1547045.1)

Last updated on MAY 14, 2014

Applies to:

Oracle Discoverer - Version 11.1.1.3.0 to 11.1.1.6.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

When attempting to launch Discoverer Viewer/Plus or save a connection one of the following messages is encountered:

The connection list is currently unavailable.
- ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "DEV_DISCOVERER_PS.WWSSO_API_PRIVATE", line 293 ORA-04063: package body "DEV_DISCOVERER_PS.WWSSO_UTL" has errors ORA-06508: PL/SQL: could not find program unit being called: "DEV_DISCOVERER_PS.WWSSO_UTL" ORA-06512: at line 1
unable to retrieve connection list
- The connection list is currently unavailable.
Oracle BI Discoverer Viewer was unable to save the connection. Please check for other errors.
- ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "DEV_DISCOVERER_PS.WWSSO_API_PRIVATE", line 279 ORA-04063: package body
"DEV_DISCOVERER_PS. WWSSO_UTL” has errors ORA-06508: PL/SQL: could not find program unit being called: "DEV_DISCOVERER_PS. WWSSO_UTL” ORA-06512: at line 1

Changes

 The Discoverer RCU schema were exported and then imported using the database data pump utility.

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