New Oracle APEX Presentations on YouTube

I met Chris Ostrowski at KScope 12 in San Antonio, he was actually in my session about the APEX Listener. During my presentation he recorded the entire presentation, not only my voice but also the screen.

A few days ago he send me an email to say he put mine, and the other sessions he recorded, on YouTube.

Here's a list of the sessions he recorded:

• Oracle Application Express 4 Error Handling Enhancements
• Oracle Application Express and JQuery
• Oracle Application Express and Websockets
• Oracle Application Express - Why Not Google It
• Building Mobile Web Apps With Oracle Application Express
• Clean Up PLSQL Oracle Application Express Code
• Developing Oracle Application Express Applications for the Cloud
• Dynamic Actions in Oracle Application Express
• How Complex Can Oracle Application Express Applications Get
• Mobile Dashboards with Oracle Application Express
• Moving to the Oracle Application Express Listener
• Practical Uses for Web Services in Oracle Application Express
• Zen and the Art of Mobile Development with Oracle Application Express
• Get The Look and Feel You Want In Your APEX Apps
• RESTful Web Services with APEX

So if you didn't see some sessions and want to get an idea what they were about, you can watch them now online. I find it scary to hear myself talking, not really how I imagined it ;-)

Update August 24th, 2012: the videos are (temporary?) unavailable.

PEOUG - LAOTNTour - 4

Arriving at the airport in Peru is different... immediately many people (taxi drivers) start to ask if you need a taxi, they even follow you, not really something I like.

I stayed in the same hotel the conference was held, which was nice. Lima surprised me in many ways, I didn't expect to see so many US chains in Peru for example.
The city has also many new buildings and it seems they are still doing a lot of constructions. A bit outside the big city there are really nice argeological sites. As I only had to be at the airport in the afternoon today, I made a stop at Pachacamac before noon.

Oh and about the food, no meat anymore the last two days, seafood instead. There are some very nice places in Lima (Alfresco and Pescados Capitales).

The conference itself had a really good turnout. About 170 people participated in it.
The organizer told me APEX wasn't that known in Peru, that is why they asked me to do an APEX overview presentation. When I asked the people who had experience, only a few hands showed up, so what the organiser told me seemed to be true.

The people were listening carefully, in the beginning maybe a bit skeptical as they didn't know what to expect, but the people became more and more enthusiast the more I talked and showed the power of APEX. During the presentation I didn't get that many questions but after it people couldn't stop asking. Even further on during the day people had more questions, talking to them makes me believe APEX will be more used in the future.

My next presentation was building an application live. The people were very much involved, we covered reports, forms, charts, dynamic actions, many shared components, cascading select lists and so on. Time flew by and before I realised the next speaker was standing next to me for his presentation. Working with APEX let you forget the time :-)

I start to feel the follow-up of flying, a different environment every two days, meeting many new peoples, delivering presentations, checking in and out of hotels. So after the conference I just stayed in the hotel and tried to get some rest.


Today I'm flying to Santiago, Chile. I'm actually trying to finish this blog post while I'm flying. It didn't take much or I didn't arrive in Chile until 5AM in the morning! I guess just like many airlines, LAN airlines who flies me from Lima to Santiago was overbooked and I was the unlucky one... and thinking that I arrived 3 hours before my flight in the airport! They offered me money and a place on the next flight which would leave Lima over midnight and arrive in Chile in the morning.
I didn't like that idea for a second, I was tired and need to give three presentations tomorrow. Finally they told me to wait for 2 hours and see if somebody didn't show up. So I did, I waited and waited. One hour before the flight I got green light, I could check in after all, had to stand inline for border control and started my run to the gate once through... I made it.

Tomorrow is the last stop of the LA OTN Tour in Santiago... the day after I will fly back home. Goodnight.

extending chart capabilities in APEX 4.1.x

