My Oracle Support Banner

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

Last updated on APRIL 14, 2021

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 item1 that is traded in milliliters (STANDARD_UOM = ML), Packed in 1L quantity. 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 item1.
    2a. If item item1 is set with STANDARD_UOM = ML, PACK_QTY = 20 can be added.
    2b. If item item1 is set with STANDARD_UOM = L, user cannot add PACK_QTY = 0.025 (can only add 0.02 or 0.03).



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.