« Gathering Stats for Workflow’s Queue Tables | Main | Invoking Web Service from Oracle Workflow process »

Native Services - EBS R12.1

Steven Chan posted a blog  which mentioned the presentation done by me and Neeraj.Chauhan in the last OOW’08.Continuing on the same thread, I would like to mention few basic and simple things in this blog.

Starting 12.1 release of e-Business Suite, you not only have Native SOAP based Services available, but also you can invoke external web-services which can be consumed by existing running processes in EBS. Let us go little deeper into this.

Native Services from EBS

From 12.1, Integration Repository allows you to generate and Deploy services for certain interfaces type by a click of a button. The interfaces which are supported on Integration Repository are PL/SQL api’s, XML Messages, Business Service Objects, Concurrent programs etc.

Here is a slide to explain it architecturally

 

native

The simple steps are:

  • Identify the public PL/SQL api you are interested in exposing as a service by searching in the Integration Repository.
  • Generate a Service (WSDL) out of it, by pressing the Generate WSDL button.
  • Deploy the Service by pressing Deploy button.
  • Grant the permission as who can access this Service.

You are all set. Use any industry client, and you should be able to invoke EBS PL/SQL api as services from outside.

Here is a blog written by my colleague Gautam Satpathy, who also works in the SOA Gateway team. It explains clearly how you can take a simple api like FND_PROFILE as a Web-Service and call it from outside.

Invocation of Services

If you are interested in invoking an external web-service from an existing Workflow process, OA framework page or from a Java program, all you need to do is define a Business Event, and create a Subscription of type “Invoke Web Service”. You can easily pass parameters to the called web-service, and take the output of the web-service back into your calling process.

Here is a slide to explain it architecturally

invocation

Again thanks to Gautam Satpathy for his blog which takes the previously generated FND_PROFILE api as a web-Service and calls it using the Invocation framework in EBS.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

About This Entry

This page contains a single entry from the blog posted on June 12, 2009 4:32 PM.

The previous post in this blog was Gathering Stats for Workflow’s Queue Tables.

The next post in this blog is Invoking Web Service from Oracle Workflow process.

Many more can be found on the main index page or by looking through the archives.

Powered by
Movable Type and Oracle