In the Expert Oracle Application Express book I wrote a chapter about charting in APEX. At the moment of writing APEX 4.0 was production. Things changed over time (4.1.x) and will change further in the future (4.2). If you try to run my sample application in APEX 4.1.x, following charts won't work anymore:

• Manual Flash Chart with JavaScript
• Complex Dashboard with Actions (full AnyChart)
• Complex Dashboard with Events (full AnyChart)

The reason is, there is a change in the files the AnyChart team gave to Oracle. Just to be clear, the above examples go further than what the APEX wizards give you, so it's not really something we can complain about. 

The issue:

If you look at the code on page 143, this is what I wrote down:

The issue is the OracleAnyChart.swf file and the AnyChart.swf file. They are different than the files supplied in APEX 4.0 (which the chapter was based on). With every new release of APEX, AnyChart provides the latest chart engine, but this time, next to update the engine, they limited the file in what it can do (which they didn't do before). Oracle didn't license all the charts and the the full capabilities of the AnyChart engine so far. It remains to be seen which version we get with APEX 4.2. It should be AnyChart 6 with the support of HTML5 charts, so it might be that the other functionalities will work again too. 

Anyway as I started to get regular emails about it, I guess because more and more people are on APEX 4.1 now, I decided to blog about the different solutions you have to get my examples working.

The solution(s):

Just to be clear, the techniques I described to get most out of the charts in APEX are still valid, but for the three examples that didn't work anymore, you need to do an extra step.

- Option 1 - The solution is to not reference the APEX 4.1.x swf files, but reference swf files that do work. You can for example download the latest AnyChart files and copy them on your webserver, preferable in a different path than the APEX /images/ folder. I encourage you to copy them in your own path and leave the APEX folder as it is.

- Option 2 - As for some people it seems not trivial to do that, I created another solution by using the APEX Plugin mechanism. The plugin is basically a framework around the full AnyChart files. The only thing you have to do, is come up with a datasource (file, procedure, resource profile or REST service) that has the correct XML for the chart. You find the xml reference for AnyChart here.

The APEX plugin is of type region, so once you installed the plugin in your application, the only thing you have to do is create a new region on your page. I included three region attributes in the plugin; the width and height you want the chart to be and the datasource (procedure name).

In the above example I've a procedure called MANUAL_CHART in my TRAINING schema which will generate the correct xml. This is the same as the example in the book. The result looks like this:

As the datasource (procedure) gets called as an external process you need to make sure it has the correct grants.



You can see the above example live for APEX 4.1.x and for APEX 4.2 EA2. (note that depending when you read this post versions might have changed and url's might fail)

Note that I included a trial version of AnyChart, but you can easily replace that file. As APEX 4.2 is so close for production I also wanted to wait to see what files are distributed there, nevertheless I wanted to give you another solution to work around the issue in APEX 4.1.x. You can download the plugin here (which includes the procedure to generate the above chart).

Once APEX 4.2 is live I plan to revise the entire chapter as things changed a lot, not only in the APEX 4.2 wizards, but also by the new HTML5 engine of AnyChart.

On another note; the AnyChart Integration Kit we distributed before is end-of-live, instead we will provide plugins to extend APEX. At the moment we have following plugins:

• Bubble Chart
• Dynamic Action plugin to enable HTML5 charts for existing charts in APEX 4.1.x
• Framework Plugin (see above), which can produce any type of chart (dashboard, heatmap, ...)
• Full Gantt Chart Plugin with drag-drop functionalities
• AnyStock Plugin

Some of those plugins are payable, others we distribute for free, but we charge for support, upgrades, training and development of the charts you want. As the plugins are based on the AnyChart engine (which is not free), a lot will depend on what AnyChart provides to Oracle in APEX 4.2 if we can distribute the full AnyChart license with the plugins. Negotiating with AnyChart about a deal for the APEX community is postponed till after the APEX 4.2 release.

Hope you are back on track with charting by this update :-)

GUOB - LAOTNTour - 3

After Uruguay and Argentina, the next country in the OTN Latinoamerica Tour (South leg) was Sao Poalo, Brazil.

Just like the other countries it was also my first time here. I knew Brazil from the football and dance, but it surprised me in many ways. Already in the plane I couldn't believe my eyes... as far as I could see, I saw buildings, buildings and buildings! I didn't realize Sao Poalo was so big. There's a lot of contrast in new buildings vs older ones (or in other words between rich and poor).

Here's a picture from my hotel room

Now back to the conference. GUOB, the Oracle User Group in Brazil must be one of the biggest user groups in Latin-America.

The organization and turnout was great. Arround 300 people attended the conference. Although I didn't really understand the opening speach from Eduardo Hahn, as it was in Portuguese, I was amazed with what was happening. Suddenly the music started to play, people had to stand up and had to search something below their seat. During the music they also had time to say hi to each other, and much more. I found it an original opening, Brazil style if you like :-)

Here's a picture when Eduardo opened the conference (the people were not standing then, you can see a picture of that on Twitter)



The conference itself went great I think. I met many new people and during my talks I got many questions, on and off topic, but all APEX related. Thanks again to the translators and the English speaking people, without them it would have been very hard for me to understand the Portuguese.
It seems APEX in Brazil is starting to become popular, the people were definitely enthusiast about it.

Before and during the conference, the board of the User Group under the lead of Eduardo, made sure we had enough food... In Brazil it's all about barbeque and meat :-)
After the conference we went to Fogo de Chao; if you want to eat meat, you have to go there! They keep serving you until you say stop. Never seen the way they serve; they come with different kinds of meat and on one stick they have the different cookings available (well done, medium, medium rare etc.)
Here's a picture when they served Poalo from OTN.



As I had some time between Brazil and my next stop in Lima, I tried to visit Mercado Municipal de São Paulo on Sunday, but because it was fathers day, it was closed. I did go to the Parque do Ibirapuera, which I enjoyed very much. Water, green, piece... and in the background you see the big building rising.

Muito obrigado Eduardo, Patricia, Marcus and many others.

Talking, spending time, having fun and dinner with other speakers is really nice. Unfortunately for some of the speakers Brazil was their last stop. Craig, Dana, Francisco, Tom, Graham, thanks so much!  It will be different without you guys in the next countries. I truly enjoyed our time together.

AROUG - LAOTNTour - 2

My next stop in the LA OTN Tour was Buenos Aires, Argentina. Just like Uruguay it was my first time here. I found it very different from Uruguay... Buenos Aires is a big city, with many, many cars and huge drive ways. Here's a picture of the huge drive way.

The day before the conference we went to a famous restaurant, Las Lilas. You can see from the picture where they were known for! I enjoyed it very much, definitely a place I would go back to.

It was the first time the AROUG organised an Oracle event. Every start is difficult, but I believe the participants were very happy at the end. The Real Performance Tour and the LA OTN Tour presentations were at the same day, so the people had to pick. I had the opportunity to see a part of the Real Performance presentation by Andrew Holdsworth, Tom Kyte and Graham Wood. It's definitely something you have to see! Here's a picture just before the start. As you can see, they use three different screens: SQL*Plus and statistics on the left side, presentation in the middle and Enterprise Manager on the right. I was very interesting to see how the three presenters with their own expertise explained what was going on.

These events are also interesting to meet new people. It was the first time I met Craig Shallahamer and decided to watch one of his presentations about the buffer cache. I was impressed at the way he explained such a "hard-core" topic.  

I gave a presentation about APEX Performance and in another one, I build an application live based on what the audience requested. Although the native language of the people in Argentina is Spanish, many of them understand and speak English. Even the people listening to the translators (as I was doing the presentation in English), were actively telling me what they wanted to see :-)

