Monday Feb 16, 2015

Tutorial: Publishing EBS 12.2 PL/SQL APIs as REST Services

Oracle E-Business Suite Integrated SOA Gateway provides REST and SOAP-based web service interfaces for public PL/SQL APIs registered in the EBS Integration Repository.  Here is a video tutorial that walks you through the process of deploying our seeded PL/SQL APIs as REST services in EBS 12.2.4:

Title page for ISG video tutorial

What is in this tutorial?

This step-by-step video tutorial walks you through the following:

  1. Search API in Integration Repository
  2. Deploy API as REST Service
  3. Create Grants for REST Service
  4. Invoke EBS REST Service (in JSON message format)
  5. Verify the result in EBS

This tutorial is recommended for integration architects, developers and implementers working on Oracle E-Business Suite integrations. The steps mentioned in this tutorial apply to Oracle E-Business Suite Integrated SOA Gateway R12.2.3 or R12.2.4 instance configured for REST Services (using My Oracle Support Doc ID 1311068.1).


Related Articles

Friday Dec 19, 2014

Preparing Your Customizations for EBS 12.2

EBS 12.2 comes with Online Patching, a fresh new user interface, updated EBS product modules, and new mobile apps.  If you've customized your EBS environment or are using third-party extensions from other vendors, you'll need to ensure that they work with EBS 12.2.

EBS 12.2 New Home Page screenshot

Review the updated development standards

Coding standards, OA Framework capabilities, and, of course, database object development standards  have all been updated in EBS 12.2.  Making your extensions and customizations work with Online Patching is crucial.  Check this comprehensive guide:

Also, if you're interested in taking advantage of the latest user interface (UI) enhancements in EBS 12.2.4, check this Note:

Check your file, data model, and seed data dependencies

The following tools generate detailed reports of the differences between a specific EBS release for files, tables, and seed data. You can drill into the E-Business Suite Technical Reference Manual (eTRM) for details on the database model, database objects, and their relationships, too.

Verify your third-party extensions and tools

Contact your third-party software providers to confirm whether they have updated their EBS extensions or tools to be compatible with EBS 12.2.  This is critical for extensions or tools that are tightly-coupled with the E-Business Suite, i.e. those extensions that modify EBS tables directly. 

Another option is to check whether your Oracle partner has put their software through the Oracle Validated Integration program for EBS 12.2.

Review Guidance for Integrating Custom and Third-Party Products With Oracle E-Business Suite Release 12.2 (Note 1916149.1).  

Related Articles

Wednesday Nov 26, 2014

Oracle EBS Adapter for Oracle SOA Suite 12c Now Available

Oracle E-Business Suite Adapter for Oracle SOA Suite 12c (12.1.3) is now available for use with the E-Business Suite.  Previous releases of this product were called Oracle Applications Adapter for Oracle SOA Suite.

Architecture diagram for EBS Adapter for SOA Suite

You can use the Oracle E-Business Suite Adapter for Oracle SOA Suite to integrate EBS 11i, 12.1, and 12.2 with external systems.  The EBS Adapter allows you to build bidirectional standards-based real-time integrations with the E-Business Suite.  The Adapter supports JCA and web service standards for creating service-oriented applications (SOA). 

What's new in this release?

  • Adapter configuration reports: You can now view Adapter configuration reports in Oracle Fusion Middleware Control. 
  • Flexfield support for Open Interface Tables:  In addition to its existing support for PL/SQL APIs, this release provides flexfield support for Open Interface Tables by displaying flexfield data and mapping if configured in Open Interface Tables at design and run time


Related Articles

Wednesday Sep 10, 2014

Invoking JAVA APIs via REST in EBS 12.2

Oracle E-Business Suite Integrated SOA Gateway (ISG) introduced PL/SQL as RESTful webservices in EBS 12.2.3.  EBS 12.2.4 expands that functionality further, allowing Plain Old Java Objects (POJO) / Java Beans to be published as RESTful web services using ISG. This new Java API REST service provides support for both GET and POST verbs.

