Another way to integrate with E-Business Suite from APEX is through Webservices.
You could setup a complete BPEL and SOA environment or you can do it a bit simpler.
First you start by going to the EBS Integration Repository. I found it useful to view by Interface Type as then I could select XML Gateway Map.
For the different products inside EBS you find the different gateways. Most of them have a WSDL.
I won't give a complete run through demo as I'm currently working with HR and I didn't see an XML Gateway for that. Nevertheless I will tell you how I would do it.
In APEX go to Shared Components > Logic > Web Service References.
Create a new Webservice based on a WSDL (the one you selected from the EBS Integration Repository)
And follow the wizard from there. You don't need to search the UDDI, you can just copy the WSDL location. Once the wizard is finished I tend to create a new page (form and report) based on this Webservice so I don't need to create the possible parameters/items manually etc.
Finally I customise the page to fit my needs. That should be it... (in theory)
2 comments:
I'd be interested to see if you could get it working. Every time I've ever used a SOAP-based web service in APEX, I've had to do a manual reference with the SOAP envelope. I don't know what it uses for parsing, but it must expect a very specific format.
I think SOAP support is one of most poorly functioning areas in APEX. A lot is moving toward rest, but not everything.
This is very interesting post.
Post a Comment