I enjoyed my first time in Argentina... now up to Brazil where they speak Portuguese...  

APEX 4.2 EA: App Builder overhaul

This is the start of a series of blog posts about APEX 4.2 (at the time of writing EA).
APEX 4.2 looks completely different from any previous version of APEX.

The Application Builder became a "real" 2012 web application. Behind the scenes a lot of HTML5 and CSS3 features are used, which gives the App Builder a fresh look and feel.

It already starts when you login: the fonts and buttons are bigger and it's just crisper.

The home screen shows new icons, hovering over them highlight the selection in blue so it's clear where you are.

The Application Builder that shows the applications that you have in your workspace looks like this.

I'm unsure how you can change your own application to show another icon, but once Oracle allows to submit our own applications in the Packaged Applications section it will be possible I believe.

The new look and feel when you are in the pages overview of your application

The new theme of APEX itself is applied to all the wizards. The wizards are optimised, so you can get things done quicker than before and only relevant pieces are shown on the screen.

For example, creating a new database application takes not more than 3 clicks and can include an home page by default now.

Oracle APEX Listener 1.x vs 2.0

The new Oracle APEX Listener 2.0 Early Adopter is publicly available now.
If you compare it to the current production version these are the most changed or new features.

Configuration

APEX Listener 1.x: the configuration screen to tell the listener in which database APEX is installed

