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 APRIL 16, 2021
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