otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
MavenWire

Go Back   Oracle OTM / G-Log GC3 Community Support > OTM / G-Log - Functional Topics > Rating
Reload this Page

Best Software for Worldwide Distance Calculation


Rating Configuring and troubleshooting Rating and RIQ in OTM / G-Log.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old May 21st, 2008, 10:31
Senior Member
 
Join Date: Feb 2008
Posts: 116
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 13
Thanked 1 Time in 1 Post
Rep Power: 3
cspadola is on a distinguished road
Best Software for Worldwide Distance Calculation

We will have a need in the near future to manage shipments to worldwide locations, especially in the Far East and South America. The current distance and rating server we use is fine for our EU shipments but we will soon need something that can provide calculations for these new locations.

Can someone provide any feedback regarding different packages available that work with OTM? We have tested PTV World Map recently and find that not all distance and rate inquiries work, depending on the locations being asked for. This may be because the data in this software has not yet been updated but as it is the latest version and was wondering if other packages offer more reliable results.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old May 21st, 2008, 11:32
Senior Member and Blogger
 
Join Date: Nov 2007
Location: Drexel Hill, PA
Posts: 394
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 72 Times in 67 Posts
Rep Power: 3
nick.polites will become famous soon enough
Re: Best Software for Worldwide Distance Calculation

You can install PC Miler Worldwide and see if that works. I have installed it on one client but found you will need to create a new Geo Hierarchy and External Distance Engine as the one used out of box does not send the Country code over to PC Miler. Unless the country code is sent over you may get incorrect distances back from the distance engine.
__________________
MavenWire Hosting Admin
9 1/2 years of OTM experience
www.mavenwire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old August 18th, 2008, 18:20
Junior Member
 
Join Date: Sep 2007
Location: Kentucky
Posts: 11
Groans: 2
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
cstarks is on a distinguished road
Send a message via MSN to cstarks
Re: Best Software for Worldwide Distance Calculation

Nick,

For China, how was PC Miler Worldwide?

Thanks,

Chris Starks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old August 18th, 2008, 18:28
Senior Member and Blogger
 
Join Date: Nov 2007
Location: Drexel Hill, PA
Posts: 394
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 72 Times in 67 Posts
Rep Power: 3
nick.polites will become famous soon enough
Re: Best Software for Worldwide Distance Calculation

Not sure exactly how well it worked for the customer. Once I set it up I never heard a complaint after that

I know that you have to setup a new Geo Hierarchy because if you use the default one in OTM, it does not contain the country code in the call to PC Miler which sometimes can cause problems. If you do decide to implement it let me know and I'll dig up the document on what needs to be done.

Nick
__________________
MavenWire Hosting Admin
9 1/2 years of OTM experience
www.mavenwire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old August 18th, 2008, 18:35
Junior Member
 
Join Date: Sep 2007
Location: Kentucky
Posts: 11
Groans: 2
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
cstarks is on a distinguished road
Send a message via MSN to cstarks
Re: Best Software for Worldwide Distance Calculation

Thanks for the quick response Nick. I guess my question is more about the functional side - is it pretty similar to the US mileage package - ie does it cover all of China for mileage or is it only specific regions within that country?
__________________
Chris Starks
Deloitte Consulting

cstarks@deloitte.com
www.deloitte.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old August 18th, 2008, 18:36
Senior Member and Blogger
 
Join Date: Nov 2007
Location: Drexel Hill, PA
Posts: 394
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 72 Times in 67 Posts
Rep Power: 3
nick.polites will become famous soon enough
Re: Best Software for Worldwide Distance Calculation

I never got into the exact specifics so it may be better to contact ALK and find out.
__________________
MavenWire Hosting Admin
9 1/2 years of OTM experience
www.mavenwire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old August 18th, 2008, 18:41
Junior Member
 
Join Date: Sep 2007
Location: Kentucky
Posts: 11
Groans: 2
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
cstarks is on a distinguished road
Send a message via MSN to cstarks
Re: Best Software for Worldwide Distance Calculation

Ha... One step ahead of you on that one. I am waiting for a call-back on that, but I wanted to hear from an implementer. I'll post what we find out from ALK for everyone.

Thanks again Nick.
__________________
Chris Starks
Deloitte Consulting

cstarks@deloitte.com
www.deloitte.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old February 12th, 2009, 00:15
Junior Member
 
Join Date: May 2008
Posts: 8
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Power: 0
bman is on a distinguished road
Re: Best Software for Worldwide Distance Calculation

Hello Nick,

How can we call pc miler from within a stored procedure...?

We have a need to iterate through the stops on a shipment and retrieve miles from origin location to stop #1, origin location to stop #2, origin location to stop #3. We are not looking for distance traveled or drive miles. We want the miles returned as if it were 3 direct individual shipments.

thanks in advance...Brian
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Provincial VAT - Calculation enjoyOTM Settlement 5 January 16th, 2009 02:37
Distance from Previous stop calculation karthiktc Planning 3 June 5th, 2008 11:01
European VAT Calculation - Query vkthegreat Settlement 1 May 12th, 2008 14:44
volume calculation nikesh mohanlal Order Processing 4 March 24th, 2008 16:34
rouding up distance returned by external distance engine vn_karthik Rating 2 September 5th, 2007 17:46



All times are GMT. The time now is 12:08.
Copyright © 2006-2010, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44