EGL 9.2: Batch Edit and Post Failing With SQL errors: 1) ORA-00001: unique constraint (ASRPRD92.PS_JRNL_CF_BAL_TBL) violated. 2) 904 - ORA-00904: "POST_DC_FLAG": invalid identifier. (Doc ID 1920604.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

Journal Edit and Post is failing with errors.

ERROR
-----------------------
Journal Post is failing with: SQL error. Stmt #: 1625 Error Position: 26 Return: 904 - ORA-00904: "POST_DC_FLAG": invalid identifier
Failed SQL stmt: UPDATE PS_LEDGER_TMP2 SET post_dc_flag = 'Y' WHERE (1000 * FISCAL_YEAR + ACCOUNTING_PERIOD )<> (1000 * FISCAL_YEAR2 + ACCOUNTING_PERIOD2) AN
D DATE_CODE = '0'


and

Journal Edit is failing with: SQL Error: ORA-00001: unique constraint (ASRPRD92.PS_JRNL_CF_BAL_TBL) violated
2014-08-13-15.28.54.716056 CommonMain [1625] Exception logged: RC=8.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Journal Edit.
2. Run Edit
3. Run Post

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