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

(Doc ID 1421373.1)

Last updated on MARCH 06, 2018

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.



Symptoms

Note:
Oracle does not certify or test the pscbo_stats utility for support purposes. Its use is considered to be a customization.
If there is a problem or question with pscbo_stats, the Global Support Center will not be handling service requests regarding its use.
The best approach would be to post to the Lifecycle Management PSFT Community, reaching out to other customers for information and assistance.

 

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.
Example:
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
ROLLBACK
/
-- 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.

Changes

None

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