E-ORA: Why does the pscbo_stats package body become invalid?
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.
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.
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
Million Knowledge Articles and hundreds of Community platforms