EGL: GL_JEDIT_0 ABENDED at Step IU_PROCESSOR.A007.A007-010 (SQL) With "Numeric Value Out Of Range" Error on SELECT COUNT Statement Against A Temp Table.

(Doc ID 981329.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.8 SP1 to 9.1 [Release 8.8 to 9]
Information in this document applies to any platform.
****Checked for Currency on Jun-6-2010****
****Checked for Currency on Nov-19-2012****


When attempting to run online Journal Edit (GL_JEDIT_0), the process abend at Step IU_PROCESSOR.A007.A007-010 with following error:

"SQL error. Stmt #: 1603 Error Position: 0 Return: 8601 - [Microsoft][SQL Native Client]Numeric value out of range (SQLSTATE 22003) 0"

"A SQL error occured. Please consult your system log for details."

"Process 2123885 ABENDED at step IU_PROCESSOR.A007.A007-010 (SQL) -- RC = 8601 (108, 254)."

"CallAppEngine: Application GL_JEDIT_0: AppEngine error. (2,653) JRNL_PANELS_WRK.PB_EDIT.FieldChange Name: edit_jrnl PCPC:5455 Statement:74
Called from JRNL_PANELS_WRK.PB_EDIT.FieldChange name: pb_edit_fc Statement:117
Called from JRNL_PANELS_WRK.PB_PROCESS.FieldChange Statement:15

During a CallAppEngine bultin function call, the Application Engine detected an error. The Application Engine log may provide more information."

Journal Edit run to success without error.

The issue can be reproduced at will with the following steps:
1. Import a journal from flat file or enter a journal online.
2. Run online journal edit via Journal Line page (General Ledger > Journals > Journal Entry).
3. Error returns.

The issue has the following business impact:
Due to this issue, users cannot edit journal and therefore post journal to update ledger balance.


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