E-ORA "SYS.DBMS_STATS" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS" (Doc ID 1477700.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 and later
Information in this document applies to any platform.
*****Reviewed for currency 02-Jan-2014*****

Goal

 

Attempting to apply the MP9 to PeopleSoft FSCM 9.1: Feature Pack 2 using PeopleTools 8.52.06, using Change Assistant, but receiving the error message as follows:

 

ORA-04063: package body "SYS.DBMS_STATS" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"

 

Oracle release in use is  11gR2 0.3.0

 (from log file) 

Indexing export file D:\temp\staging\softwareupdateFSCM910_MP9{cc0e2238-7c37-11e1-b695-9c2749b5d967}\SCRIPTS\MAINT\UPD860191_SYSDATA.dat
Input file: D:\temp\staging\softwareupdateFSCM910_MP9{cc0e2238-7c37-11e1-b695-9c2749b5d967}\SCRIPTS\MAINT\UPD860191_SYSDATA.dat (ENG)
Commit done at end of record
Importing PTLT_ASSGN_FEAT
Import PTLT_ASSGN_FEAT 4
Message Set Number: 200
Message Number: 0
Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 4063 - ORA-04063: package body "SYS.DBMS_STATS" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS" ORA-06512: at line 1
Failed SQL stmt:RECSTATS PS_PTLT_ASSGN_FEAT LOW (200,0)
SQL Error. Error Position: 0 Return: 4063 - ORA-04063: package body "SYS.DBMS_STATS" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS" ORA-06512: at line 1
RECSTATS PS_PTLT_ASSGN_FEAT LOW
Error: SQL execute error for %UpdateStats(PS_PTLT_ASSGN_FEAT)
Error: Import Record name PTLT_ASSGN_FEAT
Ended: Tue Apr 17 05:48:36 2012
Unsuccessful completion

Solution

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