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.
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.
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|