APEX 5.0 New Features Schulung

Unsere nächste Schulung hat APEX 5.0 New Features im Fokus. Diese findet im Dezember am 08. und am 09. in Bensheim statt. Wenn Sie auf diesen Link klicken, können Sie die Details anschauen und sich ggf. anmelden. Dieses Thema is sehr spannend und viele neue Features bzw. Änderungen kommen auf uns zu. Wir denken, dass Dezember der richtige Zeitpunkt dafür ist, damit anzufangen.

DOAG 2014 – Vortrag zum Thema: Dynamisches Arbeiten mit Grafiken in APEX

Mein diesjähriger DOAG Vortrag ist am letzten Konferenz-Tag  
20.11.2014 um 9:00 (Raum Istanbul)


Auf was könnt Ihr euch freuen?
Ich zeige einen Lösungsansatz mit dem man Grafiken dynamisch nutzen kann, ohne viel Programmieraufwand zu investieren.

Hafen mit dynamisch erstellten Booten und erweiterten Informationen.
In der Präsentation, die wieder eine APEX Anwendung sein wird, werde ich auf unterschiedlichste Beispiele eingehen und den Code im Detail erläutern.

Also sehen uns auf der DOAG!


Interested in Oracle APEX in Belgium and around? – join ORCLAPEX-BE Meetup

Over the last months different Oracle Application Express (APEX) meetups were initiated around the world. You can read a bit of background on how the meetups started on Dan's blog.

I think it's a great idea to have local meetups to meet other people working or interesting in APEX too. When you just start with APEX it's interesting to talk to other people how they got started. But equally for more seasoned developers it's a (more...)

APEX 5 New Substitution Syntax Features

You've probably all heard about XSS, a.k.a. Cross Site Scripting. One of the ways you make yourself vulnerable to XSS is by creating JavaScript in your APEX applications that accepts unescaped user input - either direct or data retrieved from the database.
As a - very stupid and simple - example, create a Page with a Text Item (say P3_TEXT).  Next create a Dynamic Action that executes this snippet of Javascript on Page (more...)

APEX 5 New Runtime API Lockdown Features

In APEX 4.x the developer could implement a feature that involves a call to the APEX API. E.g. you could create new pages on the fly if you would like to (just examine an export file for the how-to). You could drop an application using a procedure from the APEX_INSTANCE_ADMIN package. You could drop a user using APEX_UTIL.REMOVE_USER. If this is all on purpose and secured than that's fine. But maybe you (more...)

APEX 5 New Password Reset Features

Now and then it happens when we're logging in into our APEX instance: We have to change our password again .... And that means, typing it in an awful number of times:
1. Current Password
2. New Password (and of course preferably the same as the current one ...)
3. Confirm New Password
4. Press Apply Changes
5. Press Retun
6. And we're back at Square One : The login screen - and here we type (more...)

APEX 5 New Developer Preferences Features

As a lot of the new APEX 5 features are "by developers for developers", this one is also a nifty little thing that make our lives easier. Only the developer part of our lives of course....
In the upper right corner of APEX 5 you'll see your login name and a rather anonymous avatar. Just for fun - and recognisability - you can add your own face there. Or a picture of your (more...)

My OOW14 Performances

Oracle Open World 2014 starts in just over 4 weeks from now. And I am one of the (50,000?) lucky people who will be there ....
I will even take part in three sessions, one straight at the start and one almost at the end:

What Are They Thinking? With Oracle Application Express and Oracle Data Miner [UGF2861]
Sunday, Sep 28, 9:00 AM - 9:45 AM - Moscone South - 304

Panel Discussion: Bring Your (more...)

APEX 5 New Column Link Features

In the current version of Oracle Application Express you could use up to three items in a Column Link.
Most of the times that is enough. But there were always some use cases where you needed four or even five. And of course, just like with all limitations, you can figure out a work around. But wouldn't it be just awesome if APEX offers us more items out of the box.

And in APEX 5 (more...)

APEX 5 New Supporting Objects Features

In the current version of APEX the Supporting Objects feature is undervalued. You can create (sort of) self installing applications with it, but it is not widely used. Why? Because people don't realy know the feature or people do and experience lack of functionality. In both cases : Check out the functionality of APEX 5!
When you have scripts for creating tables, packages etc., in the current version you have to manually keep those (more...)

