[SOLVED] Using Routing Rules

#1 (**permalink**) June 6th, 2007, 06:49

Hi All,

I was trying to use the routing rules in my planning process, but could
not achieve the desired behavior. Below is what I wanted to do:

1. Have two Rate Records between point A and B. These rate records
belong to different service providers (say S1 and S2).
2. For my Ship From Location, I wanted to use service provider S1
always even though the rates of S2 are cheaper.
3. I setup a routing rule at Organization with Location as my Ship
>From location. I have specified the lane in this routing rule and the
service provider S1 has been attached to this lane.
4. Now when I do the bulk planning, the shipment is created with
service provider S2. My preferred service provider is not selected.

I am not able to understand how to achieve this. I would appreciate it
if anybody can tell me what I am missing here. I am at version 5.5.

Regards,

-Salil

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com

#2 (**permalink**) June 6th, 2007, 13:08

Salil -

I know the business scenario that you are trying to accomplish can be done using Rate Preferences. They allow the system to select the rate for carrier S1 instead of carrier S2 even though S2 is cheaper as long as both of those carriers are the same mode.

This can also be done using Rate Quality Factors, but can have unwanted results if you are performing bulk planning and rate shopping across modes.

Hope this helps,

Graham Page
Sears Logistics Services
A3-388A
office: 847-645-4236
cell: 773-426-7639

________________________________

From: owner-otmsig (AT) solutionbeacon (DOT) net on behalf of salil.sharma (AT) wipro (DOT) com
Sent: Wed 6/6/2007 12:00 AM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: Using Routing Rules

Hi All,

I was trying to use the routing rules in my planning process, but could not achieve the desired behavior. Below is what I wanted to do:

1. Have two Rate Records between point A and B. These rate records belong to different service providers (say S1 and S2).
2. For my Ship From Location, I wanted to use service provider S1 always even though the rates of S2 are cheaper.
3. I setup a routing rule at Organization with Location as my Ship From location. I have specified the lane in this routing rule and the service provider S1 has been attached to this lane.
4. Now when I do the bulk planning, the shipment is created with service provider S2. My preferred service provider is not selected.

I am not able to understand how to achieve this. I would appreciate it if anybody can tell me what I am missing here. I am at version 5.5.

Regards,

-Salil

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com

You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!

bmj_23 · #3 (**permalink**) June 6th, 2007, 23:46

I would be looking at rate quality factors for this scenario. I have used them in a few implementations and they should work fine for what you are looking to achieve.

I am not sure that routing rules were ever designed to accomplish this kind of operational planning scenario.

An alternative, if you know that each order coming out of a location should be shipped with a specified service provider, is to enforce that as a constraint on the order release. You could do that with a Direct SQL update agent at the time of order release / order base creation.

#4 (**permalink**) June 7th, 2007, 08:20

To take the last suggestion one step further, and this may or may not
work for your business, is looking at the geographical hierarchies of
the rates in question. If the more expensive rates have a more specific
geo hierarchy (you determine the hierarchy as well), they will be chosen
over the less expensive rates. It's easier to maintain and trouble
shoot later.

