EGL: Ability for Journal Generator to Create Separate Journal Based on Journal Line Ref Value. (Doc ID 2080179.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.

Goal

Is there a way to create journals according to Journal Line reference using Journal generator (FS_JGEN)?  Have an custom accounting line table with properly mapped accounting entry definition and journal template. The accounting line table has multiple entries with different journal line reference but same accounting date. When Journal generator runs, the process clubs all the entries according to accounting date and creates one journal Id.  Business wants to create separate journals for each journal line reference (it is ok even if they are separated by accounting date).

Example:

Run date       Accounting Date    Jrnl Ln Ref        Amount     Current journal Id      Expected Journal Id
------------    --------------------    --------------   ----------- ------------------------ ------------------------
11/03/2015    11/01/2015                LN1            $1000                JID01                 JID01
11/03/2015    11/01/2015                LN2            $500                  JID01                JID02
11/03/2015    11/01/2015                LN3            $250                  JID01                JID03
11/03/2015    11/03/2015                LN1            $750                  JID02                JID04

How can I configure this, either in accounting entry definition or journal template?
 

Solution

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