Batch Close Date was Allowed to be Entered Earlier Than Reversed Resource Transaction Dates (Doc ID 2393036.1)

Last updated on DECEMBER 02, 2021

Applies to:

Symptoms

On : 12.1.3 version, Batches

ACTUAL BEHAVIOR
---------------
Batch Close is not validating Close Date against transaction dates of resource transactions that have been reversed, which causes issues in Financials because there can be resource transactions in a later period than the Close Date period

EXPECTED BEHAVIOR
-----------------------
There is supposed to be validation between transaction dates and batch close date so that batch close date is never earlier than any transaction dates

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Note: the transactions do not actually have to be in different periods, simply in this order, but this is how the customer described the steps, and it is clearer this way.
1) Query Batch where resource transaction is in past period ( Period 0)
2) Correct resource transaction, updating usage and changing transaction date to be in period 2
3) Now pick same resource transaction and and change transaction date to be in Period 1.
4) Close Batch with Close Date in Period 1 - later than transaction date entered in Step 3. Batch closed successfully without any error or warning, even though there are reversed resource transactions with trans date in period 2.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, resource transactions have a transaction date in a later period than the batch close, and this causes issues in Financials.

Cause

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