EGL9.2: GLPCLOSE Failing With SQLRT Error In IA000-INSERT CLOSE STATUS (Doc ID 2221595.1)

Last updated on JULY 07, 2017

Applies to:

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

Symptoms

Getting below error when running GLPCLOSE on environment with fixes from any Image including Image 13 and higher.
 
> 2017-02-27-08.35.16.080000 INFO(5820,4) PI(7077229) Program(GLPCLOSE)
Processing requests started.
> 2017-02-27-08.35.16.100000 INFO(5820,1) PI(7077229) Program(GLPCLOSE)
Closing for fiscal year 2016, ledger ACTUAL, closing group ARCTC_CLOSE started.
> 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 ,LE
DGER ,BUSINESS_UNIT ,SETID ,CLOSING_SET ,CLOSE_GRP_ID ,CLOSE
_STEP ,EFFDT ,BEGIN_DT ,END_DT ,DTTM_STAMP ,SCE_ID ,AS_OF_DA
TE ,PROCESS_INSTANCE ,REQUEST_NBR ,CLOSING_TYPE ,CLOSING_SCO
PE ,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.

 

ENVIRONMENT
---------------
Tools Version: 8.54
Application & Version: PeopleSoft FSCM 9.2 Image 13 and higher
System Name: Production

STEPS
---------------
The issue can be reproduced with the following steps:
1. Apply fixes from any image including Image 13 and higher.
2. Run GLPCLOSE


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