E-Business Suite and APEX installation

Before doing the integration of Oracle Application Express (APEX) with E-Business Suite (EBs) you need to have both environments installed. The Oracle white paper talks about the installation of APEX, but not about installing E-Business Suite.


The white paper states; the prerequisites for the solution given are:

• Oracle E-Business Suite 12.1.3 or above
• Oracle E-Business Suite Patch 12316083
• Oracle Database 10.2.0.3 or above
• Oracle Application Express 3.2 or above

The first thing I needed was an E-Busisness Suite environment. Oracle provides some VM Templates for E-Business Suite 12.1.3. I wanted a complete demo system, like for example the HR schema in the Oracle database or the Sample Application in APEX. The VM Template for E-Business Suite includes the Vision demo.

I never installed EBs before, so I did some research how to do that. Finally I didn't proceed with installing E-Business Suite on our servers, as MCX was happy to provide us with a complete Oracle E-Business Suite 12.1.3 Vision installation on their servers. The version of the underlying Oracle database is 11.2.0.2.0. I also asked them to apply patch 12316083.

APEX needs to be installed on the same Oracle database as the Oracle E- Business suite database server.
We went with installing the latest version of APEX at the moment: APEX 4.1.

Installing APEX is not that hard, basically running some scripts. The only bit you have to be careful with is the choice of web listener. APEX supports three web listeners: mod_plsql, EPG and the APEX Listener.
The mod_plsql gateway is disabled by default by EBs R12, so you shouldn't go with that. The EPG is not recommended either as it will add additional load on the database server, so the best choice would be the APEX Listener. The APEX Listener is the recommended choice in any circumstance anyway, regardless of EBs. (on a related note; I'm giving a presentation about my experiences moving to the APEX Listener at OGh and ODTUG.)

So after installing APEX and using the APEX Listener on an EBs configuration, the architecture looks like this:

So now all the prerequisites are met and we can concentrate on the real integration part in the next post.

Previous related posts:

• APEX and E-Business Suite integration

APEX and E-Business Suite integration

For a couple of years now companies like for example Popay integrate APEX with E-Business Suite.

The learning curve of APEX is not that high, so people with a (technical) E-Business Suite background should be up and running in no time.

In April 2011, Oracle released a whitepaper how to Extending Oracle E-Business Suite Release 12 using Oracle Application Express. Before, although it worked, you were a bit on your own incase you had issues, with the whitepaper things changed, so now you can call Oracle support as well.

In the next days I will share my experiences trying to get up-to-speed with integrating APEX with Oracle E-Business Suite. My background with Oracle E-Business Suite is limited, but I know a lot about APEX and that whitepaper should get me a big step further in integrating with E-Business Suite.


On the 15th of February, the APEX and E-Business Suite SIGs of OBUG (Oracle Benelux User Group) hold a half day (FREE) seminar about this integration too. So if you want to see this integration live or you want to hear from companies who are successful in it, come and join us. You find the agenda below:

SQL Developer Application Express Reports

There are some useful reports in SQL Developer that give you an insight in your APEX applications.

Click on the Reports tab in SQL Developer and open the Application Express folder. There are many reports, for example the Application Statistics you see below.

In the first grid you see all the applications of your workspace (linked to the schema you are logged in as). If you click on an application, the detail tabs load.

Below you see another report - Workspace > Activity Summary

In APEX you have a lot of statistics about your application too (see below screenshot of the Monitor Activity screen). 

If you want to navigate across applications, the SQL Developer reports are really useful as it's very fast to navigate. Both APEX as SQL Developer have their strengths. If you can't find the information you need, you can also write a query yourselves based on the APEX dictionary.

APEX-Challenge.com statistics November

Below you find some statistics of the APEX-Challenge for November. If you want to make fun and play the APEX Challenge too, you can register (or login) here.

Summary for Oracle Application Express Weekly APEX Quiz

Played between 5 November 2011 and 12 November 2011
Total # of players: 149
Total # of answers submitted: 149
100% correct submissions: 8
Average % correct: 60

5 November 2011: Leverage the APEX data dictionary views to answer questions about your application.
166 Players ♦ Avg. Correct: 60% ♦ Avg. Time: 202 seconds ♦ Rating: 4 stars

Summary for Oracle Application Express Weekly APEX Quiz

Played between 12 November 2011 and 19 November 2011
Total # of players: 142
Total # of answers submitted: 142
100% correct submissions: 15
Average % correct: 56

12 November 2011: The question shows how to correctly pass values using page items within branches and some of the limitations.
156 Players ♦ Avg. Correct: 57% ♦ Avg. Time: 129 seconds ♦ Rating: 4 stars

Summary for Oracle Application Express Weekly APEX Quiz

Played between 19 November 2011 and 26 November 2011
Total # of players: 141
Total # of answers submitted: 141
100% correct submissions: 33
Average % correct: 76

19 November 2011: To be aware of the functions and procedures contained in the APEX_UTIL package and other APEX Packages
145 Players ♦ Avg. Correct: 76% ♦ Avg. Time: 131 seconds ♦ Rating: 4 stars

If you want to see more questions, you find the library of previous questions and answers here.

APEX-Challenge.com

A few months ago we (APEX Evangelists) launched the APEX Challenge, a weekly quiz where you get a question about Oracle Application Express. Next to the fun of answering the questions and see your rank, you will hopefully learn something.

