Integrated SOA Gateway in Oracle E-Business Suite Release 12.2 - Part I

This blog is back from temporary hiatus while we were putting our best efforts behind R12.2 of Oracle E-Business Suite, which has been recently announced for general availability. Integrated SOA Gateway in R12.2 packs lot of punch for our customers. Firstly, we are leveraging the market leading Oracle Fusion Middleware 11G as Oracle E-Business Suite technology stack. Secondly, Integrated SOA Gateway leverages Oracle SOA Suite to provide SOAP webservices. 

One of the major advantages of leveraging Oracle SOA Suite is that ISG is now capable of supporting asynchronous webservice interactions for PL/SQL apis.

1222 Asynchronous Interaction for PL/SQL APIs

Although Oracle SOA Suite is used to provision webservices, the design-time or administration experience is quite seamless, as you can see in the above snapshot.

In the following posts I'll be discussing more about the webservices stack, ISG architecture etc. Meanwhile, the whole R12.2 documentation library is available here .


Comments:

Hi,

I need a quick input on whether to leverage the ISG services and the integration repository services installing and procurement of SOA Suite (middleware) is compulsory? Cant we leverage the services of ISG (Consuming and Publishing web services) without SOA suite license? Please clarify

Thanks,
Gowri

Posted by Gowri Shankar on February 05, 2014 at 12:28 AM IST #

Hi,

I understand this is not the right forum to discuss this but i need urgent help here

I need a quick input on whether to leverage the ISG and the integration repository services installing and procurement of SOA Suite (middleware) is compulsory? Cant we leverage the services of ISG (Consuming and Publishing web services) without SOA suite?

The requirement is that we want to see what Oracle Ebusiness suite offers on its own as the client doesnt want to purchase separate SOA Suite license.

Please clarify

Thanks,
Gowri

Posted by Gowri Shankar on February 05, 2014 at 01:18 PM IST #

Hi Rajesh,

I have two questions:

(a) When should Integrated SOA Gateway be preferred over using standalone SOA Suite (Fusion Middleware 11g) installation ?

(b) How does Oracle Applications adapter differ from using the Database adapter when invoking E-Business Suite APIs through services ?

We're experiencing some sporadic transaction integrity issues invoking E-Business Suite APIs from service hosted on standalone SOA/OSB environment. The issues have boiled down to support of global temporary tables (GTTs) over XA transaction. Since the GTTs are integral to functioning of the APIs, we have little control of changing that behaviour. Also, the txn has its source in a separate SOA Suite environment to E-Business Suite, so XA transaction happening is sort of a "given" condition.

We're running a SR currently with Oracle Support, if it is feasible for you to review that and suggest whether using adoption of SOA Gateway or Applications adapter can resolve the issues we're having ?

Thanks,
Rakesh

Posted by Rakesh Tripathi on April 04, 2014 at 07:09 PM IST #

I'm a bit confused on what is actually needed to utilize SOA with EBS R12.2.4. What I'm wondering is to utilize SOA do we require a SOA Gateway license or can we use the Integrated SOA in EBS to expose services to web applications.

I thought if the services were REST we didn't need anything beyond the Integrated SOA in EBS. If the services are SOAP than the SOA gateway would be needed. Is this correct?

Posted by Tim Sanger on April 09, 2015 at 08:26 PM IST #

"Cant we leverage the services of ISG (Consuming and Publishing web services) without SOA suite?"

"I thought if the services were REST we didn't need anything beyond the Integrated SOA in EBS. If the services are SOAP than the SOA gateway would be needed. Is this correct?"

In Release 12.2 of Oracle E-Business Suite, Integrated SOA Gateway (ISG) SOAP webservices have a hard dependency on Oracle SOA Suite and E-Business Suite Adapter. However SOA Suite is not a requirement for REST webservices available from ISG.

Posted by Rajesh on April 10, 2015 at 02:10 PM IST #

Rakesh, for your question - "(a) When should Integrated SOA Gateway be preferred over using standalone SOA Suite (Fusion Middleware 11g) installation ?" , please refer to the MOS Note Id 1494997.1 , which describes various usage scenarios of different integration technologies available with E-Business Suite.

Thanks

Posted by Rajesh on April 14, 2015 at 01:34 AM IST #

Are there any good books on integating R12 using SOA Gateway and use of BPEL and Human Task in E-Biz?

Posted by guest on April 22, 2015 at 12:47 PM IST #

Hi,

I have a very basic question on Integrated SOA Gateway. If I am exposing a PLSQL package as a Service , can I have explicit commits in my procedure.

I heard that ISG container does an implicit commit and hence we should refrain from issues explicit commits. If we cannot, then should we create the procedure as "autonomous transaction".

Thanks.

Posted by raj on May 01, 2015 at 06:47 AM IST #

"I have a very basic question on Integrated SOA Gateway. If I am exposing a PLSQL package as a Service , can I have explicit commits in my procedure."

There should not be any issue in having explicit commit within your procedure as long as you plan to use the procedure for webservice enablement using "only" ISG as the enabler. However as you rightly heard, ISG does an implicit commit as well. So all dmls done within your procedure will be committed automatically by ISG. Use of Pragma autonomous transaction is also fine.

Posted by Rajesh on May 21, 2015 at 12:40 PM IST #

Hi,

We have a requirement to use ISG. We are on Release 12.2.4. Do we need separate license to use it? Ebusiness 12.2.4 license does not cover ISG?

Thanks,
Mehabub

Posted by Mehabub Sheikh on May 26, 2015 at 02:12 AM IST #

Please clarify, do we need to buy license for Integrated SOA Gateway, or is it part of the EBS.

Posted by guest on July 10, 2015 at 06:12 AM IST #

"We have a requirement to use ISG. We are on Release 12.2.4. Do we need separate license to use it? Ebusiness 12.2.4 license does not cover ISG?"

"Please clarify, do we need to buy license for Integrated SOA Gateway, or is it part of the EBS."

ISG is integral part of EBS. There is no separate license for ISG as such. However, in Release 12.2 ISG has a dependency on SOA Suite & E-Business Suite Adapter (for SOAP Services only). Those are separate technology licenses, which you need to have. Please talk to your respective account reps for further licensing information.

Posted by Rajesh on July 10, 2015 at 01:00 PM IST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

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

Search

Archives
« August 2015
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
31
     
Today