[chrisplough]

Ganesh,

(1) Integration Option# 1:
EBS 11.5.9 integration with OTM 5.5 using Oracle Workflow, XML Gateway, Oracle Advanced Queuing (AQ) and Oracle Transport Agent (OTA).
Will this approach work?
CP> I'd recommend getting references from existing clients using OAQ with OTM. I'm only aware of 2 and each of them are looking at other integration solutions, since they've had a lot of problems with OAQ bugs and finding people strong enough to support them. Matter of fact, I was just helping a client out with a production issue around this till 3am on Tuesday. Nearly all OTM / G-Log clients are using HTTP posts to publish integration into OTM instead.
Any limitations (general limitations, limitations related to OS, web server, appserver etc)?
CP> Web Services is still maturing in OTM, so HTTP posts are your best option (sorry to sound like a broken record). You'll have to convert from whichever format to G-Log XML, so I'd recommend getting the GLog.xsd file from your OTM installation, to understand the scope of the transformation necessary. No other limitations, other than those I've already noted about the OTM app server.
Does this option require OTA on the OTM side too? (OR) Can we have BPEL at OTM and OTA at EBS?
CP> On the OTM side, you don't need OTA. Matter of fact, you can just use any integration technology that is capable of posting via HTTP to OTM. As noted earlier, I'd avoid using OAQ to post to the OTM DB directly.

(2) Integration Option# 2:
EBS integration with OTM using BPEL technology - Customizing out of the box EBS 11.5.10 BPEL logic and making it work for EBS 11.5.9 Family Pack I.
Will this approach work?
CP> Honestly, I don't know - simply because I don't know how the interfaces differ in EBS 11.5.9. Also, a lot of the integration (concurrent processes, etc) are installed via Oracle patches that are only available on 11.5.10.x. Since OTM has been integrated with nearly every WMS/OMS solution out there, I'm sure that there is a way to make it work, though it could require extensive customizations.
Any limitations (general limitations, limitations related to OS, web server, appserver etc)?
CP> You should utilize BPEL 10.1.3.3. Otherwise, no other limitations that I'm aware of -- save those mentioned about the OTM app server previously.
Any lessons learned?
CP> I highly recommend searching through these forums (especially this section) as there are many lessons learned about the EBS/OTM integration. The biggest lesson I can pass your way is that it isn't well supported and every client who has implemented it has required customizations to get it to match their business process. It's an okay template, but I don't consider it a full solution.

Hope this helps,
Chris