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

Assign Rate to SAW without re-calculating transit times


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

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old February 27th, 2008, 20:45
Junior Member
 
Join Date: May 2007
Location: Seattle, WA
Posts: 5
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
spistolpete is on a distinguished road
Send a message via MSN to spistolpete
Unhappy Assign Rate to SAW without re-calculating transit times

Hi everyone,

Question for you all: How can I rate a SAW when a shipment actual is received without re-calculating transit time? I've looked at the properties and planning parameters and can't find anything that looks promising. Maybe I missed something?

Background: We receive a Shipment As Work on a standard Actual Shipment XML via integration from our 3PL. The shipment indicates the actual service provider along with the actual departure time from the first stop as well as the estimated arrival for the downstream stops. These are all multistop shipments. Along with a lot of other data vaildation, our automation agents perform the "assign rate" action to the shipment. Unfortunately this also recalculates the transit times and updates/overwrites the estimated stop arrival times received on the SAW. I tried the "recalculate cost" action, but it doesn't give me the rates back. I do want these estimated times to be updatable from subsequent status updates, just not recalced when trying to rate on initial receipt.

In addition to receiving SAWs we also do our own shipment planning and tendering for other order types in this same domain.

All feedback is most appreciated.
Thanks,
Pete
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old February 28th, 2008, 00:40
Member
 
Join Date: Dec 2007
Posts: 87
Groans: 1
Groaned at 1 Time in 1 Post
Thanks: 5
Thanked 16 Times in 16 Posts
Rep Power: 3
james_foran is on a distinguished road
Re: Assign Rate to SAW without re-calculating transit times

Hello,

WE have also had this issue. To resolve it, set the IS_FIXED_ARRIVAL and IS_FIXED_DEPARTURE in the SHIPMENT_STOP table using an DIRECT SQL Statement to "Y"

This should fix your issue.

Best of luck.

Regards,

James
Toll
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
Appointment Manager Slot Times bfolan Planning 2 July 13th, 2009 10:45
Calculating Shipment Volumes eorlandi Planning 11 February 26th, 2009 03:19
Calculating Provincial Taxes slimjim30215 Settlement 4 January 2nd, 2009 04:50
Loading Service Times JayVal Data Loading 9 August 1st, 2008 05:29
Transit Public holidays bob_romijn Planning 0 February 15th, 2008 07:47



All times are GMT. The time now is 07:02.
Copyright © 2006-2009, 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