Last updated on NOVEMBER 17, 2015
Applies to:Oracle Retail Merchandising System - Version 13.2.8 and later
Information in this document applies to any platform.
In Oracle Retail Merchandising System (RMS) 13.2.x, the attribute UOM_CONV_FACTOR in the ITEM_MASTER table is defined as a number(20, 10), and PACK_QTY in the PACKITEM table is defined as a number(12, 4) in the database. However, the Item Maintenance & Pack Setup screens only allow the user to enter values with up to 2 decimal places. If a number is entered with more decimals, the below error message is thrown:
Steps to Reproduce:
- Create a regular item A1 that is traded in milliliters (STANDARD_UOM = ML), bottled in 1L bottles. UOM_CONV_FACTOR should be set to 0.001 (screen does not allow this, as that attribute allows only 2 decimal places).
One could change the STANDARD_UOM to Liters; then the UOM_CONV_FACTOR would be 1. But doing this causes the same problem described in scenario 2a below.
- Create a complex pack that uses 25 ML of item A1.
2a. If item A1 is set with STANDARD_UOM = ML, PACK_QTY = 20 can be added.
2b. If item A1 is set with STANDARD_UOM = L, user cannot add PACK_QTY = 0.025 (can only add 0.02 or 0.03).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms