My Oracle Support Banner

Shipment Cost Is Not Rounding Up To Nearest Interval (Doc ID 2445351.1)

Last updated on MAY 06, 2022

Applies to:

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

Symptoms

Shipment cost is not rounding up as defined in the rate record. The rate record is defined to compute the shipment total to round up for nearest interval of 0.0100. when an order is planned onto a shipment the total cost value does not round up to the nearest interval defined. Rate Record is defined as Charge 25.3500 TRL PER 1000 KG OF Shipment SELECT Weight for a specific Equipment group and rounding type has been defined as "Nearest Interval", Rounding interval as 0.0100 at currency field level always.

For example

If  the sell shipment <Shipment ID> (25.35 TRL per 1,000 KG of Shipment SELECT Weight (26500.0 KG) = 671.775 TRL [Min: 633.75 TRL]
This issue pertains even after trying all the parameters in rate cost. At the moment, the amount is shown as 671.77 where as in the database back-end the original value is shown as 671.769999999999981810105964541435241699

The issue can be reproduced at will with the following steps:
1. Create Rate Record is defined as Charge 25.3500 TRL PER 1000 KG OF Shipment SELECT Weight for Equipment group that is being used
2. Define rate record Rounding type has been defined as "Nearest Interval", Rounding interval as 0.0100 at currency field level always for the equipment group for a Service Provider
2. Create a Sell Shipment
3. Check the shipment total actual cost value

Changes

 

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
Changes
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.