My Oracle Support Banner

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

Last updated on MARCH 14, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
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 to configure this, either in accounting entry definition or journal template ?
 

Solution

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
Goal
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.