Contract and Rate Management
Sourcing Rate Basis Items and Cost Types
A sub-set of costs which can be defined in Oracle Transportation Management are supported for Oracle Transportation Sourcing's rate record templates.
You can use Oracle Transportation Management rating to set up base costs, stop-off charges, accessorials, special services, and LTL weight break discounts as detailed below. These costs are used to calculate the computed cost on the bid.
Let's look at which rate basis items and cost types are available for the transport modes supported by Oracle Transportation Sourcing.
Truckload (TL) Mode
The following Oracle Transportation Management rate basis items are supported for Oracle Transportation Sourcing when sourcing shipments with a mode of truckload (TL):
- For distance traveled, use the rate basis item of Shipment Total Distance Traveled.
-
- First, Oracle Transportation Sourcing attempts to use the average distance from the sourcing lane definition for each lane included in the lane summary.
- Next, if the average distance is not available (null), the distance on each sourcing shipment included in the lane summary is used. The lane summary averages the distance across all sourcing shipments included in the lane and the resulting value is stored as avg_distance in the lane_summary_stat database table.
- The avg_distance in the lane_summary_stat table is used to calculate the computed cost of the bid.
- For pallet, use the rate basis item of Shipment Total Number of Ship Units.
-
- First, Oracle Transportation Sourcing attempts to use the pallet count from the sourcing lane definition for each lane included in the lane summary.
- Next, if the pallet count is not available (null), the ship unit count on each sourcing shipment included in the lane summary is used. The lane summary averages the ship unit count across all shipments included in the lane summary and the resulting value is stored in the lane_summary_stat table as avg_shipunit_count.
- The avg_shipunit_count in the lane_summary_stat table is used to calculate the computed cost.
- For shipment flat rate, use the rate basis item of Shipment.
This rate basis item requires the total number of shipments (total_shipments) on the lane summary. The value in the lane summary is also required by the sourcing solver. - For duration, use the rate basis items of Source Total Activity Time and Destination Total Activity Time.
-
- The average activity time is pulled from each sourcing shipment and averaged across the lane. The result is stored in the lane_summary_stat table as avg_activity_time.
- The avg_activity_time is the average across all stops no matter which of these rate basis items you use.
- The avg_activity_time in the lane_summary_stat table is used to calculate the computed cost.
- For shipment equipment, use the rate basis item of Shipment Total Pieces of Equipment.
-
- Equipment count on each sourcing shipment included in the lane summary is used to calculate the average equipment count which is stored in the lane_summary_stat table as avg_equip_group_count.
- The avg_equip_group_count in the lane_summary_stat table is used to calculate the computed cost.
- For equipment reference units, use the following rate basis items:
- Shipment Total Weight
- Shipment Total Distance Traveled
- Source Total Activity Time
- Destination Total Activity Time
- Shipment Total Pieces of Equipment
- Destination Equipment Reference Unit Usage Count
- Destination Total Equipment Reference Unit Usage Count
- Stop Equipment Reference Unit Usage Count
- Stop Total Equipment Reference Unit Usage Count
- For equipment group, use the following rate basis items:
- For cost per stop for a multi-stop shipment, use any of the rate basis items supported for TL mode in Oracle Transportation sourcing and specify stops on the rate record attributes tab.
Note: For Oracle Transportation Sourcing, stops must be defined on the rate record and not the rate offering.
-
- First, Oracle Transportation Sourcing attempts to use the average stops from the sourcing lane definition for each lane included in the lane summary.
- Next, if the average stop is not available (null), the stops on each sourcing shipment included in the lane summary is used to calculate the average total stops. The result is stored in the lane_summary_stat table as avg_total_stops.
- The avg_total_stops in the lane_summary_stat table is used to calculate the computed cost.
- For cost per out of route distance, use the rate basis item of Shipment Circuity Distance and set the circuity distance cost and maximum circuity distance on the rate record attributes tab.
Note: For Oracle Transportation Sourcing, circuity must be defined on the rate record and not the rate offering.
-
- Circuity distance on each sourcing shipment included in the lane summary is used to calculate the average out of route distance. The result is stored in the lane_summary_stat table as avg_out_of_route_distance.
- The avg_out_of_route_distance in the lane_summary_stat table is used to calculate the computed cost.
- For shipment weight, use the rate basis item of Shipment Total Weight.
-
- Average weight on the lane definition.
- The average weight on the lane definition is used to calculate the computed cost.
Refer to the Truckload Flow Overview topic for detailed information about setting up Oracle Transportation Sourcing rates.
LTL Mode
The following Oracle Transportation Management rate basis items are supported for Oracle Transportation Sourcing when sourcing shipments with a mode of LTL:
- For shipment flat rate, use the rate basis item of Shipment.
Computed cost is the total cost for all shipments included on the lane summary for a bid. - For discount per LTL weight break, use:
-
- Discounts grid on the rate record attributes tab
- Weight on each sourcing shipment
- Rates must be setup to use SMC3's RateWareXL. See the LTL Flow Overview topic on specific details on setting up LTL rates for Oracle Transportation Sourcing.
- For NMFC ranges,
-
- Use of this rate basis item requires the NMFC Class ID on the sourcing shipment ship unit and/or on the ship unit line.
- NMFC ranges can be defined on the Attributes tab of rate record template.
- The NMFC class ID of the ship unit or ship unit line impacts the computed cost.
- For discount per lane, use the cost type of Discount. If discount value is included in the rate cost, the compute cost process disregards any weight break discounts that are specified.
- For minimum cost, use the Minimum Charge field on the Rate Attributes tab of the rate record template.
- For equipment reference units, use the following rate basis items:
Refer to the LTL Flow Overview topic for detailed information about setting up Oracle Transportation Sourcing rates.
VESSEL-CO Mode
The following Oracle Transportation Management rate basis items are supported for Oracle Transportation Sourcing when sourcing shipments with a transport mode of VESSEL-CO as follows:
Port to Port Moves:
- For shipment flat rate, use the rate basis item of Shipment.
This rate basis item requires the total number of shipments (total_shipments) on the lane summary. The value in the lane summary is also required by the sourcing solver.
Computed cost is per a single fictional shipment.
- For shipment equipment, use the rate basis item of Shipment Total Pieces of Equipment.
- For equipment reference units, use the following rate basis items:
- Shipment Total Weight
- Destination Equipment Reference Unit Usage Count
- Destination Total Equipment Reference Unit Usage Count
- Stop Equipment Reference Unit Usage Count
- Stop Total Equipment Reference Unit Usage Count
Moves Containing Source and Destination Arbitrary Lanes:
- For shipment flat rate, use the rate basis item of Shipment as explained above under Port to Port Moves.
- The special service code, accessorial code, and accessorial cost IDs must all have the same IDs for Sourcing to compute the cost for ocean shipments with arbitraries. These IDs are hard-coded within Sourcing and must be found exactly as documented below for ocean sourcing with arbitrary costs to work.
-
- SOURCE ARBITRARY COST
- DEST ARBITRARY COST
Conditional Costs
You can use the following rate basis items to define conditional costs:
Accessorial Costs
You can define accessorial costs with the any of the rate basis items supported for the applicable mode by Oracle Transportation Sourcing as mentioned above.
Including Accessorial Costs in Computed Cost
Accessorial costs are included in the computed cost based on the following options:
- Always apply option on the accessorial code which is specified on the Accessorials tab of the rate record
- Compute cost check box on the CRT configuration
The possible combinations and the expected results are listed below:
Always Apply Check Box on Accessorial Code |
Compute Cost Check Box on CRT Configuration |
Accessorial Cost Added to base cost |
---|---|---|
Selected |
Selected |
Yes |
Not selected |
Selected |
Yes |
Selected |
Not selected |
Yes |
Not selected |
Not selected |
No |