How Does Store Inventory Management (SIM) Handle Non-Inventory Items?
Last updated on JUNE 14, 2017
Applies to:Oracle Retail Store Inventory Management - Version 12.0 to 13.1 [Release 12.0 to 13.1]
Information in this document applies to any platform.
Checked for relevance on 23-Apr-2013
Non-inventory items, such as warranty plans and gift cards, are items that can be sold in a store but do not necessarily have physical inventory.
Does the SIM application support such items ?
The following scenario can be observed:
- Pick one item from Retail Merchandising System (RMS) for which INVENTORY_IND in ITEM_MASTER table is set to 'N'.
- Do a sale for such an item.
- When the sale is loaded in RMS it does not impact the stock on hand (SOH) in ITEM_LOC_SOH table, but the same sale when loaded in SIM reduces the stock on hand in RK_STORE_ITEM_SOH table.
- Check and observe that some stores have negative SOH in SIM for that item whereas it is 0 in RMS.
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