EGL9.2: Year End Close Process(GLPCLOSE) Fails With " 'Column Not Found'/ 'ORA-00904: "C"."PROCESS_INSTANCE": invalid identifier" Error
(Doc ID 2322828.1)
Last updated on FEBRUARY 29, 2024
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
*** Checked for currency on 26-Feb-2024 ***
Symptoms
Issue:
-------
While running year end closing process using GLPCLOSE cobol encountered an error.
Error:
------
Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 08010
Error Message : Column not found
Dynamic Stmt : GLPCFWDB_I_FWDBLED
or,
Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 00904
Error Message : ORA-00904: "C"."PROCESS_INSTANCE": invalid identifier
Dynamic Stmt : GLPCFWDB_I_FWDBLED
Steps to Replicate:
---------------------
1. Set up closing rules & process groups
2. Run year end closing by using GLPCLOSE process
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 |
Cause |
Solution |
References |