My Oracle Support Banner

EGL9.2: Journal Generator(FS_JGEN) Process Abended at Step FS_JGEN_OUTJ.JrnlLine.iJrnlLn With 'ORA-00001: unique constraint' Error (Doc ID 2489637.1)

Last updated on MAY 27, 2020

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 generator process fails(when below conditions in replication section are true) at step FS_JGEN_OUTJ.JrnlLine.iJrnlLn with unique constraint error even if there is no duplication in data.

Steps to Replicate:

1. In Ledger group set up make sure to have a translation ledger
2. In Journal generator template 'Accounting entry in-sync' is selected in defaults tab & make sure that subsystem sends in-sync data for all ledgers in ledger group
3. Summarization option selected as 'Summarization by All Chartfields' [or 'Summarization by Selected Chartfields']
4. Any one of the PeopleSoft delivered expansion chartfields i.e. CHARTFIELD1, CHARTFIELD2, CHARTFIELD3 is active. Or, any custom chartfields have been activated. Relevant manual steps as listed by Chartfield configuration has been followed.

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.