RTV Quantity Is Not Cleared After The RTV Is Shipped (Doc ID 1386484.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.1 to 13.1.4.1 [Release 13.1]
Information in this document applies to any platform.
Checked for the relevance of the document as on 22nd Oct,2013.

Symptoms

While shipping a Return To Vendor (RTV), the RTY_QTY in the ITEM_LOC_SOH table is not cleared.

Steps to Re-Create:

  1. Create and approve a RTV for 10 quantities for 2 items.
  2. RTV_QTY column is updated for 10 units in the ITEM_LOC_SOH table.
  3. RTV_DETAIL table will have NULL for QTY_RETURNED and QTY_CANCELLED.
  4. Ship 5 units for one item.
  5. RTV_DETAIL is updated for QTY_RETURNED =5,QTY_CANCELLED=5 for shipped item and QTY_RETURNED =0,QTY_CANCELLED=10 for unshipped item.
  6. Notice, the RTV_QTY in the ITEM_LOC_SOH is not cleared.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms