Correct Material Transaction is Changing Transaction Date to SYSDATE When Profile "INV: Transaction Date Validation" is Set to "Do not allow date in past period" (Doc ID 2821927.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

Symptoms

On : 12.2.10 version, Batches

ACTUAL BEHAVIOR
---------------
When using Correct Material Transactions to change the qty on a transaction, the new transaction is having the transaction date set to sysdate instead of the date of the original transaction, even though the date of the original transaction is in the current period.

This is happening for both ingredients and products.

The INV: Transaction Date Validation profile had been set to "Do not allow past date", but even after changing this to "Do not allow date in past period" the problem still occurs.

It seems that "Do not allow date in past period" is being treated the same as "Do not allow past date". If the profile is set to "Allow date in any open period" then the Correction works correctly and the date is not updated.

EXPECTED BEHAVIOR
-----------------------
Expect the new transaction to have the same transaction date as the original transaction if the original transaction date was in the current period and INV: Transaction Date Validation profile is set to "Do not allow date in past period"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to the Correct Material Transactions form on a WIP batch (Production Supervisor > Batch Details > Inventory > Correct Material Transactions).
2. Edit the Quantity without changing the date and click the Correct button.
3. Check the transaction date by going to Inventory > View Material Transactions.

Changes

Cause

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