EGL: What Can We Check To Resolve An Error: FS_JGEN ABENDED at Step FS_JGEN_OUTJ.JrnlLine.iJrnlLn (SQL) -- RC = 805 (108,524)? (Doc ID 1147094.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.8 SP1 and later
Information in this document applies to any platform.
Checked for relevance on 20-JAN-2015***

Symptoms

ISSUE
-----------------------
Journal Generator abended at step FS_JGEN_OUTJ.JrnlLine.iJrnlLn with duplicate insert error.


ERROR
-----------------------
SQL error. Stmt #: 1603 Error Position: 0 Return: 805 - [Microsoft][SQL Native Client][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_JRNL_LN' with unique index 'PS_JRNL_LN'.
INSERT INTO PS_JRNL_LN (<Field list>) SELECT <Field list> FROM PS_JGEN_WRK_TMP4 A WHERE A.PROCESS_INSTANCE = 14116714
Process 14116714 ABENDED at Step FS_JGEN_OUTJ.JrnlLine.iJrnlLn (SQL) -- RC = 805 (108,524)


SETUP
----------------------------
- Journal Generator Template has Accounting Entry Sync selected.
- Journal Generator Summarization option is set to Retain Detail.
- MultiBook Orderby ( on Accounting Entry Definition) has no field listed.
- Accounting Entry data has blank ledger group and ledger value.
- Journal Generator default ledger is multiple book ledger group with KLS on.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Journal Generation.
2. Process failed with above abend and duplicate insert error.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run journal generator for the entries from subsystems, like PO Receipts Accrual (RECV_LN_ACCTG) and Billing accounting entries (BI_ACCT_ENTRY)

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