Wsh_delivery_details.volume Reset To 0 After Pick Release When Decimal Greater 5

(Doc ID 2014262.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.

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 ('19209405', '19209406', '19209407');

Before Pick Release
UNIT_VOLUME      VOLUME
-------------------------------
.000000624        .000000624
.000002              .000002
.000002              .000002

After Pick Release
UNIT_VOLUME     VOLUME
-------------------------------
.000000624          0
.000002                0
.000002                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

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