Fraction Factor Value of Rate Factor Source Stored With Incorrect Decimal Places (Doc ID 1500464.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.2.0 to 6.2.8 [Release 6.2]
Information in this document applies to any platform.

Symptoms

A Rate Factor entered as (e.g.) 10.4 is stored in the DB as 10.40000000000000035527136788005009293556
Since the factor is now exceeding 10.4, subsequent calculations are wrong.

To reproduce:

Enter the value of 10.4 manually via the UI into the Source Rate Factor.
Run the query select * from rate_factor through the backdoor, you will see the incorrectly stored value.

Cause

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