EGL: Journal Generator Abended at Step GL_JP_POST.Process.uPer3 (SQL) (Doc ID 1590691.1)

Last updated on SEPTEMBER 14, 2016

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.

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