Guided Demonstration 1 - Creating Rate Records
Creating a Rate Record for Truckload
1. Click Contract and Rate Management > Contract Management > Rate Record.
2. Click New at the bottom of the page.
OTM displays the Rate Offering search tab. Whenever you create a new rate record, you must associate it with a rate offering.
3. Click Contract and Rate Management > Contract Management > Rate Record.
4. Enter a Rate Record ID of BTT9 AZ-CA.
5. Click Search at the bottom of the page.
6. Click the ID.
OTM displays the Lane Info tab.
• There are options that can be specified on both the rate offering and rate record. As a general principle, OTM uses the value in the more specific object if it is specified in both places. The rate record is more specific than the rate offering.
− For example, the stop-off charges that were discussed in the rate offering lesson can also be specified on the rate record. If stop-off charges are specified in both places, the data on the rate record is used.
• Note the Rate Offering ID. Every rate record must be associated with a rate offering.
You can have multiple rate records associated with one rate offering.
7. Click the Source Geo Hierarchy drop-down list.
• The geo hierarchy drop-down list defines the general start and end points for the rate record. Regions can also be used to define this information.
• You can select the appropriate geo hierarchy for the rate you are defining. In this example, the source geo hierarchy is STATE/PROVINCE.
8. Click the Destination Geo Hierarchy drop-down list.
• Note the destination geo hierarchy of STATE/PROVINCE. You can combine different geo hierarchies. For example, from location to country.
• The source geo hierarchy and destination geo hierarchy determine the fields that appear on the Attributes tab.
9. Click Attributes at the bottom of the page.
OTM displays the Attributes tab.
• Note the Source Geography Province Code of AZ. OTM can only use this rate record if the potential shipment departs from Arizona. Since we specified STATE/PROVINCE as our source geo hierarchy on the Lane Info tab, the source geography is province code.
• Note the Destination Geography Province Code of CA. OTM can only use this rate record if the potential shipment arrives in California.
• This is also where you set up rate record specific off information. If you enter stop-off information here, it overrides stop-stop-off information defined on the rate stop-offering.
10. Click Rate Costs at the bottom of the page.
OTM displays the Rate Costs tab.
• Note the Multi-Costs Rule drop-down list. You can define many costs on this page. The multi-cost rule determines how OTM should combine these costs into one total cost.
− Add – OTM adds all valid costs listed on the Rate Costs tab and determines a final total for the shipment.
Karthik Hulikanthimutt (karthikฺhulikanthimutt@oracleฺcom) has a non-transferable license to use this Student Guideฺ
Unauthorized reproduction or distribution prohibitedฺ Copyright© 2013, Oracle and/or its affiliatesฺ
Copyright © 2014, Oracle and/or its affiliates. All rights reserved.
Guided Demonstration 1 - Creating Rate Records
− Minimum – OTM calculates the lowest valid cost and uses that for the shipment.
− Maximum – OTM calculates the highest valid cost and uses that for the shipment.
• Note this rate record contains one rate cost. If this rate record is used for a buy shipment, a rate cost of 600.00 USD per shipment is applied.
11. Click Add A Cost at the bottom of the page.
The Rates page contains the following sections:
• Conditions define when OTM should apply a rate cost. Up to 4 conditional rules can exist for each rate cost. If you have multiple conditional rules, you can specify how they relate to each other:
− AND – All the rules must be satisfied for this rate cost to be applied.
− OR – One of the rules must be satisfied for this rate cost to be applied.
− SELECTED – OTM finds valid matches for your first conditional rule and then only passes those matches onto the next conditional rule.
• Charge defines what costs OTM should apply when shipments meet the criteria specified in the Conditions section.
− There are 4 Cost Types to choose from:
− Charge – You can enter an Amount, a Basis, and the Unit. There are many basis options available such as per shipment, per weight, per distance, etc. You can limit the basis options OTM displays in the list by marking only certain basis options as enabled or select the basis options you want to display per rate offering type.
− Discount – You can enter an Apply Discount Of percentage which applies a discount to the current running total of shipment costs.
− External – You can enter an External Rating Engine ID if the rate is determined by an external rating engine.
− Profile – You can set up unit breaks such as weight or volume breaks.
− You can also specify a Minimum Charge or a Maximum Charge. If you define many costs, you can define certain rate costs as the minimum or maximum. Depending on the setting of the Multi-Costs Rule drop-down list, OTM selects the appropriate rate cost.
• Options define the type of rate you entered in the Charge section. You must indicate if the cost is normal, minimum, maximum, or weighted. You can also add addition rate information such as rounding details.
• Miscellaneous defines tariff information about the schedule of prices that a service provider publishes for the movement of freight.
Karthik Hulikanthimutt (karthikฺhulikanthimutt@oracleฺcom) has a non-transferable license to use this Student Guideฺ
Unauthorized reproduction or distribution prohibitedฺ Copyright© 2013, Oracle and/or its affiliatesฺ
Copyright © 2014, Oracle and/or its affiliates. All rights reserved.
Practice 1 - Creating Rate Records for Truckload
Practice 1 - Creating Rate Records for Truckload
Creating a Rate Record for Truckload
1. Click Contract and Rate Management > Contract Management > Rate Record.
2. Click New at the bottom of the page.
OTM displays the Rate Offering search tab. Whenever you create a new rate record, you must associate it with a rate offering.
3. Enter a Rate Offering ID of BTT9 TL (previously created).
4. Click Search at the bottom of the page.
OTM displays the Rate Offering results page.
5. Ensure the option button next to BTT9 TL is marked.
6. Click Finish at the top of the page.
OTM displays the Lane Info tab.
7. Enter a Rate Record ID of BTT9 AZ-CA.
8. Select the Source Geo Hierarchy of STATE/PROVINCE.
9. Select the Destination Geo Hierarchy of STATE/PROVINCE.
10. Click Attributes at the bottom of the page.
OTM displays the Attributes tab.
11. Enter the Source Geography Province Code of AZ.
12. Enter the Destination Geography Province Code of CA.
13. Click Rate Costs at the bottom of the page.
OTM displays the Rate Costs tab.
14. Click Add A Cost at the bottom of the page.
OTM displays the Rates page.
15. Ensure a Cost Type of Charge is selected.
16. Enter an Amount of 600.00 USD.
17. From the Basis drop-down list, select Shipment.
18. Click Save at the bottom of the page.
OTM returns to the Rate Costs tab.
19. Click Finished at the top of the page.
OTM displays the confirmation page.
Creating Rate Record for Truckload
20. Click Contract and Rate Management > Contract Management > Rate Record.
21. Click New at the bottom of the page.
OTM displays the Rate Offering search tab. Whenever you create a new rate record, you must associate it with a rate offering.
22. Enter a Rate Offering ID of ATL9 TL.
23. Click Search at the bottom of the page.
OTM displays the Rate Offering results page.
24. Ensure the option button next to ATL9 TL is marked.
25. Click Finish at the top of the page.
OTM displays the Lane Info tab.
Karthik Hulikanthimutt (karthikฺhulikanthimutt@oracleฺcom) has a non-transferable license to use this Student Guideฺ
Unauthorized reproduction or distribution prohibitedฺ Copyright© 2013, Oracle and/or its affiliatesฺ
Copyright © 2014, Oracle and/or its affiliates. All rights reserved.
Practice 1 - Creating Rate Records for Truckload
26. Enter a Rate Record ID of ATL9 850-CA.
27. Select a Source Geo Hierarchy of USZIP3.
28. Select a Destination Geo Hierarchy of STATE/PROVINCE.
29. Click Attributes at the bottom of the page.
OTM displays the Attributes tab.
30. Enter a Source Geography Postal Code of 850.
31. Enter a Destination Geography Province Code of CA.
32. Click Rate Costs at the bottom of the page.
OTM displays the Rate Costs tab.
33. Click Add A Cost at the bottom of the page.
OTM displays the Rates page.
34. Ensure a Cost Type of Charge is selected.
35. Enter an Amount of 550.00 USD.
36. From the Basis drop-down list, select Shipment.
37. Click Save at the bottom of the page.
OTM returns to the Rate Costs tab.
38. Click Finished at the top of the page.
OTM displays the confirmation page.
Karthik Hulikanthimutt (karthikฺhulikanthimutt@oracleฺcom) has a non-transferable license to use this Student Guideฺ
Unauthorized reproduction or distribution prohibitedฺ Copyright© 2013, Oracle and/or its affiliatesฺ
Copyright © 2014, Oracle and/or its affiliates. All rights reserved.