APEX Listener 2.x: either you configure the listener through command line

Command line configuration of the APEX Listener 2.x

or through SQL Developer 3.2 or higher (currently not publicly released yet)

Configuration through SQL Developer 3.2

So the web interface is gone in the APEX Listener 2.x... As you can see in the screenshot, you can now configure multiple databases. Before you had to configure multiple APEX Listeners; one for DEV, one for TEST, one for Production etc. Now you can just have one APEX Listener routing to the correct database.

Another new feature is that you can route multiple url's to different APEX applications.

Resource Profiles (aka RESTful Services)

APEX Listener 1.x; you define Resource Templates through the web interface

APEX Listener 2.x; you can now configure the RESTful Services through a patched APEX 4.1.1 or native in APEX 4.2. The following screenshot shows how it looks like in a patched APEX 4.1.1 version.



New in the APEX Listener 2.x is RESTful OAuth 2.0 integration.

New features

More configuration options.

Integration of ICAP virus scanner, so when a file gets uploaded to your database, even before it hits your database it can be scanned.

More features are there to come, for example integrated FOP support...

I hope you see that Oracle is putting a lot of effort in the APEX Listener... it fits in the proof of the additional features you get with the APEX Listener I mentioned in my previous post "Moving to the APEX Listener".

Moving to the Oracle APEX Listener

Are you already using the Oracle APEX Listener in front of Oracle Application Express (APEX) or are you still using Apache with mod_plsql as your webserver (or the EPG)?

This year I started to give a presentation why I believe you should move to the APEX Listener.

If you missed my presentation at OGh, ODTUG or UYOUG, I'll give this presentation again in Brazil and Santiago as part of the LA OTN Tour, at Oracle Open World (OOW) and at the UKOUG.

In the presentation I go briefly over the pros and cons of Apache with mod_plsql, the Embedded PL/SQL Gateway (EPG), but spend most of the time on the APEX Listener (hence the title).
After OOW I'll publish a whitepaper about this topic as well, so you can read it in full detail and have some test cases you can try in your environment.

Nevertheless I already wanted to blog about some points of my presentation and whitepaper, especially in the light of APEX 4.2 and the upcoming 2.0 version of the APEX Listener.

Background; before I wanted to move off Apache with mod_plsql (to the APEX Listener) there were two important parts I wanted to be sure of:

• is the APEX Listener as reliable and performant as Apache with mod_plsql and
• do I get at least the same features (or more) with the APEX Listener compared to the others

For the first point I can say we successfully run the APEX Listener now for 1,5 year in different environments. To name two; one environment is using Glassfish and the APEX Listener on top of Oracle Linux on the hardware of a customer and another one is running on our own server at Amazon, Oracle Linux and Glassfish with the APEX Listener with an Apache reverse proxy in front of it.

