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.