A consolidated One Off has been released for the Oracle E-Business Suite Integrated SOA Gateway 12.1.1. Details available on Metalink Note 815196.1.
This One Off addresses a number of bugs and also provides additional functionality.
Key Changes
Context Header Enhancements:
- Organization ID: The context headers for all services has been enhanced considerably. We now support Organization ID as an optional header field. This new header field is required for all services that are Organization sensitive.
- Parameter Name Changes (PL/SQL & Concurrent Programs): The Responsibility, Application & Security Group header parameter names have changed (more on this topic in a future post).
- Parameter Changes (Business Service Objects): The responsibility_name parameter has been modified to accept both the “Responsibility Name” as well as the “Responsibility Key” (more on this topic in a future post).
National Language Support:
The Integrated SOA Gateway has been enhanced to be NLS compliant. E-Business Suite web services exposed via the Integrated SOA Gateway can now consume SOAP messages in any of the languages supported by EBS. The context header contains a field where the language can be specified. Service response and error messages, if any, will be returned in the specified language. The user’s default language is used when no language is specified in the SOAP message.
Support for Security Grant on Overloaded Methods:
With this One Off, SOA Gateway administrators can now assign unique grants for individual overloaded methods to a specific user, user groups or all users. The Integration Repository UI has been enhanced to support this.
SSL-based Web Service Invocation over HTTPS:
Service Invocation Framework now supports SSL-based Web service invocation using Server Authentication method. When a client connects to a Web server securely via HTTPS, the server sends back its server certificate to the client for verification. Once verified, the client sends the data, encrypted, to the server. Server authentication allows the client to identify the server. Before invoking a Web service from a server over HTTPS (HTTP protocol over TLS/SSL), some manual setup tasks need to be performed to read SSL-based WSDLs and invoke SSL service endpoints.
Service Generation Backend Processing Support:
This is a brand new feature that allows SOA Gateway administrators to Generate web services on the EBS instance via a script. A standalone soagenerate.sh shell script is shipped with the One Off and can be used to generate PL/SQL, Concurrent Program & XML Gateway Map services from the command prompt.
Integration Repository UI Changes:
This One Off includes a few Integration repository UI changes. The most important one is to the Generate Service UI which prevents multiple, concurrent requests to generate the same service.
Documentation:
- Metalink Note 815196.1
- Oracle E-Business Suite Integrated SOA Gateway User's Guide (E12064-03, August 2009)
- Oracle E-Business Suite Integrated SOA Gateway Implementation Guide (E12169-03, August 2009)
- Oracle E-Business Suite Integrated SOA Gateway Developer's Guide (E12065-03, August 2009)
Existing Users:
Existing users of the Integrated SOA Gateway will have to Regenerate & Redeploy their web services after applying this One Off patch. This is required for the WSDL changes to the Context Headers (SOAHeader). This can be done from the Integration Repository UI. Please see the release notes for details.


No comments.