EGL9.2: Year End Close Process(GLPCLOSE) Fails With 'A numeric string contains non-numeric data' Error at Dynamic Statement Step GLPCOUTJ - NA000 INSERT

(Doc ID 2070843.1)

Last updated on JUNE 07, 2018

Applies to:

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

Symptoms

Issue:
-------

Year end close process (GLPCLOSE cobol) failed with SQLRT error in GLPCOUTJ - NA000 INSERT.


Error:
-------

Application Program Failed
Action Type     : SQL UPDATE                    
In Pgm Section  : SQLRT: EXECUTE-STMT                                                                                                                                        
With Return Code: 09003
Error Message   : A numeric string contains non-numeric data
Dynamic Stmt    : DYNAMIC                                              
SQL Statement   : INSERT INTO PS_JRNL_HEADER
(BUSINESS_UNIT,JOURNAL_ID,JOURNAL                                                                                                                        
                   _DATE,
                   UNPOST_SEQ,LEDGER,GL_ADJUST_TYPE,CURRENCY_CD,FOREIGN_C 
> 2015-10-23-06.10.04.650000 SEVERE ERROR IN PGM:(5820,6) PI(223582) Program(GLPCOUTJ)                                                                                                                                                                                                                      
SQLRT error in GLPCOUTJ - NA000 INSERT.                                    

Changes

Issue appears after applying a new PUM image.

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