InvAdjustCre Message Causes Inventory Discrepancies Between SIM and RMS as the Quantity sent is Rounded to 3 Decimal Places (Doc ID 2301518.1)

Last updated on MAY 27, 2020

Applies to:

Symptoms

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;

Cause