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.

Comments:

Hi, Thanks for the information. I am using Oracle 12.1 version. I can not see the Generate WSDL button in Integration repository. How can I make that button visible so that I can go ahead with WSDL. Regards Adish Jain

Posted by Adish Jain on August 19, 2009 at 06:38 AM IST #

Hi, Its really a nice article. We have lot of information around SOA but above gives a very simplified view of the information. Thanks for putting it together! Regards Rohit

Posted by Rohit Motiani on January 21, 2010 at 12:16 AM IST #

Hello Adish, Generate button is assigned to Integration Repository Administrator (UMX|FND_IREP_ADMIN) role. Please assign the role UMX|FND_IREP_ADMIN to the user you are logged in as to see Generate button. Also, not all interfaces in Integration Repository are service enabled. Only PLSQL, Concurrent Programs, XML Gateway are service enabled and so you can generate Service artifacts. Thanks Vijay

Posted by vijayakumar.shanmugam on March 19, 2010 at 11:58 AM IST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Straight from Oracle EBS Integrated SOA Gateway and EBS Adapter Development Team.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today