JMeter configuration

Performance wise I show in my presentation and whitepaper how you can test your own configuration with JMeter, so you have real metrics. Depending the test case I ran on my system, I got different results, but in general the APEX Listener was as fast or faster than Apache with mod_plsql.

Again you don't need to take my worth for granted, but test it out yourself in your environment by simulating your load with JMeter. How to do that you can read in my whitepaper or in this excellent post of Chris Muir (note that in APEX 4.1.1 you need to add some extra parameters to get it to work which are not described in the blog post).

On the second point; the features of the APEX Listener compared to the other choices, I can be short.

The APEX Listener will give you more features... even more interesting... if you are not using the APEX Listener from APEX 4.2 onwards, some functionalities for ex. RESTful Services won't work for you.

RESTful Services

At the moment APEX Listener 1.1.4 is the production version, but a few days ago APEX Listener 2.0 (EA) was released. You can read more about this release on Kris' blog. In my next post I will also  highlight the biggest differences between APEX Listener 1.x and 2.x.

Hopefully by this post I hope to trigger you to look at the APEX Listener a bit closer in the next weeks and months if you are not using it yet... 

UYOUG - LAOTNTour - 1

Currently I'm doing the OTN Latinoamerica Tour 2012 (South leg).

The first country we visited was Uruguay. It's currently winter here (whereas in Belgium it's summer), so the temperature is a bit lower (between 6-16 degrees Celsius), but it's still a lot warmer than the winter in Belgium!

Here's a picture taken from my hotel room... nice indeed!

Uruguay has some really nice views and buildings. This is the building the conference is held in.

The conference itself is very well organised. In Uruguay they speak Spanish, unfortunately a language I don't speak... but they did foresee translators, so real-time, people were translating during my presentation.
Many people didn't need the headphones as they could understand English as well. I do hope to learn Spanish one day, as I like the language.

There were many interesting presentations. As I was the only person speaking about APEX, it gave me the opportunity to see presentations about different topics.

I enjoyed the presentation of Tom Kyte about Big Data and Dana Singleterry about "Is ADF simpler than Forms?". Big Data is obviously the next big thing, I look forward to integrate that with APEX.
The demo's of Dana building ADF applications were interesting as well. ADF has many build-in components (graphs, pivot, panels, ...) you can use out-of-the-box. It was a while ago I saw an ADF presentation, and although I still find it a lot more complex than APEX, they made it a lot simpler and faster to build apps.

In the evening we went out with the speakers to a typical bar/restaurant from Uruguay. I want to thank the organiser of the event so much, and special thanks to Edel, Daniel and Nelson. Muchas gracias!

My OTN Latinoamerica Tour 2012 (South Leg)

At the moment I'm on my way to Montevideo (Uruguay) for the first country in a row at the OTN Latinoamerica Tour 2012 (South leg).

Francisco asked me already a few times, and finally this year I agreed visiting this part of the world. Already many thanks to Francisco and the whole team in Latin America for the invitation and the organisation. Reading Tim's post about the North leg, I'm sure it will be an amazing adventure for me as well, so I look forward starting this two week experience.

My schedule looks like this:

Montevideo (Uruguay): August 6th
- 11:30 12:15 Moving to the APEX Listener
- 14:30 15:15 Building an APEX Application Live
- 16:15 17:00 Debugging with APEX & SQL Developer

Buenos Aires (Argentina): August 9th 
- 12:00 13:00 Building an APEX Application Live
- 15:00 16:00 APEX Application Performance

Sao Paulo (Brazil): August 11th 
- 10:10 11:00 Moving to the APEX Listener
- 14:25 15:15 Debugging with APEX & SQL Developer

Lima (Peru): August 14th 
- 10:05 11:05 Oracle Application Express (APEX) Overview
- 13:30 14:30 Building an APEX Application (Live demo)

