Stock On Hand Discrepancy Between RMS and SIM for Pack and Component Items (Doc ID 1379270.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 12 to 13.2 [Release 12.0 to 13.2]
Oracle Retail Merchandising System - Version 12 to 13.2 [Release 12.0 to 13.2]
Information in this document applies to any platform.
Checked for relevance May-2013

Goal

When  a Pack Item is sold at the point-of-sale (POS), in Retail Merchandising System (RMS) the Stock on Hand (SOH) for component item goes down and SOH for pack item remains same.  In Store Inventory Management (SIM), however, SOH for Pack Item goes down and SOH for component items remains the same.  This is creates a SOH imbalance between RMS and SIM.  What is the reason for this behavior?

 

Steps to Reproduce:

1. Create a Pack Item A.

Consider Pack Item A, SOH in RMS and SIM is 0


2. Create a Component Item B for Pack A.

(A=10 units of B), SOH in RMS and SIM is 20.


3. Sell 1 unit of Item A in point-of-sale application.

4. Extract the corresponding POSU file in RMS and SIM.

Comparison of SOH in SIM/RMS:   SOH in RMS:  A=0, B=10.    SOH in SIM: A=-1, B=20




Solution

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