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 save.
For example: http://yourserver.yourdomain.com:8080/ords

Create Form Function

Application -> Function

Description Tab:

• Function Name
• User Function Name
• Description

Properties Tab - Type: SSWA jsp function

Web HTML Tab - HTML Call: LaunchApex.jsp?targetAppType=APEX&p=900:1
(using application id 900 and page 1, make sure the application ID matches what you are using for your APEX app. )
Notice we are not sending anything else in the call.  Therefore, no other information will be sent in the calling URL!

Adding Menu Prompt

Application -> Menu

Create a new entry(see bottom entry in image below):

• Prompt - whatever you wish the user to see
• Submenu - depends on your setup
• Function - the function we created above
• Description - optional

Notes:

• You can set up multiple Form Functions. We use one for each application. For example, HR and Sales each have different Form Functions and menu entries.  
• On the APEX side we have completely separate applications for each group.  Therefore we can completely separate responsibilities and groups that are affected with changes in any applications.