Multi stop Logic Inaccurate Cost Comparison Doing Distance Savings Calculations (Doc ID 1669284.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

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

Symptoms

 When attempting to plan two orders together, the following error occurs.

 -- Issue
 One multi-stop TL shipment is planned

 -- Expected Behavior
That two separate low cost shipments would be planned


The issue can be reproduced at will with the following steps.

Log into a support instance running OTM 6.3.2

1. Create 2 Orders:
ORDER_1 (plant_nv -> customer_nv)
ORDER_2 (plant_nv -> customer_nv2)

Rates:
RO_NV_MEX (currency: MXN)/RR_NV_MEX (NV -> CUSTOMER_NV2) - $200/shipment
RO_NV_MEX2 ( currency: USD)/RR_NV_MEX2 (PLANT_NV -> customer_nv) - $20/shipment
RO_TL_NV (currency: USD) /RR_TL_NV (NV - > NV) - $250/shipment

Set parameter: MULTISTOP COST SAVING CHECK TYPE to form cost savings check after each iteration

Select the 2 orders and bulk plan them.
Orders will be planned onto 1 multistop shipment (which is not the expected result)

Log:
014-03-18 05:30:12.908 181240 Debug Multistop A new TShipmentPair (different OD) is generated. Up to now, 1 pairs have been generated. batch - 1
2014-03-18 05:30:12.908 181240 Debug Multistop Check if it is valid to combine for TShipmentPair: Pair of: 164854364 (EP.PLANT_NV->EP.CUSTOMER_NV2) and 175502194 (EP.PLANT_NV->EP.CUSTOMER_NV)
Distance Saving: 14.079999999999998 MI
batch - 1
2014-03-18 05:30:13.007 181240 Debug Multistop Passed assign null equipment group and recalculate cost!! :-) batch - 1
2014-03-18 05:30:13.007 181240 Debug Multistop Check cost saving at iteration ... batch - 1
2014-03-18 05:30:13.008 181240 Debug MultistopDetails Combined cost: 250.0, adjusted uncombined cost (adding 0.01): 280.01 batch - 1
2014-03-18 05:30:13.008 181240 Debug Multistop Passed cost saving check!! :-) batch - 1
2014-03-18 05:30:13.008 181240 Debug MultistopDetails All checks are passed, start to combine ... batch - 1
2014-03-18 05:30:13.008 181240 Debug MultistopDetails Combined successfully. Returing paired object: Pairable TShipment: 174496140 (EP.PLANT_NV->EP.CUSTOMER_NV->EP.CUSTOMER_NV2) batch - 1
2014-03-18 05:30:13.008 181240 Debug Multistop Start insertion of interim points ... batch - 1
2014-03-18 05:30:13.008 181240 Debug Multistop end insertion of interim points batch - 1

Notice that the cost comparison is not correct.

Combined cost: 250.0, adjusted uncombined cost (adding 0.01): 280.01 batch - 1

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