Fraction Factor Value of Rate Factor Source Stored With Incorrect Decimal Places
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.
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.
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.
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