My Oracle Support Banner

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:

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;


To view full details, 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 a vibrant support community of peers and Oracle experts.