InvAdjustCre Message Causes Inventory Discrepancies Between SIM and RMS as the Quantity sent is Rounded to 3 Decimal Places
Last updated on AUGUST 31, 2017
Applies to:Oracle Retail Store Inventory Management - Version 15.0 and later
Information in this document applies to any platform.
In Oracle Retail Store Inventory Management (SIM), when a wastage inventory adjustment is applied, the adjustment is done with 4 decimal places precision. That can be noticed in the STORE_ITEM_STOCK and STORE_ITEM_STOCK_HISTORY tables.
The quantity in the InvAdjustCre message sent to the Retail Merchandising System (RMS) is rounded to 3 decimal places, which in some cases, causes inventory discrepancies between SIM and RMS. Also, if the adjustment is lower than 0.0005, the rounded value to 3 decimal places is zero and fails to be consumed by RMS.
Steps to Recreate:
1. Create a wastage product group with 1% Shrinkage, for an item with 'KG' as unit of measure, that has an inventory with 4 decimal places (example 121.1302).
2. Schedule the product group.
3. Run WastageInventoryAdjustments batch.
4. Check STORE_ITEM_STOCK_HISTORY table and notice that an adjustment was applied on SIM with 4 decimal places (i.e. 1.2113).
5. On the other hand the adjustment sent to the RMS in the InvAdjustCre message is rounded to 3 decimal places;
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