My Oracle Support Banner

MRTUPD Batch Bpdates the TSF_RESERVED_QTY And TSF_EXPECTED_QTY With Negative Quantity (Doc ID 2425790.1)

Last updated on MARCH 05, 2019

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 :

  1. Create Mass Return Transfer(MRT) from the Retail Merchandising System(RMS) application.
  2. Run MRT.pc batch.
  3. Change vdate to the date greater than tsf_not_after_date .
  4. Run the MRTUPD.pc batch.
  5. 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!

In this Document

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