What is POJO?

POJO stands for Plain Old Java Object. It is a Java object which does not implement any framework-specific interfaces such as Spring, Hibernate, JDO, or EJB. POJOs allow applications to be decoupled from infrastructure frameworks.

Prerequisites for Using Custom Java API as REST service in ISG

The following tasks needs to be performed to use custom Java API as REST services:

Custom Java API steps

Custom Java APIs are configured and deployed on the application tier.  For more information, see Section 5, "Deploying Custom Application Tier Objects" in this document:

Java REST API Lifecycle

Java REST API lifecycle

Java API REST services follow the same lifecycle as PLSQL rest services. Once the custom classes and ILDT loader files are uploaded, you are ready to use Java APIs as REST services from the Integration Repository.

You can find the newly uploaded Java API in the Integration Repository using the new “Java Bean Services” Interface Subtype :

Java Bean Services Interface Subtype

Select GET, POST, or both based on your requirements. Provide a service alias and deploy the service.

Voila! the service is ready to be used.

Java Web Service Details

What’s more in a Java API rest services?

Java API REST services support GET and POST methods. GET requests can be invoked as Uniform Resource Identifiers (URI) from any browser.  The invocation process is simple, user-friendly and quick.

URI Format:

http://<host>:<port>/webservices/rest/<Service Alias>/<rest method name>/[<key-param>]?queryParam=paramValue[&....

Example :

Get all employees reporting “Mark ”, location “CA”


Key Features of GET

  • GET requests can be cached
  • GET requests can be bookmarked
  • GET requests remain in the browser history

GET requests should not be used when dealing with sensitive data.

Related Articles

Wednesday Jul 10, 2013

How to Define Table-Validated Lists of Values in Web ADI

I am pleased to announce a new video tutorial on defining table-validated Lists of Values using the Oracle Web Application Desktop Integrator (Web ADI).  One of the common requirements for List of Values in a Web Application Desktop Integrator spreadsheet is to display user-friendly values in a desktop-based spreadsheet but upload a corresponding identifier or code to the E-Business Suite. You can learn how to do this in this new tutorial.

Using the List of Values component with Web ADI

Oracle Web Application Desktop Integrator supports Oracle E-Business Suite’s user interface components such as List of Values (LOV) in spreadsheets. In a Web Application Desktop Integrator spreadsheet, a List of Values can be displayed as a pop-list or as a standard Search and Select view. A table-validated List of Values is a type of List of Values that not only displays set of values from a table, but also ensures that the value uploaded to Web Application Desktop Integrator Interface is valid. 

The Desktop Integration Framework allows you to create custom desktop integrators for Web Application Desktop Integrator in E-Business Suite Release 12. You can define table-validated List of Values components for data uploaded from spreadsheets to the Oracle E-Business Suite.

What is in this tutorial?

This step-by-step video tutorial walks you through the following:

  1. Prepare Database Objects
  2. Create Custom Integrator
  3. Define Table List of Values Component
  4. Associate Table List of Values Component to Interface Attribute
  5. Define Layout for Integrator
  6. Preview Integrator
  7. Verify uploaded data

Your feedback is welcome

This is our first video tutorial and we're very interested in feedback.  Please post a comment here or drop us an email directly with your thoughts.


Related Articles

Wednesday Feb 06, 2013

Using Oracle Label Security with Oracle E-Business Suite

Most security administrators know how to use E-Business Suite responsibilities to manage access to data and functionality.  The majority of EBS customers will never need anything beyond those standard capabilities. Some organisations may need specialised security to complement the EBS responsibility model. Oracle Label Security may appropriate for certain specialised requirements.

Oracle Label Security example diagram

Oracle Label Security allows administrators to classify every row in a table, ensuring that access to sensitive data is restricted to users with the appropriate clearance level. OLS can be used to enforce regulatory compliance with a policy-based administration model to support custom data classification schemes for implementing “need to know” access. Labels can be used as factors within Oracle Database Vault command rules for multi-factor authorization polices.

