FS_JGEN Sets Journal Date Different On VCHR_ACCTG_LINE Than On JRNL_HEADER / JRNL_LN When Period Is Closed By Ledger Code

(Doc ID 2352807.1)

Last updated on MARCH 05, 2018

Applies to:

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

Goal

FS_JGEN sets a different Journal Date on VCHR_ACCTG_LINE than on JRNL_HEADER / JRNL_LN when period is closed by Ledger Code. The site's Journal Generator Template is configured with:

- Journal Date set to "Accounting Date on Transaction”
- Alt Journal Date set to “Begin Date – To Period”

The Journal Source 'AP', Journal Options tab, has Journal Date < Open From Date set to 'Change to Open From Date'. And the site is using the option to open and close periods by Ledger Code.

Plus the site has Book Code turned on. When FS_ JGEN processes VCHR_ACCTG_LINE rows with an Accounting Date in a closed period, the journals will be created successfully on the first day of the next open period.

For example, if September is closed and FS_JGEN processes VCHR_ACCTG_LINE rows with an Accounting Date of 09/17/2017, the JRNL_HEADER and JRNL_LN rows get created with a Journal Date of 10/01/2017. However, FS_JGEN sets the Journal Date on the VCHR_ACCTG_LINE rows to the to Accounting Date of 09/17/2017.

Thus:

VCHR_ACCTG_LINE gets Journal Date 09/17/2017

JRNL_HEADER and JRNL_LN get Journal Date 10/01/2017

 

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