EGL: Edit Fails With "Cannot insert duplicate key row in object PS_JRNL_CF_BAL_TBL with unique index PS_JRNL_CF_BAL_TBL. The duplicate key value is ()" Because Settlement_DT on Accounting Entry Definition Mapped To NULL. (Doc ID 1584853.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.
****Checked for Currency on 20-Feb-2015****

Symptoms

When attempting to run journal edit for journals coming from sub system i.e. accounts payable
the following error occurs.

ERROR
-----------------------
Cannot insert duplicate key row in object PS_JRNL_CF_BAL_TBL with unique index PS_JRNL_CF_BAL_TBL. The duplicate key value is ().


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a voucher, post it.
2. Run journal generator.
3. Edit it.

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