Reversal Criteria Set With Last Day Reversal Date Not Working As Expected (Doc ID 1632850.1)

Last updated on FEBRUARY 14, 2024

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.