To make it a bit easier for the APEX community, to find the site, we looked at a specific url for the APEX Challenge.

Before you always had to go to the PL/SQL Challenge and take the APEX quiz from there, which you can still do, but now we enabled http://www.apex-challenge.com too.

We also have the apexquiz.com domain, so my question now is: which domain do you like most?

• stay at plsqlchallenge.com
• go to apex-challenge.com
• go to apexquiz.com

Tell us what you like... In a few weeks we will redirect the domain permanently.

If you have suggestions to make the APEX challenge/quiz better, please share with us too.

Thanks so much.

OBUG Benelux Connect 2012

On April 24, 2012 the Oracle Benelux User Group (OBUG) is organizing for the 5th time in succession, and in close collaboration with Oracle, OBUG Benelux Connect.

Possibly you attended in the past and you wish to present your customer case at the upcoming OBUG Benelux Connect 2012 conference. OBUG offers you the ultimate possibility to share your personal experience with other Oracle customers within the Benelux.

OBUG Benelux 2012 will be held at the MECC in Maastricht, the Netherlands. This is an excellent venue that provides its guests with the very latest amenities in a strikingly professional ambiance. The MECC is located in Maastricht, 10 minutes from Maastricht Central Station with train connections to Amsterdam and Brussels and a 3 minute walk from the train station Maastricht-Randwyck. Maastricht is a very popular destination for congress visitors, because it is such an intimate place and the city has much to offer.

“Extend your Horizon”

Extend your Horizon is the theme for OBUG Benelux Connect 2012.

The strength of OBUG Benelux Connect is the customer cases presented by our members and other Oracle customers: Learn from peers to maximize the value of your business-critical applications and technology. In over 40 sessions, speakers will share their experiences and business solutions with delegates in different streams, which gives them the possibility to investigate other products, extending their horizon. There are streams for Applications (Oracle eBS, Peoplesoft, Siebel, JD Edwards, Primavera), Technology (DBMS, JDeveloper/ADF, APEX, ...), Middleware (BPEL, SOA, EAS, ...) and Intelligence (Hyperion, OBI, GRC, ...).

The crowning touch is that the Oracle user experience team will fly in from the USA again to conduct several onsite User Experience Sessions, where delegates have the ability to contribute to and influence product direction and design for Oracle’s next-generation products.

CALL FOR PRESENTATIONS

OBUG is looking for end-users, project leaders, implementers, IT and functional managers, CIO's to share their experience with Oracle products in a 45-minute presentation – (slides in English, presentations preferably in English).

If you can make a valuable contribution to the success of our conference, please complete the online submission form on the OBUG website before December 9th, 2011.

If you have any questions, please contact Chris Coolen, Executive Director Oracle Benelux User Group, as soon as possible by e-mail or by phone +31620677597.

The organization will make a selection from all contributions based on main criteria such as quality and diversity. Also membership of the OBUG, user or partner, will be taken into account.

Speakers will receive a notification of our decision in week 2, 2012.

Hope to see you there.

Vote for Martin @ODTUG board

Last Oracle Open World Martin (Giffy D'Souza, left on the picture) told me he was running for the ODTUG board and without a doubt, I told him I would support him.

I know Martin for some time now; we first met in 2008 when we did a project for the company he worked for at that time. From the very first moment I appreciated his personality and technical skills. Over the years Martin became more active in the APEX community; on his blog he shares his experiences, he helps people in the forum and presents at different Oracle conferences.

In the beginning of the year I nominated him to become an Oracle ACE which was accepted. He not only got that recognition, he also got the best presentation award at ODTUG's conference this year. Hopefully 2011 will bring him one more award... a place in the ODTUG board.

I hope the whole APEX community shares my feelings when I say: "Vote for Martin and get him in the board!". Being APEX as one of the main tracks at ODTUG I think it only makes sense to have an APEX representative in the board and I can't think of a better person than Martin. His personality makes the difference!

You can read more about Martin's campaign and his reasons running for the board on his blog.

All the best Martin! I hope you make it.

APEX Meet-up OOW 2011

On Tuesday we had our 6th APEX Meet-up at Oracle Open World (OOW).

It was another great time to have some fun and chats with other people developing and using Oracle Application Express applications.

This is just one of the picture, you find more pictures here.

As there were so many people we didn't have one picture with all of us. Some also came in later... it started with grabbing two tables, but at the end we filled half of the bar :-)

If you were at the APEX Meet-up and have some other pictures, please send them to me and I'll add them to the album.

Special thanks to OTN, ODTUG and the APEX Development team to sponsor the meet-up. Although we were with many people, the costs for drinks and appetisers where covered by the sponsorship! Thanks again.

APEX in the Cloud

With today's announcement of the Oracle Database Cloud, it also means Oracle gives a strong message towards the APEX community.

Oracle Application Express (APEX) will be included in the Database Cloud. If you look at the features of the Database Cloud, for development it's all APEX and web services (through the APEX listener).

Before we had (and still have) apex.oracle.com where you could try APEX for free, but couldn't install any production applications on it. Now with the Oracle Database Cloud you have a paid alternative for all production applications. You can obviously use it for development and test too.

The other interesting thing is that there are productivity apps available... it's some kind of an APEX app place which you can install for free.

It looks like in the future also partners can offer their apps on there.

Probably in the next days and weeks we hear more about all the Oracle cloud... one piece that is missing it looks like is pricing.