EGL9.2: Journal Line Number in Subsystem and JRNL_LN Table does not Match After Journal Generator (FS_JGEN) Also Multiple Lines for the Same ChartField Combination are Created Which can Lead to Journal Balancing Error
Last updated on DECEMBER 21, 2017
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.
**Checked for currency 21-Dec-2017***
On : 9.2 version, Journal Generator
1. Journal line number on VCHR_ACCTG_LN and resulting JRNL_LN does not match
2. Multiple Lines for the Same ChartField Combination are Created
3. Edit Error: "Journal is not balanced on journal totals or balancing Chartfield totals"
The issue can be reproduced at will with the following steps:
1. Create and post vouchers with the same chartfields but different accounting dates.
2. Run the Journal generator FS_JGEN process.
3. JRNL_LN showing 9 lines for 118 voucher lines.
4. VCHR_ACCTG_LN showing the journal line number as 1 for the 118 lines while journal line numbers are updated from 1-9
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