Jeff,
Thanks for the feedback. I can definitely agree with you -- we've had to do exactly the same with the 3 clients where we had to integrate EBS and OTM.
In addition to the customizations to meet required business functionality, some of the data touch points are cumbersome -- for instance to change the delivery time on a shipment, you have to go all the way back to EBS, make the change and then reprocess the delivery to update the Order Release in OTM. This can be a difficult business process for the client, especially those that are used to the functionality and user interface of OTM.
(Note: Having worked on OTM for so long, I'm definitely biased - I like the OTM interface MUCH better than the EBS forms interface, which I found confusing. I'm looking forward to playing with EBS R12 next month, though, to see how improved it is.)
We've had to make customizations to allow data changes in OTM, which get propagated back to EBS and allow the logistics planners to remain in the OTM screens for simple operations.
I haven't had to deal with 3rd party WMS modules at any of our clients yet. Please let us know how that goes -- I'm interested if it will work with the current integration and if you'll be able to use Fusion to handle some of that functionality.
Thanks for the suggestion on the additional forum. I expect the EBS / OTM integration to become a large area of interest, now that G-Log is part of Oracle. I want to see a strong interest from the community (read: enough posts) before adding another forum. For now, it's still the minority, with the bulk of OTM customers integrating with other systems (SAP, home-grown, etc). Please feel free to post here until it reaches critical mass
Thanks!
--Chris