In order to get APEX working in an Apps (11.5.10.2) environment you have to observe the following:

1. Download the APEX 3.2.1 zip file from Download
1.1 Install the APEX suite using ”sqlplus "sys/syspass@10g as sysdba" @apexins SYSAUX SYSAUX TEMP /i/ ”
2. Adapt the following files
2.1.1 $IAS_CONFIG_HOME/Apache/modplsql/cfg/wdbsvr.app
Add the following:
[DAD_apex]
connect_string = CONNECT_STRING
password = apex
username = apex_public_user
default_page = apex
document_table = wwv_flow_file_objects$
document_path = docs
document_proc = wwv_flow_file_mgr.process_download
reuse = Yes
enablesso = No
stateful = STATELESS_RESET
nls_lang = American_America.AL32UTF8
;
2.1.2 $IAS_CONFIG_HOME/Apache/Apache/conf/oracle_apps.conf (could be a number of other files as well....)
# and now for Apex
# niels eliasen, www.delfi-konsult.com
include "/physical_patch_to_this_include_file/apex_include.conf"
2.1.3 /physical_path_to_this_include_file/apex_inclde.conf
Alias /apex/ "/physical_path_to_this_file/apex/"
Alias /i/ "/physical_path_to_this_file/apex/images/"
AddType text/xml xbl
AddType text/x-component htc

2.2 You have to run the apxchpwd.sql script... otherwise you wil not get any access.....

Obviously... when you want this to survive the next ”autoconfig” run... you will have to customize... and adapt accordingly!
Furthermore.... To integrate with Apps... see the paper from Cabot Consulting
PS: Please Note: This is for R11(11.5.10.2) only as for R12 the ”modplsql” option (which is used for APEX is no longer available!)

Mærker: oracle apex e-business