EGL: Roll Forward Journals Created By Ledger Close Falls In Last Financial Year.

(Doc ID 1560005.1)

Last updated on FEBRUARY 27, 2018

Applies to:

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

Symptoms


Actual Behavior:
------------------

Holiday calendar is enabled for GL business unit in Japanese. This BU is using a April- March daily calendar. Sat and Sun is not working day for this BU.
For FY2011 (2011-Apr-01 to 2012-Mar-31), last working day is 2012-Mar-30 (Friday)
For FY2012 (2012-Apr-01 to 2013-Mar-31), first working day is 2012-Apr-2 (Monday)


It is noted that after running Ledger Close (GLPCLOSE) with as of date 2012-Mar-30 (last working day of FY2011)
- Closing journal in ACCOUNTING_PERIOD 999 has journal date 2012-Mar-30 (Friday)
  >> This is working as expected because "2012-Mar-31" is Saturday.
- Roll forward journal in ACCOUNTING_PERIOD 0 of new financial year FY2012 has journal date 2012-Mar-30(Friday) too.
  >> This is incorrect. The roll forward journal should have a date from FY2012.

Expected Behavior:
-------------------

Expect roll forward journal in ACCOUNTING_PERIOD 0 has journal date 2012-Apr-2(Monday)

Steps to Replicate:
---------------------

1. Set up a BU with a holiday list with Sat and Sun defined as non-working days.
2. Assign an Apr-March daily calendar to above BU.
3. Create ledger balance for closing.
4. Run ledger closing with as of date 2012-Mar-30 and issue is replicated.

 

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