OTM: HOW TO CONTROL THE PRECISION OF THE NUMBER STORED IN THE DATABASE WITH REGARD TO SHIPMENT TABLE (Doc ID 1068080.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.5.05.06 - Release: 5.5
Information in this document applies to any platform.

Goal

There is a fractional difference between the weight per ship unit defined on the Order Release and that when queried from the database.

Example
---------
select * from ship_unit where ship_unit_xid = '3-1273359931-001' shows weight value of 0.1000000000000000055511151231257827021181 instead of the entered value of 0.1.

select * from ship_unit where ship_unit_xid = '3-1273359931_1-001'shows weight value of
0.2999999999999999888977697537484345957636 instead of the entered value of 0.3.


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