My Oracle Support Banner

EGL 9.2 GLPCLOSE Year End Close Program Run To Error: SEVERE ERROR IN PGM:(5820,6) PI(10054321) Program(GLPCOUTJ) SQLRT error in GLPCOUTJ - LD000 FETCH (Doc ID 2169939.1)

Last updated on APRIL 02, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms



GLPCLOSE Year end close program run to error during upgrade to tools 8.55 and PI 18 environment


ERROR
-----------------------
 Error Message : SQLRT: Buffer for field too small for fetched data
  at pos 00021

SEVERE ERROR IN PGM:(5820,6) PI(1234567) Program(GLPCOUTJ)
SQLRT error in GLPCOUTJ - LD000 FETCH.

OR

Application Program Failed
Action Type     : SQL FETCH                    
In Pgm Section  : SQLRT: DA000-FETCH                                                                                                                                          
With Return Code: 09980


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1.  Upgrade PeopleTools to 8.55
  2.  Run GLPCLOSE




Changes

 

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.