My Oracle Support Banner

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 OCTOBER 21, 2019

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 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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.