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

It’s been a while since my last post, but it doesn’t mean that projects and new discoveries were not happening…let’s just say that blogging was slow, I hope to re-take it into my daily routine. Now let’s get in business!

One of the areas that I’ve been working for the past few months is exploring the various approaches in which E-Business Suite customers can start using ADF for implementing requirements like mobile interfaces, reporting, security, etc.  Through a series of entries, I’m going to cover these scenarios and hopefully get your feedback (YES, you the reader), on what additional use cases you would like to see covered in the future.

In this first article we are going to start from the basics, describing a simple, but yet very common use case: how can you display EBS data the Web 2.0 way using the ADF Faces Rich client components.  The use case here would be for example if you are looking to create report that uses data visualization and a nicer look and feel to present the data.

Disclaimer: In the following sample I’m using the Oracle E-Business Suite database Vision Demo which is available from the EBS installation media.

Part 1 – Accessing the Data

Oracle E-Business Suite provides its own security implementation and various ways to access the business data through APIs and interfaces that leverage its security model. These are the preferred ways to access EBS data, and we will explore some of them on future entries.

For this use case, we are going to access the database directly using the APPS user which has access to the entire database, which is one of the reasons why you should only access the EBS as read-only. Modifying the data directly could corrupt the E-Business Suite data information and it is strongly discouraged.

image

After I establish my connection to the database, I create a read-only view object that is based on a query to the database and I expose this data to the UI. Also within the view, I create a find by clause, based on a bind variable, to display the data filtering capabilities of ADF.

I can test my business model by executing the application module.

image

Part 2 – Creating the UI

Once I’ve tested my business services, I can create ADF UIs to display the data in a browser. For example, you can use the data visualization graphs to create interactive dashboards/reports, maps to display geographic data.  You can even create mobile-enable pages that support multi-gesture actions for devices such as the iPad.

image

You can download the sample application from here. I leave you with a video that shows you step-by-step how to implement the above application.

Oracle ADF - E -Business Suite Integration - Database Access

Comments:

Many of your image attachments don't exist.

Posted by John Johur on May 21, 2012 at 03:08 PM PDT #

Juan, do you happen to know of any system integrators that have devloped iPad applications for entering time and expenses into an iPad app that then "syncs" to Oracle Time & Labor and Oracle iExpense applications?

Posted by guest on July 25, 2012 at 02:19 PM PDT #

Hi,

Not, I haven't heard of integrators that have developed such application/integration to E-Business Suite. However it would be a nice use case to develop.

Thanks

Juan Camilo

Posted by guest on July 31, 2012 at 11:21 AM PDT #

How to create a full fledged custom mobile app to interact with EBS? If the UI part can be done using ORacle ADF Mobile, how will it integrated with EBS in terms of BOTH reading and writing data from/to EBS? Can you please tell me the architecture to be used for a custom mobile app for EBS?

Posted by Divya on August 07, 2012 at 10:09 AM PDT #

Dear Juan,
Thank you for sharing such a nice information. My question is that, how can I integrate custom developed application with Oracle EBS?

Regards
Aziz

Posted by Aziz on September 12, 2012 at 04:53 AM PDT #

Divya,

For such requirement. I would say REST is the way to go, ADF Mobile in this case is another UI that access the data from E-Business Suite. The challenge is that you require additional processing in order to retrieve and send data from ADF to E-Business suite.

See the article in the series that explains the implementation of JAAS from ADF to EBS.

In terms of architecture you don't require anything extra apart from the regular pieces that are part of any ADF application.

JC

Posted by Juan Camilo Ruiz on September 26, 2012 at 10:32 AM PDT #

Aziz,

Check out MyOracle support Document 974949.1. It contains a section on implementing the above scenarios on Java EE applications. Which indeed has certain differences with implementing it on ADF.

JC

Posted by Juan Camilo Ruiz on September 26, 2012 at 10:35 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

me
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:
Search

Archives
« July 2014
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