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:
Oracle Shipping Execution - Version 12.1.3 and laterInformation 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 ('<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
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
Goal |
Solution |
References |