Santiago (Chile): August 16th 
- 09:30 10:15 Oracle Application Express (APEX) Overview
- 11:30 12:15 Building an APEX Application (Live demo)
- 14:20 15:05 Moving to the APEX Listener

I don't speak Spanish, but I do hope to meet and talk to many of you.
It will be my first time in any of those countries, but if it's as nice as the football they play, it must be great :-)

looking back at KScope 12 - KScope 13 info

Straight after KScope 12 I left on holiday, which meant I didn't find the time yet to get up-to-speed with blogging. Coming back a lot of work was waiting again and now I'm travelling again... I did want to finish this post first before getting onto other things.

KScope 12 was another great conference. Next to the great sessions and meeting up with people, the APEX development team showed the power of APEX 4.2 on the Sunday symposium.

If you didn't see APEX 4.2 yet, you can give it a try as the early adopter (v2) is ready to test. Although the 4.2 (instead of 4.1.1) doesn't sound like a big jump (in number), it is in my opinion. I'll come back to that in a series of posts about the APEX 4.2 version in the next weeks.

Back to KScope 12... it was my first time in Texas and it was an experience to say the least :-)
Seeing a rodeo, people with booths, heads and guns... many horses, also amazing meat (dinner at the range). It was great to be somewhere I never went before. Here's a picture when somebody asked to have a picture with the AE team at the range where the rodeo was held.

Update: Martin did an interview with me at KScope 12, where I give my view on the conference. You find it here.

If you missed KScope 12 not to worry, next year there will be KScope 13. KScope 13 will bring us back to 2008, when the conference was held in New Orleans as well. We all have many memories about it! It seems that in 2008 I blogged a bit more in detail (every day!) about the events than nowadays. For example the Tuesday post you find here.

I do remember the service day when we painted a school, the neckles you throw at the girls in Bourbon Street and also the many presentations I had to do at that conference. For the charts one I won the best presenter award, but there was also one on the last day; the shoot-out between APEX and ADF, which I did together with Lucas Jellema. I remember that was a hard one... and a topic I wouldn't do anymore today, maybe a comparison, but not a shoot-out :-)

Boubon street

One last thing I want to share, when you go to KScope 13, you should definitely try an "hand-granade"

Hand-grenade

Just know when to stop...

I know already many people who were there in 2008, who already booked their ticket for 2013 (yes registration is already open)!
KScope 13 is definitely worth going to, not only for the great content, but as you can see above also for the social part. Many great people, very nice location... see you there.

My view on APEX 4.2 EA (ready to test)

Things have been busy lately... now being at the ODTUG KScope 2012 conference I'll take the opportunity to do some more tweets and blog posts.

The last week the Oracle APEX Development team made a public APEX 4.2 EA available. You find it on https://apexea.oracle.com/i/index.html
You may also want to read this post to find more details about availability etc.

So what is new in APEX 4.2?

You find a description of all the new features here. 

The top 3 biggest things for me are arround:

• Mobile development
• HTML5 (themes, items, charts)
• Packaged applications

I'll go into more detail in some other blog posts later, but here are already some teasers.

1) An APEX app build by Marc Sewtz, it shows what you can build with the new Mobile Wizards in APEX 4.2.

2) HTML5 chart created by the wizard (based on AnyChart 6 HTML5 charts)

3) An overview of the Packaged Applications (productivity / business apps) that come with APEX 4.2. Soon we can write our own apps and have them included there...

Try APEX 4.2 EA out and give your feedback to the APEX Development team. APEX 4.2 is again a real nice release, so really worth to check out! The entire APEX Builder interface got a complete overhaul.

APEX Mobile in DG Tournament

Sunday night, playing arround with DG Tournament and JQuery Mobile...
After a couple of hours this is the result: http://m.dgtournament.com