Marnie Schultz
Logistics Operations - Center of Excellence*Kraft Foods Global,
Inc.*(60

285-6229*Marnie.Schultz (AT) Kraft (DOT) com

-----Original Message-----
From: owner-otmsig (AT) solutionbeacon (DOT) net
[mailto

wner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of Rick v100
Sent: Wednesday, June 06, 2007 8:28 PM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: Re: Using Routing Rules

There are several ways in OTM to solve this problem.
You could specify the carrier on the leg in the itinerary, you could use
rate factors, you could set up the planning parameters to look at other
factors besides cheapest cost.

All depends on how it will impact planning on other orders.

Rick

--- OTMSIG <otmsig (AT) otmfaq (DOT) com> wrote:

>
> I would be looking at rate quality factors for this scenario. I have
> used them in a few implementations and they should work fine for what
> you are looking to achieve.
>
> I am not sure that routing rules were ever designed to accomplish this
> kind of operational planning scenario.
>
> An alternative, if you know that each order coming out of a location
> should be shipped with a specified service provider, is to enforce
> that as a constraint on the order release. You could do that with a
> Direct SQL update agent at the time of order release / order base
> creation.
>
>
> --
> bmj_23
>
------------------------------------------------------------------------
> bmj_23's Profile:
> http://www.otmfaq.com/forums/member.php?userid=227
> View this thread:
> http://www.otmfaq.com/forums/showthread.php?t=270 ([SOLVED] Using Routing Rules)
>
>
> You are receiving this mail as a subscriber of the Oracle
> Transportation Management SIG List Server. This list is provided by
> Solution Beacon, LLC for the Oracle Transportation Management SIG to
> facilitate distribution of issues and topics related to Oracle
> Transportation Management. If you do not want to receive future mail
> from the list, send email to majordomo (AT) solutionbeacon (DOT) net with the
> words "unsubscribe otmsig" (without
> quotes) in the body of the email.
> If you need help, please contact
> mweiss (AT) solutionbeacon (DOT) com.
> Thank you!
>

You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate
distribution of issues and topics related to Oracle Transportation
Management. If you do not want to receive future mail from the list,
send email to majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe
otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!

#5 (**permalink**) June 7th, 2007, 08:20

Right. This idea is in conjunction with the last suggestion in the
previous email. After the parameter is set, this set up does have the
desired effect, and it's done without maintaining Rate Factors.

-----Original Message-----
From: owner-otmsig (AT) solutionbeacon (DOT) net
[mailto

wner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of Rick v100
Sent: Wednesday, June 06, 2007 10:32 PM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: RE: Using Routing Rules

you would need to turn on planning parameters for OTM to consider rates
at all geo-hierarchies for that to work. OTM out of the box (at least
prior to 5.5) took most specific lane over the more generic.

Rick

--- Marnie.Schultz (AT) kraft (DOT) com wrote:

> To take the last suggestion one step further, and this may or may not
> work for your business, is looking at the geographical hierarchies of
> the rates in question. If the more expensive rates have a more
> specific geo hierarchy (you determine the hierarchy as well), they
> will be chosen over the less expensive rates. It's easier to maintain

> and trouble shoot later.
>
>
>
> Marnie Schultz
> Logistics Operations - Center of Excellence*Kraft Foods Global,
> Inc.*(60

285-6229*Marnie.Schultz (AT) Kraft (DOT) com
>
>
>
> -----Original Message-----
> From: owner-otmsig (AT) solutionbeacon (DOT) net
> [mailto

wner-otmsig (AT) solutionbeacon (DOT) net] On Behalf
> Of Rick v100
> Sent: Wednesday, June 06, 2007 8:28 PM
> To: otmsig (AT) solutionbeacon (DOT) net
> Subject: Re: Using Routing Rules
>
> There are several ways in OTM to solve this problem.
> You could specify the carrier on the leg in the
> itinerary, you could use
> rate factors, you could set up the planning
> parameters to look at other
> factors besides cheapest cost.
>
> All depends on how it will impact planning on other
> orders.
>
> Rick
>
> --- OTMSIG <otmsig (AT) otmfaq (DOT) com> wrote:
>
> >
> > I would be looking at rate quality factors for
> this scenario. I have
> > used them in a few implementations and they should
> work fine for what
> > you are looking to achieve.
> >
> > I am not sure that routing rules were ever
> designed to accomplish this
> > kind of operational planning scenario.
> >
> > An alternative, if you know that each order coming
> out of a location
> > should be shipped with a specified service
> provider, is to enforce
> > that as a constraint on the order release. You
> could do that with a
> > Direct SQL update agent at the time of order
> release / order base
> > creation.
> >
> >
> > --
> > bmj_23
> >
>
------------------------------------------------------------------------
> > bmj_23's Profile:
> > http://www.otmfaq.com/forums/member.php?userid=227
> > View this thread:
> > http://www.otmfaq.com/forums/showthread.php?t=270 ([SOLVED] Using Routing Rules)
> >
> >
> > You are receiving this mail as a subscriber of the
> Oracle
> > Transportation Management SIG List Server. This
> list is provided by
> > Solution Beacon, LLC for the Oracle Transportation
> Management SIG to
> > facilitate distribution of issues and topics
> related to Oracle
> > Transportation Management. If you do not want to
> receive future mail
> > from the list, send email to
> majordomo (AT) solutionbeacon (DOT) net with the
> > words "unsubscribe otmsig" (without
> > quotes) in the body of the email.
> > If you need help, please contact
> > mweiss (AT) solutionbeacon (DOT) com.
> > Thank you!
> >
>
>
> You are receiving this mail as a subscriber of the
> Oracle Transportation
> Management SIG List Server. This list is provided by
> Solution Beacon,
> LLC for the Oracle Transportation Management SIG to
> facilitate
> distribution of issues and topics related to Oracle
> Transportation
> Management. If you do not want to receive future
> mail from the list,
> send email to majordomo (AT) solutionbeacon (DOT) net with the
> words "unsubscribe
> otmsig" (without
> quotes) in the body of the email.
> If you need help, please contact
> mweiss (AT) solutionbeacon (DOT) com.
> Thank you!
>
>
>

You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate
distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig"
(without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!

You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!

#6 (**permalink**) June 7th, 2007, 08:20

Hi All,

My personal thanks to Marnie, Rick, and bmj_23 for taking time out and
helping me with this scenario. The discussion gave me insights about the
ways we can achieve this in OTM. I will work on these lines.

Regards,
-Salil

-----Original Message-----
From: owner-otmsig (AT) solutionbeacon (DOT) net
[mailto

wner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of
Marnie.Schultz (AT) kraft (DOT) com
Sent: Thursday, June 07, 2007 9:10 AM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: RE: Using Routing Rules

Right. This idea is in conjunction with the last suggestion in the
previous email. After the parameter is set, this set up does have the
desired effect, and it's done without maintaining Rate Factors.

-----Original Message-----
From: owner-otmsig (AT) solutionbeacon (DOT) net
[mailto

wner-otmsig (AT) solutionbeacon (DOT) net] On Behalf Of Rick v100
Sent: Wednesday, June 06, 2007 10:32 PM
To: otmsig (AT) solutionbeacon (DOT) net
Subject: RE: Using Routing Rules

you would need to turn on planning parameters for OTM to consider rates
at all geo-hierarchies for that to work. OTM out of the box (at least
prior to 5.5) took most specific lane over the more generic.

Rick

--- Marnie.Schultz (AT) kraft (DOT) com wrote:

> To take the last suggestion one step further, and this may or may not
> work for your business, is looking at the geographical hierarchies of
> the rates in question. If the more expensive rates have a more
> specific geo hierarchy (you determine the hierarchy as well), they
> will be chosen over the less expensive rates. It's easier to maintain

> and trouble shoot later.
>
>
>
> Marnie Schultz
> Logistics Operations - Center of Excellence*Kraft Foods Global,
> Inc.*(60

285-6229*Marnie.Schultz (AT) Kraft (DOT) com
>
>
>
> -----Original Message-----
> From: owner-otmsig (AT) solutionbeacon (DOT) net
> [mailto

wner-otmsig (AT) solutionbeacon (DOT) net] On Behalf
> Of Rick v100
> Sent: Wednesday, June 06, 2007 8:28 PM
> To: otmsig (AT) solutionbeacon (DOT) net
> Subject: Re: Using Routing Rules
>
> There are several ways in OTM to solve this problem.
> You could specify the carrier on the leg in the
> itinerary, you could use
> rate factors, you could set up the planning
> parameters to look at other
> factors besides cheapest cost.
>
> All depends on how it will impact planning on other
> orders.
>
> Rick
>
> --- OTMSIG <otmsig (AT) otmfaq (DOT) com> wrote:
>
> >
> > I would be looking at rate quality factors for
> this scenario. I have
> > used them in a few implementations and they should
> work fine for what
> > you are looking to achieve.
> >
> > I am not sure that routing rules were ever
> designed to accomplish this
> > kind of operational planning scenario.
> >
> > An alternative, if you know that each order coming
> out of a location
> > should be shipped with a specified service
> provider, is to enforce
> > that as a constraint on the order release. You
> could do that with a
> > Direct SQL update agent at the time of order
> release / order base
> > creation.
> >
> >
> > --
> > bmj_23
> >
>
------------------------------------------------------------------------
> > bmj_23's Profile:
> > http://www.otmfaq.com/forums/member.php?userid=227
> > View this thread:
> > http://www.otmfaq.com/forums/showthread.php?t=270 ([SOLVED] Using Routing Rules)
> >
> >
> > You are receiving this mail as a subscriber of the
> Oracle
> > Transportation Management SIG List Server. This
> list is provided by
> > Solution Beacon, LLC for the Oracle Transportation
> Management SIG to
> > facilitate distribution of issues and topics
> related to Oracle
> > Transportation Management. If you do not want to
> receive future mail
> > from the list, send email to
> majordomo (AT) solutionbeacon (DOT) net with the
> > words "unsubscribe otmsig" (without
> > quotes) in the body of the email.
> > If you need help, please contact
> > mweiss (AT) solutionbeacon (DOT) com.
> > Thank you!
> >
>
>
> You are receiving this mail as a subscriber of the
> Oracle Transportation
> Management SIG List Server. This list is provided by
> Solution Beacon,
> LLC for the Oracle Transportation Management SIG to
> facilitate
> distribution of issues and topics related to Oracle
> Transportation
> Management. If you do not want to receive future
> mail from the list,
> send email to majordomo (AT) solutionbeacon (DOT) net with the
> words "unsubscribe
> otmsig" (without
> quotes) in the body of the email.
> If you need help, please contact
> mweiss (AT) solutionbeacon (DOT) com.
> Thank you!
>
>
>

You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate
distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig"
(without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!

You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate
distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig"
(without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com

You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!

oliver · #7 (**permalink**) June 7th, 2007, 21:01

Hi,

if it is always just S1 for the particular SRC-location, wouldnt it be the easiest solution to constraint the location to the service provider ? So only allow that dedicated SP to work with the location....

Rgds
Oliver