EGL9.2: Year End Close Process(GLPCLOSE) Fails With SQLRT Error In IA000-INSERT CLOSE STATUS

Last updated on JUNE 07, 2018

Applies to:

Symptoms

Issue:
-------

Getting below error when running GLPCLOSE on environment with fixes from any Image including Image 13 and higher.

Steps to Replicate:
---------------------
1. Apply fixes from any image including Image 13 and higher.
2. Run GLPCLOSE 

Error:
-------

> 2017-02-27-08.35.16.900000 INFO(5820,3) PI(7077229) Program(GLPCPROC)
Processing business unit ARCTC, Closing rule ARCTC_CLOSE.

Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 08006
Error Message : Invalid datatype specified
Stored Stmt : GLPCSTAT_I_STATUS
SQL Statement : INSERT INTO PS_CLOSE_STAT_TBL (FISCAL_YEAR ,LEDGER_GROUP ,LEDGER ,BUSINESS_UNIT ,SETID ,CLOSING_SET ,CLOSE_GRP_ID ,CLOSE_STEP ,EFFDT ,BEGIN_DT ,END_DT ,DTTM_STAMP ,SCE_ID ,AS_OF_DATE ,PROCESS_INSTANCE ,REQUEST_NBR ,CLOSING_TYPE ,CLOSING_SCOPE ,OPRID ,RUN_CNTL_ID ,UNCLOSED ,UNDO_PREV_PROCESS ) VALUES
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22)?

> 2017-02-27-08.35.23.470000 SEVERE ERROR IN PGM:(5820,6) PI(7077229) Program(GLPCSTAT)
SQLRT error in IA000-INSERT CLOSE STATUS.

Changes

Cause