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:
- 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.
- 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