3 Replies Latest reply on Dec 13, 2012 11:47 AM by AHS

    Queries regarding creating Web Services in Oracle EBS 11i[Workaround found]

    Sujoy
      Hi,

      We have an E-Business Suite 11i installation(11.5.10.2). In our implementation we are using some of the public APIs to insert & update data in EBS tables. Earlier this was done by calling the required PL/SQL procedures through dblinks.
      Now, we need to do the same by using Web Services. That is we need a Web Service which can be invoked from a different application(SAP) and the Web Service in turn will call the APIs.

      I am new to Web Services/SOA and as far as I could understand from reading the documentation, we need the following:

      1. Install Oracle 10g Application Server with BPEL Process Manager ONLY(Oracle AS Adapter will be installed as part of BPEL PM. The Oracle AS Adapter will connect 10gAS to EBS)
      2. JDeveloper to create and deploy the BPEL process.

      I have a few questions here:

      1. Are the above two points the only prerequisites for what I want to achieve? Do I need to install anything else?
      2. How do I expose the created Web Service? I mean how will the 3rd party application invoke this Web Service?

      Answers and/or links to helpful documents awaited.

      Regards,
      -Sujoy

      Found an alternate and more cost-effective solution. Turns out that the SAP PI/XI engine can use JDBC to connect to the Oracle DB. SAP PI/XI will host the Web Service and will internally access the API through a JDBC connection.

      Edited by: Sujoy on Feb 3, 2011 7:41 PM

      Edited by: Sujoy on May 16, 2012 6:49 PM