Oracle Application Express (APEX):
- Is a rapid web application development tool for the Oracle database
- Combines the qualities of a personal database (productivity, ease of use, and flexibility) with the qualities of an enterprise database (security, integrity, performance, scalability, availability, and built for the web).
- The browser based interface, declarative programming framework, and simple wizards make Oracle Application Express easy to learn and enable you to quickly build robust applications.
-
No license fees for APEX itself, however
- When fully integrated in Oracle E-Business Suite (same database) an Oracle E-Business Suite limited-use license is not sufficient (no rights to make changes to the database)
- An additional application server is needed, which will not be totally without costs (may be a license fee, but surely costs to manage)
- The APEX pages are accessible via the regular eBS menus that users are used to work with
- The APEX pages look like the self-service pages in eBS R12. This has been managed by choosing the right theme (Legacy theme ‘Traditional Blue’; Theme 20) and adding / changing some elements in the editable template.

Traditional Blue plus customized template:

- Pressing the submit button on the APEX page shown above will upload the file plus submit a job (concurrent process ) in Oracle eBS itself and return the request id. So, the Excel file uploaded is processed in Oracle eBS immediately.
- There is also an APEX page where to download the Excel file uploaded, just by clicking on the filename. This APEX page is of type ‘Interactive Report’ and has standard a lot of filtering and sorting options that comes along with this type of APEX pages.


The integration makes smart use of the cookies that are used by the Oracle E-Business Suite.
- Installation / Integration of APEX in the eBS database
- Give your APEX pages the look of eBS R12
- Manage authorization / authentication
- Integration of APEX in eBS (access via eBS menu, submit concurrent request)
- Building an APEX extension: it’s all about rights!