Item Maintenance and Pack Setup Screens Only Allow Entry of Values with Two Decimal Places (Doc ID 2076411.1)

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:

  1. 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.
  2. 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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms