Reversal Criteria Set With Last Day Reversal Date Not Working As Expected

(Doc ID 1632850.1)

Last updated on MAY 03, 2017

Applies to:

Oracle Fusion General Ledger - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.4.0.0 version, Capture Transactions-Record and Edit Standard Journal Entries

ACTUAL BEHAVIOR
---------------
A journal category was set to reverse as of the last day of the next non adjusting period via a reversal criteria set. A journal was created using that category and the AutoReverse Journal program that ran shortly after picked it up and it got reversed immediately at the beginning of the next period.

EXPECTED BEHAVIOR
-----------------------
Expect for the journal reversal to be created in the last day of the next non adjusting period.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Reversal criteria for a category with the following options:
  Reversal Period: Next nonadjusting period
  Reversal Date: Last Day
  Reversal Method: Switch Debit or Credit
  Automatic Reversal Option: Reverse and Post automatically

2. Assign the criteria set to the ledger in the Specify Ledger Options UI.
3. Create a journal entry for the specific category in a given period and post it.
4. Launch the AutoReverse Journal program using the next period in the parameters.
5. Check the execution report and resulting reversal journal. The resulting reversal journal has an accounting date of the beginning of the next period.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, a business case where the reversal for certain categories is expected to only happen at the end of the period, is not being met.

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