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.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old January 30th, 2008, 15:54
Junior Member
 
Join Date: May 2007
Posts: 19
Thanks: 1
Thanked 2 Times in 2 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
miks is on a distinguished road
OTM Integration with Ocean Carriers

Hello all,

Has anyone out in the forum had experience in setting up OTM to integrate with the major Ocean carriers? My focus is on Ocean Export only.

I'm looking to initially obtain status information. My questions are, which carriers will integrate with OTM? How timely is the data? How clean is the data? What are the specific events most carriers will provide?

Any insight, or shared experiences, (or nightmares) would be greatly appreciated.

- Mike
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old February 7th, 2008, 21:58
Junior Member
 
Join Date: Oct 2007
Location: Leuven - Belgium
Posts: 14
Thanks: 1
Thanked 4 Times in 4 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
rvhaaster is on a distinguished road
Send a message via AIM to rvhaaster
Re: OTM Integration with Ocean Carriers

Hi Mike,

I do have experience in integrating OTM with Ocean carriers via the portals INTTRA and GTNEXUS. The list of carriers linked to the portals can be found on the portals' websites.
Part of our integration is receiving status messages from the carriers. For both portals we receive them as EDIFACT IFTSTA messages.
In general it's working ok and the six messages that you should get from all carriers are:
- Gate Out Empty
- Gate In Full
- Vessel Loaded
- Vessel Unloaded
- Gate Out Full
- Gate Out Empty
Timing of the messages is something else. So far we have seen that we only received Gate Out Empty after vessel had sailed. In this case it was due to a restriction in carrier systems which prevented sending GOMT before booking had reached a certain status. So I wouldn't count on receiving status updates real time and in the correct order.

Rob van Haaster

MavenWire Europe
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old February 8th, 2008, 11:07
Junior Member
 
Join Date: May 2007
Posts: 19
Thanks: 1
Thanked 2 Times in 2 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
miks is on a distinguished road
Re: OTM Integration with Ocean Carriers

Thanks for the insight Rob,

A few questions for you. Is the timeliness of the data an operational problem, or an electronic communication problem. In other words, if I went to look up a shipment manually on the carriers web site, would I see the shipment there?

The second question, typically tracking is done by container. How have you related the status information you receive back to an actual shipment in OTM?

Thanks in advance for your responses.

- Mike
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old February 8th, 2008, 12:47
Junior Member
 
Join Date: Oct 2007
Location: Leuven - Belgium
Posts: 14
Thanks: 1
Thanked 4 Times in 4 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
rvhaaster is on a distinguished road
Send a message via AIM to rvhaaster
Re: OTM Integration with Ocean Carriers

Hi Mike,

The timeless of data may both be operational or electronic. It's depending on the port infrastructure whether statuses are processed straight away or not. The electronic reasons we've seen were that carrier systems were not able to pass on the events although they were avaialbe.
But you can track on carrier websites as long as you know booking nr or container nr; we haven't seen any problems there.

You're right, all the status messages are container based and they contain the container number, booking number and, if available, bl number. We've chosen for an approach where shipments in otm are updated with container id by means of shipment event entered via GUI, at time when actual loaded quantities are confirmed. Then incoming status messages are linked to the shipment by using an integration saved query based on container nr. When no shipment is found, the status message is staged and processed later when a shipment with that container number is available.

Hope this explains,

Rob
__________________
Rob van Haaster

MavenWire Europe
www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old February 20th, 2008, 05:10
Senior Member
 
Join Date: May 2007
Posts: 101
Thanks: 21
Thanked 4 Times in 4 Posts
Groans: 2
Groaned at 0 Times in 0 Posts
Rep Power: 2
krishna.kk is on a distinguished road
Re: OTM Integration with Ocean Carriers

ROb,

Can you explain in detail how do you link the container number with the shipment do you use reference Quailifer .

When a shipment is built in OTM in the second tab of the shipment(Equipment) there is a feild called Shipment equipment does this feild contains the Container number .

Rgds
kishore
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old February 21st, 2008, 09:39
Junior Member
 
Join Date: Oct 2007
Location: Leuven - Belgium
Posts: 14
Thanks: 1
Thanked 4 Times in 4 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
rvhaaster is on a distinguished road
Send a message via AIM to rvhaaster
Re: OTM Integration with Ocean Carriers

Hi Kishore,

We're entering container number during Dispatch advice (shipment event) against a shipment refnum. Agent workflow is then updating the s-equipment with the container nr, which will appear in shipment on equipment tab / eqmtn nr.
You can use shipment actuals screen as well to update shipment with equipment.


Rob
__________________
Rob van Haaster

MavenWire Europe
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 rvhaaster For This Useful Post:
krishna.kk (February 21st, 2008)
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
OTM 5.5: Partial Tendering and Change of Carriers ianlo Planning 11 July 25th, 2007 20:05
Ocean Legs in OTM Rick v100 Email List Archive 0 February 9th, 2007 08:41



All times are GMT. The time now is 14:11.
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