The APEX2EBS framework connects to a EBS database user through a database link:
The simplist way is connected to APPS. However it poses a serious security risk because any mis-use of this connection could compromise the entire EBS database. You could try to user APPS in non-prod environment for quick demo, proof-of-concept, or code testings.
Another way is connected to a custom EBS schema, usually it is prefix with XX. Usually this custom EBS database user only has least amount of privileges on EBS data just enough for necessary operations. In here user XXAPEX is used.
In SQLPlus. connect to EBS database by APPS
Run script EBS-CORE-VIEW.SQL to ceate EBS data views that APEX2EBS framework needs.
If you want to use custom EBS schema for APEX2EBS connection, run script EBS-CORE-GRANT.SQL. Enter the custom schema name when asked.
If custom EBS schema is used, connect to EBS database by this custom user
Run script EBS-CORE-SYNNOYM.SQL to ceate synonyms for the objects created in APPS. The APEX app will use these synonyms through a database link.
Note
These scripts also contain objects for examples.
Copy the file A2E.jsp to App server $OA_HTML directory. Compile this JSP file:
Windows: perl -x %FND_TOP%\patch\115\bin\ojspCompile.pl --compile --flush -s "apex2ebs.jsp"
Linux/Unix: perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -s 'apex2ebs.jsp'
Set profile option FND: APEX URL to the APEX Server URL
Bounce the Weblogic server
Now all the setup in the EBS side is completed. Next we wil go to the APEX side to finish the configuration.
© 2026 by Christopher Ho. All Rights Reserved