E-ORA: Why does the pscbo_stats package body become invalid?

(Doc ID 1421373.1)

Last updated on AUGUST 07, 2013

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.
Any process that that needs statistics generation for an Oracle DB during the processing steps, will call the PSCBO_STATS, IF the package has been installed instead of the standard DBMS_STATS package. if the PSCBO_STATS package is invalid it will make the parent process fail.

***Checked for relevance on 07-Aug-2013***


If you are running a process that calls PSCBO_STATS and if this package is invalid, it will not only throw an error for the PSCBO_STATS package but will also make the parent process abend.
Say you are running a TL Admin process that calls the PSCBO_STATS package:
02.23.37 Process 32042 ABENDED at Step TL_TA000200.GETTR.STATS1 (Action SQL) -- RC = 4063
-- 02.23.37 SQL Error: ORA-04063: package body "SYSADM.PSCBO_STATS" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYSADM.PSCBO_STATS" ORA-06512: at line 1
As seen from the above symptoms, not only does the PSCBO_STATS fail but also the parent process TL Admin fails.




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