My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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
Symptoms
Cause
Solution
References


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