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)


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...)

APEX and other Random Things from the mind of Donald Clarke 2014-05-29 05:57:00

Slide deck is pretty much done and uploaded to ODTUG.  I still have a few ideas in my head, just not sure how to lay them out in a slide.  If you aren't coming to Seattle, no worries! After KSCOPE, I will start uploading the deck in a series of posts...

Interestingly, while working on the EBS 12 test system I ran across the same issue everyone has when migrating my APEX integration pieces from (more...)

I am speaking at Kscope 14!


Hopefully, I will be finished testing apps and updating slides to cover APEX and Oracle REST Data Services and possibly adding some 12.2.3 notes.

How to Integrate EBS 11i with APEX 4.2
When: Jun 25, 2014, Session 14, 2:00 pm - 3:00 pm
Topic: Application Express - Subtopic: No Subtopic
In researching possible solutions for replacing an outdated (more...)