EGL9.2: Year End Close Process(GLPCLOSE) Fails With SQLRT Error In IA000-INSERT CLOSE STATUS
(Doc ID 2221595.1)
Last updated on DECEMBER 03, 2019
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |