My Oracle Support Banner

EGL9.2: Journal Post or Closing (GL_YC) ABENDED at Step GL_JP_POST.ProcLedg.hRetCode With SQL Error 805 occurred at GL_JP_POST.ProcLedg.Upsert (Doc ID 2133137.1)

Last updated on FEBRUARY 27, 2023

Applies to:

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


When running journal post process, for journals coming from different sources like third party applications, sub-systems Peoplesoft , Spreadsheet Journal or Online journals, the process goes to error even after passing editing and the journal is in Valid status.

Issue also occur with year end close GL_YC process which invokes journal posting.

SQL Error 805 occurred at GL_JP_POST.ProcLedg.Upsert (ignoring)
(GL_JP_POST.ProcLedg.hRetCode) (Call Section GL_JP_POST.hRetCode)
Process xxxxx  ABENDED at Step GL_JP_POST.ProcLedg.hRetCode (Action Call Section) -- RC = 805

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

1. Configure a custom Journal Generator/ create an online journal entry
2. Run journal generator/ save the journal
3. Edit the journal
4. Post the journal




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

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