My Oracle Support Banner

EGL9.2: Year End Close Process(GLPCLOSE) Fails With SQLRT Error In IA000-INSERT CLOSE STATUS (Doc ID 2221595.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:
-------

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

To view full details, 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 a vibrant support community of peers and Oracle experts.