Negative Nonsellable Units in Buckets Not Displayed on the SIM PC or Mobile UI (Doc ID 2665787.1)

Last updated on APRIL 12, 2023

Applies to:

Symptoms

Retail Store Inventory Management (RSIM) PC and MAF UI is not displaying negative nonsell units in buckets which is misleading to the user since the nonsell values do not match the total that is displayed.


Steps to Reproduce:

Prerequisites:

STORE_ITEM_STOCK_NONSELL table has the following data as an example.
---------------------------------------------------

ITEMID STORE_ID NONSELLABLE_TYPE_ID QUANTITY
---------------------------------------------------

102050009         1111                  4       20
102050009         1111                  1       10
102050009         1111                  2       -7

--------------------------------------------------

1. Log into SIM
2. Select Lookups > Item Lookup > Search for Item 102050009
3. On the Item Detail dialog, click on the Non-Sellable option
4. Nonsellable Inventory popup shows Nonsellable = 23 and the following sub buckets

Nonsellable 23
PB Holds = 20
Damage Returns = 10

Changes

Cause

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