Invalid PLSQL database packages under ORASSO schema database user ORA-04063: Package Body "Orasso.Wwsso_pstore_private" PL/SQL: ORA-00904

(Doc ID 371367.1)

Last updated on JUNE 26, 2017

Applies to:

Oracle Application Server Single Sign-On - Version 9.0.4 to 10.1.2.0.2 [Release 10gR1 to 10gR2]
Information in this document applies to any platform.
This problem can occur on any platform.
***Checked for relevance on 26-JUN-2017***


Symptoms

After updating SSO schema table which is not identified or known, some ORASSO packages became invalid.

When trying to validate the packages, you get the following:

ORA-04063: Package Body ''Orasso.Wwsso_pstore_private'' 

And, when trying to issue the following select statement, you see the following errors:

SQL> select text from dba_errors where name='WWSSO_PSTORE_PRIVATE';

TEXT
--------------------------------------------------------------------------------

PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "SSOA": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "SSOA": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "SSOA": invalid identifier
PL/SQL: SQL Statement ignored
PL/SQL: ORA-00904: "APPINFO": invalid identifier

8 rows selected.

Changes

Some update took place in SSO schema that is not known.  

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