Display of Quantity in Units of Measure (UOM) on Stkvwhdist Form - 2 Decimals vs. 4 Decimals (Doc ID 2069783.1)

Last updated on OCTOBER 26, 2015

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 and later
Information in this document applies to any platform.

Goal

An item's quantity for measurable items (UOM = M, M2, KG) on the [stkvwhdist] form is displayed with 2 characters after the decimal point.  In files, however, which are sent as the result of warehouse inventory and by distribution of items in locations, these quantities are saved with 4 characters after the decimal point.

Because of this, the distribution of item quantity can be problematic.  For example, for an item whose quantity = 10 000.0001 (in file) but shows 10 000.00 in the stkvwhdist form, redistribution of items in virtual WH (e.g., 2000.00+4000.00+4000.00) an error occurs stating that quantities sent in the file must match quantities to redistribute.

Example:

  1. Run batch stkxpld.pc.
  2. Upload file with 1 item whose quantity is saved with 4 characters after the decimal point (e.g., 10599.1357).
  3. Run batch stkupld.pc
  4. As result for item in fields stake_sku_loc.physical_count_qty = 10599.1357 and in stake_qty.qty = 10599.1357.
  5. On stkvwhdist form, we have item's current quantity rounded to 3 characters after the decimal point 10599.136 and redistributed quantity rounded to 3 characters after the decimal point.  When we try typing in the field of redistributed quantity number with more then 2 characters after the decimal point, an error occurs.  If we try to redistribute items between virtual warehouses, an error occurs because the sum of redistributed quantity in the form = 10599.14, but in the database it is 10599.1357.

Solution

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