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 JULY 13, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Ledgers

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

> 2016-07-29-16.04.24.850000 SEVERE ERROR IN PGM:(5820,6) PI(10054321) Program(GLPCOUTJ)
SQLRT error in GLPCOUTJ - LD000 FETCH.




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

  1.  Upgrade PeopleTools to 8.55
  2.  Run GLPCLOSE




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