EGL9.2: FS_JGEN does not use “Alt Journal Date” When Creating Journal if the GL Period Is Partially Closed By Ledger Code. (Doc ID 2048835.1)

Last updated on SEPTEMBER 01, 2015

Applies to:

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

Symptoms

On : 9.2 version, Journal Generator

ACTUAL BEHAVIOR
---------------
The site's Journal Generator Template is configured with “Begin Date – From Period” for the field *Alt Journal Date" and “Accounting Date on Transaction” for *Journal Date field. The site is using the option to close periods by ledger code.

When FS_ JGEN is run on a closed period, the journals will be created successfully on the first day of the next open period. Ex: If April is closed, and FS_JGEN is run for a voucher with accounting date on April, the journal will be created on 05/01/2015. This works perfectly when the full period is closed for all ledger codes.

However, if the period is closed partially (only for some ledger codes), the system does not work as expected. The journal is created in the closed period for the ledger code and goes into error status.

EXPECTED BEHAVIOR
-----------------------
Since the period for ledger code CASH is closed, it is expected that the system must created a journal with 05/01 date and validate it successfully.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1- Check to make sure that Alt Journal date is set to “Begin Date – Form Period”
2- Ledger Code CASH is configured and linked to CASH book code.
3- The period is partially closed. The period for ledger code CASH only is closed for April. The period for other ledger code is still open for April.
4- Create a voucher in the month of April.
5- Run Journal Generator (FS_JGEN). Note that journal is created in April for ledger code CASH and has journal edit error “The journal date is not in an open period for this ledger.”

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