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

Last updated on MAY 02, 2016

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 PUM 17, People Tools 8.55.04, Journal Post

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.



ERROR
-----------------------
15:37:57.912 SQL Error 805 occurred at GL_JP_POST.ProcLedg.Upsert (ignoring)
-- 15:37:57.912 ........................................................................................................................................................................................................(GL_JP_POST.ProcLedg.hRetCode) (Call Section GL_JP_POST.hRetCode)
-- 15:37:57.965 Process 42352 ABENDED at Step GL_JP_POST.ProcLedg.hRetCode (Action Call Section) -- RC = 805
ROLLBACK


STEPS
-----------------------
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


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