My Oracle Support Banner

E-ORA:ORA-20001: Invalid input values for pname ORA-06512: at "SYS.DBMS_STATS", line 23484 ORA-06512 (Doc ID 1530424.1)

Last updated on APRIL 04, 2025

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 to 8.52 [Release 8.4]
Information in this document applies to any platform.

Symptoms

 Peopletools  8.52.12   ,  ORACLE  11.2.0.2

 

While running App Engine job FS_JGEN, Journal Generator,  experienced the following  error:  

PeopleTools 8.52.12 - Application Engine
Copyright (c) 1988-2013 Oracle and/or its affiliates.
All Rights Reserved

Journal Generator processing has begun 2013-02-18-13.13.21.000000. (9100,1)

File: e:\pt85212c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1620  Error Position: 0  Return: 20001 - ORA-20001: Invalid input values for pname ORA-06512: at "SYS.DBMS_STATS", line 23484 ORA-06512: at "SYS.DBMS_STATS", line 23535 ORA-06512: at line 1
Failed SQL stmt:RECSTATS PS_JGEN_SEL_TAO4 LOW

Process 243076 ABENDED at Step FS_JGEN_PROC.SelAcctg.uStats (SQL) -- RC = 20001 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s


Changes

Oracle   RDBMS  Bundle Patch 20 has been applied

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.