What is Oracle ApEx

  • Real time queries – reporting and dashboards
  • Develop new functionality, currently missing from EBS
  • Custom data collection or workflow
  • Modernise bespoke Oracle Forms applications
Oracle Application Express (APEX) is Oracle’s primary tool for Database and web application development. APEX is a free to use development environment to build web based applications using SQL and PL/SQL. Explorer has been using APEX since 2004 to develop professional business applications for desktops and mobile devices. APEX adoption has exploded over recent years and is now considered by Oracle themselves to be fundamental to their own application development requirements for internal and external web based systems.

Why use ApEx

  • Lower the cost of development
  • Deliver data apps quickly and easily
  • Update and replace legacy Oracle forms apps
  • Enhance Oracle EBS functionality
Oracle Application Express (or APEX as it is commonly known) is rapidly becoming the Oracle Development tool of choice for developers all over the world. Explorer develops with Oracle APEX because it gives us the ability to rapidly build Enterprise class applications at a low cost. Here are the key reasons why you should consider Oracle APEX.
Development Problem APEX Solution
Java is overkill for the projects I need to deliver. We look at the “big picture” of any project we work on to make sure that both technical and development deliverables are achieved with multi-faceted accountability.
I need to lower the cost of Oracle development. Faster development times and rapid developer adoption means lower cost and earlier deployment.
I need to minimise the cost of Oracle Licensing. APEX is a no cost feature of all Editions of the Oracle Database and can be deployed with no cost middleware components like Tomcat and Glassfish.
Oracle Forms is no longer our strategic development tool and I need an alternative. APEX should be the preferred development tool for any Oracle developer with PL/SQL experience as it allows them to develop modern Web 2.0 applications by leveraging their existing development expertise.
I need to replace Oracle Discoverer with a modern reporting platform. APEX is the perfect solution for replacing Discoverer and to enhance reporting visuals, dashboard content and output. More information about APEX & Disco can be found here.
How can I develop mobile applications without ADF? To support mobile application development, Oracle Application Express incorporates jQuery Mobile to deploy compact yet functional applications in a browser.
How can I develop bespoke applications to integrate Oracle E-Business Suite? Fully supported by Oracle, APEX is ideal for developing bespoke EBS modules. More information can be found here.
Spreadsheets are taking over my department and I need an alternative solution. APEX is a great solution to consolidate spreadsheets, improve data quality and security, reduce duplication and administration and enhance functionality.

FREE Oracle APEX Workshops

Find out more

Technical Overview

APEX is a fully supported, no cost component of all Editions of the Oracle Database. Adoption of APEX for strategic and tactical web development has grown significantly over the last year due to a growing community and recognition within Oracle customers of how easy it is to develop enterprise class systems. The development environment and end user interface are both delivered through the browser as HTML so it’s incredibly fast and lightweight. There are NO java applets running and APEX is web 2.0 compliant to deliver feature rich content. All APEX code is stored in the Database so the architecture is simple and lightweight. It’s flexible too so deployment options can align with requirements.

ApEx for E Business Suite (EBS)

Oracle E-Business Suite can be greatly enhanced with APEX...

  • Real time queries – reporting and dashboards
  • Develop new functionality, currently missing from EBS
  • Custom data collection or workflow
  • Modernise bespoke Oracle Forms applications
With cross-industry modules, Oracle E-Business Suite enables global businesses to manage the complexities of their day to day operations, no matter what size of the organisation. Oracle has long promoted the use of APEX to extend functionality of Oracle E-Business Suite (EBS) and Explorer also promotes this practice by providing specialised APEX guidance and experience. There are two main ways in which APEX and EBS are integrated: Integrating EBS data inside APEX Customising EBS using APEX Both options provide a seamless end user experience with the ability to include Single Sign On and deeply integrate APEX with custom EBS workflows. The installation of the system is also simple as can be seen from the Oracle recommended deployment architecture below, although alternative configurations are also supported.

ApEx for Reporting

ApEx for Business Intelligence

ApEx for Forms

ApEx FAQ's

New

selanm selam