EGL9.2: Journal Edit Encountered "Cannot insert duplicate key row in object 'dbo.PS_JRNL_CF_BAL_TBL' with unique index 'PS_JRNL_CF_BAL_TBL'. The duplicate key value is (<NULL>)" (Doc ID 1672536.1)

Last updated on JANUARY 05, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Microsoft SQLServer - Version 2005 to 2014
Information in this document applies to any platform.

***Checked for relevance on 23-OCT-2015***


Symptoms

Issue:
-------

When editing a journal with no lines to the anchor/header business unit through online or batch journal edit - on a SQL Server (MSS) database, the following error occurs.

Error:
---------
Online Journal Edit -
Process ##### abended at step GL_JEHDR.PutCFBal.InsNonTL (SQL) -- RC = 805 (108,524)

Batch Journal Edit -
Stmt #: 1623 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key r ow in object 'dbo.PS_JRNL_CF_BAL_TBL' with unique index 'PS_JRNL_CF_BAL_TBL'. The duplicate key value is ().

or,

Stmt #: 1723 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_JRNL_CF_BAL_TBL' with unique index 'PS_JRNL_CF_BAL_TBL'. The duplicate key value is (<NULL>).

Steps to Replicate:
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter a journal with no lines to the anchor/header bu
2. Run journal edit from either online page or batch run control

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