otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


Integration and Data Mapping Integrating OTM / G-Log with external and legacy systems - including XML, WebServices, SOA, ESB, BPEL, EDI and Oracle's Fusion.

Tags: ,

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old March 6th, 2008, 23:57
Junior Member
 
Join Date: Aug 2007
Location: Atlanta, GA
Posts: 12
Thanks: 2
Thanked 1 Time in 1 Post
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
itnole is on a distinguished road
New Locations thru Integration?

Hello,

I have a scenario where a Customer will create new Addresses on an Order and use the same Location Id repeatedly (e.g., when a new Walmart opens). When the Order Release is sent to the OTM the Ship To Location may already exist in OTM, however, with a different Address. The system needs to check the Address on the Order Release against the Address on the Master Location using the Location Id and if different create the Location with a new Location Id. Is this possible via an Agent or will the logic have to be performed outside of OTM? Any assistance would be greatly appreciated.

Thanks.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old March 7th, 2008, 03:47
chrisplough's Avatar
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 816
Blog Entries: 7
Thanks: 53
Thanked 199 Times in 121 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to chrisplough
Re: New Locations thru Integration?

Hello,

There are a lot of ways to skin this cat. Personally, I'd put the logic in the integration engine to grab the locations related to an Order Release and pass them into OTM as UI (insert update), so you can choose to do them either with a new location ID or simply update the existing one -- based on your needs.

You can do a lot in OTM via Agents, but often those hacks end up causing performance bottlenecks, if you're not careful. As a result, I try to use the most efficient tool for the job -- the integration engine is a much more efficient at this.

Hope this helps.

--Chris
__________________
Chris Plough
MavenWire

www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to chrisplough For This Useful Post:
itnole (March 8th, 2008)
  #3 (permalink)  
Old March 10th, 2008, 11:08
Junior Member
 
Join Date: Jun 2007
Posts: 20
Thanks: 0
Thanked 5 Times in 5 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
oliver is on a distinguished road
Re: New Locations thru Integration?

Hi,
as Chris said, the easiest way is to have the locations as part of your transorder xml with an "UI" flag. The advantage is you dont need to create any additional workflow around it and there's a lot of implementations that use it this way so theres plenty of people with experience around...

Cheers
Oliver
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old March 10th, 2008, 23:49
Junior Member
 
Join Date: Aug 2007
Location: Atlanta, GA
Posts: 12
Thanks: 2
Thanked 1 Time in 1 Post
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
itnole is on a distinguished road
Re: New Locations thru Integration?

Thanks for the feedback Oliver. Simply setting the TransactionCode to UI will not solve my problem since it will change the Location Address on existing Orders to the new Address which will not be correct. As Chris stated the best place to handle this rule would be in the Integration Layer.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
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
Air shipment - between two non-airport locations Pankajkum Planning 1 February 29th, 2008 04:37
Integrating OTM with RTLS (GPS locations) rj5316 Integration and Data Mapping 5 January 24th, 2008 20:31
Using Via Locations vs Interim Locations joecallan Planning 4 September 4th, 2007 09:13
Operational Locations in Shipment Planning samuellevin_mavenwire Planning 1 August 17th, 2007 15:15



All times are GMT. The time now is 23:43.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


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