When There Are Two Itineraries and Preferred Rates are to be Used OTM Does Not Always Select the Correct Itinerary and Rate. (Doc ID 1074039.1)

Symptoms

In OTM Version 6.0 when there are two Itineraries each for a different Service Provider and OTM is set to use Rate Preference the preferred rate is not selected.

STEPS TO REPRODUCE:
---------------------------

1 - Log onto an internal OTM 6.0 system.

2 - Navigate to: Contract and Rate Management > Contract Management > Rate Offering, create the following Rates:

ID: 4_USD
Service Provider: CARRIER_1

From the success Screen create Rate Record:
ID: 4_USD
Cost: 4 USD per mile.

ID: 3_USD
Service Provider: TL_CARRIER_2

From the success screen create Rate Record:
ID: 3_USD
Cost: 3 USD per Mile

3 - Navigate to: Shipment Management > Equipment Management > Equipment Group and create:

ID: 60000 limited to carry 60000 LBS

ID: 70000 limited to carry 70000 LBS

4 - Navigate to: Shipment Management > Equipment Management > Equipment Group Profile and create

ID: 60000, containing the 60000 equip.

ID: 70000, containing the 70000 equip.

5 - Navigate to: Contract and Rate Management > Power Data > General > Service Provider Profiles, create the following:

ID: 4_USD containing CARRIER_1

ID: 3_USD containing TL_CARRIER_2

6 - Navigate to: Shipment Management > Itinerary Management > Itinerary Manager and create the following:

ID: 4_USD
Multistop: Ticked
From: ORACLE_BIRMINGHAM
To: ORACLE_BRISTOL
Leg: Primary
Optimise Equipment
Multistop into one Equip.
Mode Profile: TL
Service Provider Profile ID: 4_USD
Equipment Group Profile ID: 60000

ID: 3_USD
Multistop: Ticked
From: ORACLE_BIRMINGHAM
To: ORACLE_BRISTOL
Leg: Primary
Optimise Equipment
Multistop into one Equip.
Mode Profile: TL
Service Provider Profile ID: 3_USD
Equipment Group Profile ID: 70000

7 - Navigate to: Order Management > Order Release > Order Release and created 3 Orders with a total weight of 70000 LB

ID: 1 (30000 LBS)
ID: 2 (30000 LBS)
ID: 3 (10000 LBS)

8 - Selecte the 3 Order and Bulk Plann them via Actions > Operational Planning > Create Buy Shipment > Bulk Plan, using the PARAMS Parameter.

9 - 2 Shipments are built 01259 and 1260 Both using the 4 USD cost.

10 - Adjust the weight of the smallest order to be smaller, so that the 3 orders are larger than the 600000 LBS Equipment and smaller than the 70000 LBS Equipment.

11 - Replan the 3 Orders and the 3 USD rate was used. This is expected as the 3USD rate is cheaper and only one shipment is needed.

12 - Navigate to: Contract and Rate Management > Contract Management > Rate Preference > Clicke NEW and create the following:

ID: 1
Lane ID: 1 (Birmingham to Bristol)
Rate Offering: 4_USD

13 - Navigate to: Shipment Management > Power Data > General > Parameter Sets, clicked NEW and create:

ID: 1
Use Rate Preference: 2.Preferred Rates If available.

14 - Bulk Plan the orders using the Parameter Set

15 - The Shipment was is created using the 3 USD rate and not the preferred 4 USD rate.

Cause

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