Wsh_delivery_details.volume Reset To 0 After Pick Release When Decimal Greater 5 (Doc ID 2014262.1)

Last updated on MARCH 10, 2019

Applies to:

Goal

Find that some delivery details show a value of 0 (zero) for Volume after they are pick released.
Seem to be related to volume calculation and rounding.
Some items have quite a small volume, for example 0.000000624 cubic meters.
These are the types of items that have the issue

Sample order:
Run the following query before and after pick release.
SELECT unit_volume, volume
FROM wsh_delivery_details
WHERE delivery_detail_id in ('<DELIVERY_DETAIL_ID1>', '<DELIVERY_DETAIL_ID2>', '<DELIVERY_DETAIL_ID3>');

Before Pick Release
UNIT_VOLUME      VOLUME
-------------------------------
.000000XX        .000000XX
.00000X             .00000X
.00000X              .00000X

After Pick Release
UNIT_VOLUME     VOLUME
-------------------------------
.000000XX          0
.00000X                0
.00000X                0


Questions
---------------
1) What are the specifics on the volume calculation and rounding that Shipping does in wsh_delivery_details?

2) How many decimal symbols are supported?
 

Solution

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