The login screen, with the same authentication as the full website (http://www.dgtournament.com)
(you need to subscribe first on the full website, if you don't have a login yet)

When you are logged in, you will see a menu. For now I just added the persons bet ranking.
If I find some more time, I'll probably add a screen to see and update your own bets.

Clicking on the Bet Rank link will give you the ranking of the people with a nice search on top. 

I didn't include a screenshot, but you can also click on a person to get more detail about how many times they played, how many times they betted the correct score etc.

For the (APEX) people interested in how this was created...

Start with looking at the JQuery Mobile Quick Start Guide. For example to add that search on the screen it's super easy... just add data-filter="true" to your list and presto!
The full integration of jQuery Mobile with APEX (declarative; using wizards) is currently planned for APEX 4.2, but next to the manual way of using JQuery Mobile with APEX, you can already tell APEX 4.1 that you want to do mobile development as described by Marc Sewtz in following blog posts:

• http://marcsewtz.blogspot.be/2011/11/getting-started-with-mobile-in-apex.html
• http://marcsewtz.blogspot.be/2011/11/getting-started-with-mobile-in-apex_17.html

Making a mobile version of an APEX app is always fun :-) I only tried the app on my iPhone, so if anybody can try it on Android, WindowsPhone, Blackberry, ... I hope it looks good too.

Hope you enjoy this little mobile extension... at least now you can already see how your rank is without opening up the site on your iPad, laptop or desktop.

DG Tournament open for Euro 2012

Just a quick note to say I entered the matches of UEFA Euro 2012 in DG Tournament now, so you can bet on the games again (don't forget to add this tournament to Your Profile first after you login).

A new banner is on his way... To be honest, I didn't think of opening it up again for this tournament as Belgium isn't qualified, but obviously other countries did qualify ;-) and it sounds people looked forward to play again (looking at the messages I received).
And yes, I must admit, even when your own country doesn't play, it's more fun to predict a score with friends first and than watch the game.

Time goes so fast... It's already 6 years ago I created the initial site to bet on the WorldCup 2006!
If you want to read some more history on DG Tournament you can do that here. I didn't do any updates to the app this year. I did think of putting this app on the Oracle Public Cloud or make a mobile version of it to showcase the power of APEX 4.2 (and JQuery Mobile), but as those didn't go live yet, and I currently don't have that much spare time, I decided against it.

I didn't really foresee prices like I did before... it's all about honour this time!

If you are using Oracle Application Express, and you are in the top 3 ranked people, I'm happy to give away an Export Oracle Application Express books.

That the best may win!

Oracle APEX Plug-ins Competition

You have some Oracle Application Express (APEX) plug-ins written but didn't share them yet? or you plan on writing some new APEX plug-ins? Why not submit them to the APEX Plug-ins competition?!

You not only get the recognition of being an APEX plug-in developer, but you can actually win some prices too... and maybe even better, be the first 2012 ODTUG APEX Plug-in Developer of the year!

You find all the information and rules on the APEX plug-in competition page.

To get started on creating plug-ins it's always useful to look at existing plug-ins and steal with your eyes...

I look forward seeing your plug-in! Happy coding...

APEXBlogs reloaded

Since March 7th APEXBlogs.info didn't pick up new blog posts anymore.

Thanks for everybody mailing me, telling me or sending me feedback about the issue. It's nice that many people "missed" APEXBlogs... I'm sorry it took me some long to look into the issue.

Today I found some time to look a bit closed into the issue. Apparently in one of the blog posts somebody put a very strange character in. To fix my procedure I had to include following code:

So basically I replace that strange character with a space and everything worked again normally...

Over 20 new posts are included now in APEXBlogs, so happy reading again!

Apply APEX 4.1.1 Patch Set

Yesterday APEX 4.1.1 Patch set was made public. If you already have APEX 4.1 installed you can download patch number 13331096 from My Oracle Support.

If you are on a previous version of APEX you can download the complete install of APEX 4.1.1 from OTN.

I installed the patch today on my APEX 4.1 instances and it installed without a problem. It took not more than 5 minutes to complete the entire patch.

Two things to look for when you copy the images folder
- for Apache on Linux I used this command:
cp -rf patch/images /u01/ohs/apex/ (so without images folder)
- for the APEX Listener I used this command:
cp -rf patch/images/* /u01/app/glassfish3/glassfish/domain1/docroot/i (so without images folder)

When I first did the copy it included another images folder. If you go to your images folder and go into the themes folder you should find the new theme 24 folder. If you find it, than everything is copied ok.

Which brings me to; there is a new theme in APEX 4.1.1. Theme 24, the "cloudy" theme! This theme looks very nice and more 2012 (bigger fonts etc).
It would be great if Oracle would setup an official theme repository, like they did for plugins. Designing nice looking sites takes time and the web design "trends" change fast.


There was one other catch after applying the patch; some workspaces weren't accessible anymore. I got this error:

--
Workspace "" is inactive. Contact your administrator.
Contact your application administrator.
--

This was due to the way I created some of those workspaces in APEX 4.1.
Instead of going through the wizard I used the API to create the workspace:

apex_instance_admin.add_workspace(
  p_workspace_id       => v_workspace_id,
  p_workspace          => v_workspace,
  p_primary_schema     => v_primary_schema,
  p_additional_schemas => v_additional_schemas);

This worked fine before, but after applying the patch if you didn't run:

apex_instance_admin.enable_workspace('');

It doesn't work. Thanks to the APEX development team to diagnose the cause so quickly and come up with the solution. Patrick Wolf posted a script to fix any workspaces you may have with that issue.

Also don't forget to read about some possible changes of behaviour (depending compatibility setting) in the patch notes:

• Changes in Page and Region Caching
• Columns Used in Automatic Row Processing (DML) Processes

I definitely think it's good to apply this patch. I already applied some one off patches before for the urgent issues I was facing, but having this patch set brings you immediately to the latest and greatest!

Overview APEX -> EBS, next EBS -> APEX

In the previous posts I mainly focussed on getting information out of E-Business Suite and use it in my APEX application. This is especially useful for people using APEX.

Visually I see it like this:

Here is a complete overview of those posts:

Calling EBS Webservices from APEX

Using EBS Open Interface from APEX

Debugging EBS API calls in APEX

Updating EBS data from APEX using Triggers and APIs (3)

Creating EBS data from APEX using APIs (2)

Updating EBS data from APEX using APIs (1)

Querying EBS data from APEX using Views

E-Business Suite and APEX integration (overview)

E-Business Suite and APEX installation

I can imagine that people coming from the E-Business Suite are not that interested in creating stand-alone APEX applications, but they are more into creating an APEX page to extend EBS. They want to be in EBS, and in the menu some links will just open up some APEX pages. They want to see the information that is relevant at that time and have a seamless integration (so no extra logins etc).

I visualise that flow like this:

We can obviously use many of the techniques described in the other posts, but how does the authentication, authorisation etc work? Most of that is described in the Oracle white paper with a good example (starting at page 11). I might do some extra blog posts about that integration, but it will be in line with the white paper.

Calling EBS Webservices from APEX

Another way to integrate with E-Business Suite from APEX is through Webservices.

You could setup a complete BPEL and SOA environment or you can do it a bit simpler.

First you start by going to the EBS Integration Repository. I found it useful to view by Interface Type as then I could select XML Gateway Map.

For the different products inside EBS you find the different gateways. Most of them have a WSDL.
I won't give a complete run through demo as I'm currently working with HR and I didn't see an XML Gateway for that. Nevertheless I will tell you how I would do it.

In APEX go to Shared Components > Logic > Web Service References.

Create a new Webservice based on a WSDL (the one you selected from the EBS Integration Repository)

And follow the wizard from there. You don't need to search the UDDI, you can just copy the WSDL location. Once the wizard is finished I tend to create a new page (form and report) based on this Webservice so I don't need to create the possible parameters/items manually etc.

Finally I customise the page to fit my needs. That should be it... (in theory)