Supported but not certified

It is possible to use Oracle Label Security with the E-Business Suite.  Custom OLS policies will -- by design -- change the end-user behavior of EBS.  It is possible for an OLS policy to break EBS, so we can't offer the standard technology certification in this case.   What is certified is "the approach" of using OLS to implement custom security policies over EBS relational data.  We do not certify specific versions of OLS, nor do we certify specific OLS policies.

From a support perspective, we treat OLS policies like any other EBS customization, namely:

  • We can only issue EBS patches for issues that can be reproduced in environments without custom OLS policies.
  • If you report an issue that can't be reproduced in vanilla, uncustomized environments, our default guidance will be to disable the custom OLS policies.
  • We cannot review your OLS policies or make recommendations on how to create custom OLS policies.

How do I define OLS policies in EBS environments?

This rather-elderly Note explains techniques for adding OLS policy initialization logic to EBS session initialization.  Although this Note is written specifically for Oracle9i Label Security and EBS 11i, the techniques documented here remain valid today to later database and EBS releases:

Related Articles

Tuesday Oct 02, 2012

New Whitepaper: Primer on Integrating with EBS 12 with Other Applications

Oracle E-Business Suite offers several integration points and a variety of integration technologies. While a given integration point may be available through various technologies and products, it is important to select the best approach for your specific integration requirements. I am pleased to announce the publication of a new white paper that can help with this:

Overview of EBS integration technologies

This whitepaper reviews integration strategies for Oracle E-Business Suite applications that are available today. The intended audience is solution architects, integration consultants, and anyone else interested in learning about integration options with Oracle E-Business Suite.

The white paper outlines the following enterprise application integration styles:

  • Data-centric integration
  • Integration through native interfaces
  • Process-centric integration
  • Event-driven integration
  • B2B integration
  • Integration through web services 

The white paper also discusses Oracle E-Business Suite application layer products and technologies that address the specific needs of each of these integration styles. It concludes with criteria for selecting the appropriate integration-related tools and technologies for your requirements.

Attending OpenWorld 2012?

We have two sessions covering Oracle E-Business Suite integration. Please join us to hear more on this subject:

  • CON9005 - Oracle E-Business Suite Integration Best Practices ( Tuesday, Oct 2, 1:15 PM - 2:15 PM - Moscone West 2018)
  • CON8716 - Web Services and SOA Integration Options for Oracle E-Business Suite ( Thursday, Oct 4, 11:15 AM - 12:15 PM - Moscone West 2016)

 Related Articles

Monday Aug 06, 2012

Oracle E-Business Suite Personalizations Course Now Available

Oracle University logoI am pleased to announce a new training course titled "Oracle E-Business Suite Personalizations".

This Oracle University course is now offered as a 5-day class in either the Classroom Training (ILT) or Live Virtual Class (LVC) format. The course can be found under the E-Business Suite Tools and Technology Training category.

The course is a hands-on lab-intensive offering, and is intended for Application Developers, Functional Implementers, Support Engineers, and Technical Administrators. The course's objective is to give you insights into the rich and upgradable personalizations that Oracle E-Business Suite offers. You will also learn how to setup flexfields to capture information relevant to a business and personalize the user interface (UI) to suite a business need or a user preference for both OA Framework-based and Oracle Forms-based products.

You'll get the following hands-on experience in this course:

  • Work with Key and Descriptive Flexfields
  • Use Value Sets and Validation Options
  • Perform OA Framework Personalizations
  • Perform Form Personalizations
  • Work with Custom Programs and Help Systems
  • Work with Data Loader Applications

For more information regarding the course, please see the full course description, schedule, and other relevant information at the Oracle University website.

Finding other ATG courses and training materials

The catalog of all ATG training materials is available in this blog's Webcasts and Training section. If you have any questions or comments, feel free to email Bill Sawyer (Senior Manager, Applications Technology Curriculum) at BilldotSawyer-AT-Oracle-DOT-com



« June 2016