My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

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


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.




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.