Accessorial Calculation From Rate Factor Is Coming Out Wrong Because of Decimal Storage in The Database (Doc ID 2107054.1)

Last updated on FEBRUARY 16, 2016

Applies to:

Oracle Transportation Management - Version 6.3.4 to 6.3.8 [Release 6.3]
Information in this document applies to any platform.

Symptoms


Accessorial Cost calculation from Rate Factor is coming out wrong due to decimal storage in the database

Steps to reproduce:

1. Navigate to Contract and Rate Management -> Power Data -> General -> Rate Factor
2. Search for Rate Factor Source
3. Actions -> Process Unprocessed Rate Factors
4. Navigate to Contract and Rate Management -> Contract Management -> Rate Record
5. Search for Rate Record associated with the rate factor rule
6. Edit and go to "Accessorials" tab
7. Click on the Accessorial Cost (starts with "RF")

Notice the charge is:

Charge 8740.1293 ZAR PER Buy Shipment

According to the math, it should be: 1048.47*0.08336/0.01 = 8740.04592.

However OTM is using the NEXT cost row (for 1048.48000), which is: 1048.48*0.08336/0.01 = 8740.12928 (rounded to 8740.1293).

 

 

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