| | Integration and Data Mapping Integrating OTM / G-Log with external and legacy systems - including XML, WebServices, SOA, ESB, BPEL, EDI and Oracle's Fusion. |  | 
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 | | | 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 | 
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 | | | 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 | 
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 | | | 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 | 
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 | | | 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 | 
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 | | | 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 | 
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 | | | 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 | | The Following User Says Thank You to rvhaaster For This Useful Post: | |  | | Thread Tools | | | | Display Modes | Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | |