Friday May 23, 2014

Two Essential New Patches for EBS Release 12.2 AD & TXK Tools

We continue to release updates to EBS 12.2 technology stack (TXK) and Applications Database (AD) patching tools based upon customer feedback.  We released the first important set of updates in March and have just released another set of critical updates today.

If you are on Oracle E-Business Suite Release 12.2, we strongly recommend that you apply two newly-released patches at your earliest convenience:

Applying these on top of AD Delta 4 and TXK Delta 4 will bring you to the recommended codelevel for AD and TXK:

  • AD Delta 4 (Patch 17766337) + Consolidated Fixes (Patch 18491990)
  • TXK Delta 4 (Patch 17893964) + Consolidated Fixes (Patch 18497540)

Important: You must always keep your AD and TXK codelevels synchronized.

What Is a Codelevel?

Oracle E-Business Suite Release 12 patches are grouped into codelines. A codeline begins with a point release (for example, Release 12.0) and progresses to include all the patches created to maintain that point release.

Patches associated with codelines implement a set of features for a point release, and also provide fixes for that set of features. Such a unique set of product features for a point release is referred to as a a codelevel. You can think of it as the code you get when you apply a set of patches: in other words, it is defined by the patches that deliver it. Codelevels are cumulative, with each containing the initial set of features plus all the fixes created for that product.

Benefits of the Latest Codelevel

There are several important reasons you should adopt this latest recommended AD/TXK codelevel:

  • It includes a large number of fixes and improvements.
  • It includes new logic to detect a variety of configuration issues that might otherwise go unnoticed.
  • New patches to implement code fixes will only be appliable to the latest AD/TXK codelevel.
  • No code fixes will be created for earlier AD/TXK codelevels.

How Can I Get To the Latest Codelevel?

Installation instructions are here:

Related Articles

Friday May 16, 2014

A Primer on Oracle E-Business Suite REST Services

Oracle E-Business Suite Integrated SOA Gateway (ISG) was introduced in E-Business Suite (EBS) Release 12.1, as an infrastructure to provide and consume SOAP based Web Services. In EBS R12.2.3, ISG is enhanced to provide REST-based Web Services. 

What is REST?

REST stands for Representational State Transfer. It is an architectural style for distributed hypermedia systems. The term REST was introduced and described by Roy Fielding in 2000, in his doctoral dissertation - Architectural Styles and the Design of Network-based Software Architectures. This REST architectural style may be applied to web services. Note that REST is not a standard and its implementation often varies to suit application needs.

Using a PL/SQL API as a REST Service

E-Business Suite public PL/SQL APIs can be deployed as REST-based Web Services from the E-Business Suite's Integration Repository. One or more methods of the API can be selected to be exposed as functionally-secure REST resources. Each of these resources can be identified by an URI. These resources can then be manipulated by making HTTP request to the URI. As of R12.2.3, ISG supports POST HTTP Verb for REST Services. This feature is also available for custom PL/SQL APIs registered in the Integration Repository. 

PL/SQL REST screenshot

Unlike EBS SOAP Services, REST Services are deployed in EBS’s OAFM Managed Server. These REST Services do not depend on external Fusion Middleware components like Oracle SOA Suite. These are simple, lightweight REST Services suited for UI integrations and mobile applications.

Key features of EBS REST Services

  • Supports POST HTTP Verb
  • Supports XML and JSON message format
  • Described in WADL, XSDs
  • Supports HTTP Basic and Token based Authentication
  • Predeployed EBS Security Services 

EBS Security Services

EBS Security Services are a special group of predeployed REST services that provide authentication and authorization for EBS users. These include:

  • Login and Logout Service
  • Application Context Initialize & Retrieval Service
  • Access Control Service 

Security service screenshot

You can search for these services by selecting ‘Interface Subtype’ as Category and ‘Security Services’ as Category Value in More Search Options region as shown above.

I am looking forward to hear your feedback on Integrated SOA Gateway and REST Services. You can mail me at Rekha Ayothi Oracle email ID


Related Articles



« May 2014 »