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


Symptoms


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

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."

EXPECTED RESULTS
-----------------------
Journal Edit run to success without error.

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

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

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