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.
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.
- Run batch stkxpld.pc.
- Upload file with 1 item whose quantity is saved with 4 characters after the decimal point (e.g., 10599.1357).
- Run batch stkupld.pc
- As result for item in fields stake_sku_loc.physical_count_qty = 10599.1357 and in stake_qty.qty = 10599.1357.
- 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.
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