EGL 8.8+: Journal Generator Abends at Step FS_JGEN_OUTJ.JrnlLine.iJrnlLn with Unique Constraint on Table PS_JRNL_LN

(Doc ID 653828.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.8 to 9 [Release 8.8 to 9]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201038068


****Checked for Relevance on 08-OCT-2012****
****Checked for Relevance on 06-OCT-2015****

Symptoms

Journal Generator failed with a duplicate key error trying to insert in PS_JRNL_LN:

ERROR:
-------------
-- 05.30.46 Process 1176347 ABENDED at Step FS_JGEN_OUTJ.JrnlLine.iJrnlLn (Action SQL) -- RC = 805
ROLLBACK
/
-- 05.30.47 SQL Error: ORA-00001: unique constraint (SYSADM.PS_JRNL_LN) violated

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