Friday Nov 30, 2012

ADF and Oracle E-Business Suite Integration Series Index

I'm creating this entry with the purpose of keeping one page that lists all the past and future entries on the series of integration of ADF with Oracle E-Business Suite, you can access all the articles and reference information that resides in other places too. Also this would the one link that I can reference while presenting about this topic. Here is the list of individual entries from the series: Bonus Material:

If you have any further questions about integrating Oracle ADF and E-Business Suite - please post them on the ADF discussion forum on OTN.

Wednesday May 02, 2012

Securing ADF Applications Using the Oracle E-Business Suite SDK JAAS Implementation

In the previous post on the series of ADF integration with Oracle E-Business Suite,  I covered how to setup and use the Oracle E-Business Suite SDK for Java to create a data source for accessing Oracle E-Business Suite data from our ADF applications in read-only form.

In this post we are going to explore another feature of the Oracle E-Business Suite SDK for Java, the implementation of JAAS (Java Authentication and Authorization Services). Using this implementation we can use E-Business Suite users and roles to restrict access to specific parts of external Java EE applications. You can find a very nice explanation about this feature on the following post from the Oracle E-Business Suite Technology Team blog.

You will need to setup your runtime environment (WebLogic Server) and afterwards configure you ADF application to point to the right resources. Both steps are well explained in My Oracle Support Knowledge Document 974949.1. In this article I will provide a high level overview of the steps that are provided on the document, highlighting areas where it’s easy to make mistakes and hopefully these can help you to get everything working successfully.


First you need to set up the AppsDataSource on your WebLogic Server server in order establish the communication channel with the Oracle E-Business Suite instance. Follow the instructions from the document in the section Configuring AppsDataSource and Configuring AppsDataSource on Oracle WebLogic Server (WLS):


The second step is to create and setup a default realm on WebLogic that enables users and roles provisioning directly from E-Business Suite. In E-Business Suite users and roles are stored in specific database tables, so the new realm will make use of the AppsDataSource defined on the first step. All of the steps are described on the note in the section: JAAS Configuration for Oracle WebLogic Server When setting the realm you need to pay attention to the following steps; if not executed correctly they could cause problems later on:

  • External Authenticator: By default, WebLogic server doesn’t provide the external authenticator which is used to authenticate against E-Business Suite. During the AppDataSource setup you are going to use the fndtext.jar that comes with the patch from My Oracle Support, and you recompile it using the following command:

java -classpath /tmp/mysrc:$CLASSPATH -DMJF=/tmp/mysrc/fndext.jar -Dfiles=/tmp/mysrc

If the command is executed correctly and doesn’t throw any errors, on creating the new realm you will be able to select ExternalAuthenticator from the list of authentication providers.

  • DataSource: Another area where you  need to be careful  is at the time of specifying which datasource to use for the realm. Make sure the JNDI name that you have given the your AppsDataSource matches the one to be used by the realm.


After completing all the steps you should have 2 realms on your WLS, having the newest one as the default one.


ADF Application

An interesting aspect of the integration is that you can leverage ADF Security to use the E-Business Suite JAAS implementation without manually editing configuration files as is the case with Java EE applications.

Please be clear that all the E-Business Suite roles to be used in the ADF application need to be defined as Enterprise Roles. Also, you do not need to create users for the application given that all them would come from Oracle E-Business Suite. However, you could define application-specific roles, but those roles need to map one of the enterprise roles.

When you are ready to deploy make sure you uncheck all the options related to users and groups. You don’t need those.


Now your application should be working and authenticating against E-Business Suite.

Here is a video that shows an ADF Application using the E-Business Suite SDK for Java JAAS implementation.

Securing ADF Application using the JAAS Implementation of the Oracle E-Business Suite SDK for Java

Related Articles:
AppsDataSource and Java Authentication and Authorization Service for Oracle E-Business Suite

Friday Mar 09, 2012

Using the Oracle E-Business Suite SDK for Java on ADF Applications - The AppsDataSource

In my previous post we covered how to create an ADF UI that displays data from the EBS database in read-only form. In this article we will explore how you could use the Oracle E-Business Suite SDK AppsDataSource to enable access to the data from Oracle E-Business Suite to the ADF applications deployed on WLS.

The following sample uses the Oracle E-Business Suite database Vision Demo that is available from the EBS installation media.

Creating the E-Business Suite data source in WLS

The first step that we need to do is to create a data source that will be in charge of connecting the ADF applications with the E-Business suite database schema.

The E-Business Suite team has a Java SDK that has been available for some time now. Among its components are the AppsDataSource and AppsXADataSource which we can be use to enable access to the EBS APPS database schema through a much cleaner approach.

The instructions to access the Oracle E-Business Suite SDK for Java and to set up the AppsDataSource on WLS are well documented on My Oracle Support Knowledge Document 974949.1.

Once you are finished, you will have a new data source defined on WLS.


Setting up the data source  on your ADF application and deploying it to WLS

In order to make use of the data source, we need to edit the configuration of the Application Module so instead of using a JDBC URL it uses a the JDBC Data Source in WLS.


Now, before deploying the application to the WLS Server we need to make sure the EAR file doesn’t include direct reference to the project’s DB connection. For that we uncheck the option on the application deployment profile options.


And with that we can deploy and now our application will use AppsDataSource from the EBS SDK for Java to access the DB. This way E-Business Suite administrators don’t need to give away the APPS password to development teams, nor the ADF application have a reference to it.

Here a video that summarizes the entry.

Using Oracle E-Business Suite SDK for Java AppsDataSource on ADF

Friday Mar 02, 2012

ADF and Oracle E-Business Suite Integration Series: Displaying Read-Only EBS data on iPad

A quick extension to my previous post that presents some of the new multi-touch gesture support for iPad added in the new JDeveloper PS5 ( release.

Based on my previous demo,  the video shows you the real end user interaction when the same ADF application is opened from an iPad device. As an ADF developer you get these really cool features out-of-the-box. Here you have a very nice approach to build a simple and quick, mobile report based on E-Business Suite data, extending its current functionality.

Disclaimer: The following sample uses the Oracle E-Business Suite database Vision Demo which is available from the EBS installation media. Modifying the data directly could corrupt the E-Business Suite data information and it is strongly discouraged.

Displaying Read-Only Oracle E-Business Suite data on iPad

A blog that explores features, tips and tricks of ADF and JDeveloper by Juan Camilo Ruiz, Product Manager on the ADF and JDeveloper team
Follow me:

« June 2016