My Oracle Support Banner

When I Have A Number In A Shipment Cost That Is Rounded Why Is The Figure Saved To The Database Not Rounded? (Doc ID 1514138.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Transportation Management - Version 6.0 and later
Information in this document applies to any platform.


We've set up an Accessorial Cost set to round to the nearest penny.

However, when we build a Shipment (or recalculate a Shipment) with this Accessorial Cost, we still end up with a database record consisting of 20+ decimal places for example 50.14999999999999857891452847979962825775).

The logs seem to indicate that the value should be stored as $50.15, but the decimals persist.

Why is this?


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

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