My Oracle Support Banner

RTV_QTY Of Pack Components Is Not Cleared After Shipping RTV (Doc ID 2825268.1)

Last updated on JUNE 17, 2022

Applies to:

Oracle Retail Merchandising System - Version 15.0.3 and later
Information in this document applies to any platform.


When an RTV of a pack is created, the RTV_QTY of the pack components is increased, along with RTV_QTY of the pack itself.
When the RTV is shipped, pack RTV_QTY is cleared out but pack components RTV_QTY is not.

Not sure if increasing RTV_QTY is correct since if we check all items with RTV quantity when we are just returning a Pack it will give the impression that SKUs are also being returned - specially if we Return 1 pack and also SKUs in the same RTV.
But at least after shipping the RTV_QTY should also be cleared.

Either RTV_QTY for pack components is not increased upon RTV Approval or RTV_QTY for pack components is decreased upon RTV Shipment.

Steps to reproduce:
1- Have a Pack item that has 3 components of qty 10,12,8.
2- Have SOH as STOCK_ON_HAND as 1 for each (1 for pack in addition to 1 in each item), make sure PACK_COMP_SOH shows 10,12,8.
3- Create an RTV for qty 1 each (1 for pack in addition to 1 from each component item).
4- Approve RTV
ITEM_LOC_SOH shows: RTV_QTY as 1 (pack item), 11, 13, 9
Which is incorrect Since this indicates that the pack item is considered twice, once for the pack RTV_QTY, and once for each component RTV_QTY
5- Ship RTV
ITEM_LOC_SOH shows: RTV_QTY as 0 (pack item), 10, 12, 8
Which is incorrect, should be zeros for all.


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.