EGL9.2: Journal Generator(FS_JGEN) Abeneded At Step FS_JGEN_OUTJ.JrnlLine.iJrnlLn For Vouchers With Same ChartField But Different Accounting Date (Doc ID 1906879.1)

Last updated on MARCH 14, 2017

Applies to:

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

Symptoms

Issue:
--------

FS_JGEN is abeneded at Step FS_JGEN_OUTJ.JrnlLine.iJrnlLn with unique constraint error, when Vouchers are created with same chartfields but different accounting dates.


Error:
------

Process 20425 ABENDED at Step FS_JGEN_OUTJ.JrnlLine.iJrnlLn (SQL) -- RC = 805 (108,524)

Steps to replicate:
---------------------

1. Hide SalesTax option in Payables definition
2. Create 2 voucher with different Accounting Date
3. Run the Voucher post
3. Add a new ledger CORPORATE to the ledger group RECORDINGS and make the changes as shown below
4. In Journal Generator template,(Default tab) Change the Journal date option as 'Current Date' and Alt Journal date as 'Retain Primary Journal Date'
5. In Summarization tab, Select "Summarize to All Chartfields" / "Select Account Value" / "Retain Details"
6. Run Journal Generator.

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