MRTUPD Batch Bpdates the TSF_RESERVED_QTY And TSF_EXPECTED_QTY With Negative Quantity
(Doc ID 2425790.1)
Last updated on JULY 27, 2018
Applies to:Oracle Retail Merchandising System - Version 13.2.6 and later
Information in this document applies to any platform.
While MRTUPD batch is closing Mass Return Transfers(MRT) which are in Input status,it is observed that tsf_reserved_qty and tsf_expected_qty in ITEM_LOC_SOH are updated to negative.
Incorrect quantities in these buckets is impacting auto replenishment.
Steps to Reproduce :
- Create Mass Return Transfer(MRT) from the Retail Merchandising System(RMS) application.
- Run MRT.pc batch.
- Change vdate to the date greater than tsf_not_after_date .
- Run the MRTUPD.pc batch.
- Observe that tsf_reserved_qty and tsf_expected_qty are updated in ITEM_LOC_SOH to negative quantities.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!