APEX 5 New Calendar Features

While playing around in the APEX 5 EA2 environment I discovered a few neat little features for Calendar regions.

First of all you can export the data of the calendar - only the data that's currently visible - to four types of format. Especially the iCal format is new and interesting as this is readable by most calendar applications. Right now, in EA2, the PDF option doesn't seem to work yet. And alas, the iCal (more...)

Multiple APEX listeners, one Application Server using Oracle REST Data Services (ORDS)

Oracle REST Data Services (ORDS) gives us the capability us to deploy multiple versions of the APEX listeners to a single Glassfish instance.  This is great for centralizing resources on a single server in our non-production environments.  This short post will show you how quick and painless it is to setup.

Setting up 2 instances (apptest & appdev)

Using ords.

Set up 2 directories and unzip into both (more...)

Custom EBS 12.2.3 to APEX 4.2.5 Integration Part 4: APEX Application Setup

Before setting up your APEX application, you will need to know 3 things about your EBS to APEX env

  1. The name of the cookie for APEX in the custom LaunchApex.jsp (apexCookieName) from Part 2
  2. The Responsibility IDs of the responsibilities that are allowed to access this application
  3. The URL of the EBS application Navigator Page (after login). 
For our example:
  2. 20420 (System Administrator)

Quick query to get (more...)

Custom EBS 12.2.3 to APEX 4.2.5 Integration Part 3: EBS Function and Menu Setup

The following steps were done while logged into EBS with the System Administrator responsibility.

note: The System Administrator menus are used as references.  The same techniques can be used to create menu entries under other responsibilities as well.

Set APEX Function path

System Administrator -> Profile -> System
In the “Find System Profile Values” -> Profile field enter FND: APEX URL and press the Find button

Change the Site value to your appropriate path and (more...)

Custom EBS 12.2.3 to APEX 4.2.5 Integration Part 2: LaunchApex.jsp

We didn't alter any of the original GWY.jsp code. Instead we added a piece to capture the value of the current EBS session cookie and rewrite it to another cookie that APEX will expect. By using the GWY.jsp, in the case where someone has bookmarked the urls within EBS to launch APEX, we can lean on the session checking already included. Anyone without a valid session will be sent to the Oracle login (more...)

Custom EBS 12.2.3 to APEX 4.2.5 Integration Part 1: The obligatory listing of caveats, gotchas, and mumbo jumbo

This part is to introduce you to what we used and why we did it this way. 

Software Versions:

Oracle E-Business Suite 12.2.3
Oracle Application Express:
Glassfish Server: 4.0
Oracle REST Data Services:

General Approach:

  • Users cannot log directly into APEX for EBS integrating applications
  • Users MUST log into Oracle EBS first
  • APEX applications must be assigned to Responsibilities (more...)

E-Business Suite and APEX Extending or Integrating?

Since returning from KScope14, I have been spending a great deal of time and effort examining any method of truly integrating E-Business Suite 12.2.3 (EBS) and APEX 4.2.5 (APEX). I have read the Oracle white paper, Extending Oracle E-Business Suite Release 12 using Oracle Application Express, and I realize this is the only supported method.  But, it feels incomplete to me...

Currently our users are logged in to APEX automatically when (more...)

Calculate minutes between two dates

Simple question but always a pain in the ass in finding the right solution:

(to_date('12.08.2014 12:30','dd.mm.yyyy hh24:mi')
-to_date('12.08.2014 11:30','dd.mm.yyyy hh24:mi')
) * 24 * 60
,0) as result_in_minutes
from dual;

Set Focus on Added Row Tabular

This sounds quite simple:

"I would like to set focus on the new added row in my tabular form."

In the following example, you can se how to acomplish that.

Cascading Shuttle – Keep Selected Values

There are probably a several good ways to solve the following problem:

    1. you have a simple select list which cascades a shuttle element
    2. you select something and the shuttle is populated
    3. after that, you pick a value in the shuttle and move it to the rigt side
    4. then you change the select list again
    5. the values you selected in your shuttle are now lost

This example shows how this can (more...)