EGL9.2: Batch Journal Edit and Post Failing With 'ORA-00001: unique constraint (xxxxx.PS_JRNL_CF_BAL_TBL) violated' And 'ORA-00904: "POST_DC_FLAG": invalid identifier' Error
(Doc ID 1920604.1)
Last updated on APRIL 16, 2021
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Journal Post is failing with:
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) AND DATE_CODE = '0'
Journal Edit is failing with:
ORA-00001: unique constraint (xxxxx.PS_JRNL_CF_BAL_TBL) violated
Steps to Replicate:
1. Create few Journals.
2. Run Edit in batch
3. Run Post in batch
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