EGL9.2: Journal Generator Abended at Step GL_JP_POST.Process.uPer3 (SQL)
(Doc ID 1590691.1)
Last updated on APRIL 17, 2025
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/Errors
-----------------------
Journal Generator (FS_JGEN) when run with Edit/Post selected goes to 'No Success' with the following error:
UPDATE PS_LEDGER_TMP2 SET post_dc_flag = 'Y'
WHERE (1000 * FISCAL_YEAR + ACCOUNTING_PERIOD )<> (1000 * FISCAL_YEAR2 + ACCOUNTING_PERIOD2) AND DATE_CODE = 0
/
-- Row(s) affected: 0
-- 19.28.45 Process 2032225 ABENDED at Step GL_JP_POST.Process.uPer3 (Action SQL) -- RC = 904
ROLLBACK
/
-- 19.28.45 SQL Error: ORA-00904: "POST_DC_FLAG": invalid identifier
Steps/Sequence of Events
---------------------------------------------
1. After upgrading to FSCM 9.2 run Journal Generator with Edit/Post selected in the run control.
2. Process fails with error.
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 |