Oracle APEX Information Reviews & Insights

Score8.4 out of 10

108 Reviews and Ratings

Community insights

TrustRadius Insights for Oracle APEX are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Development Speed: Users have praised Oracle Application Express for its rapid development capabilities, allowing them to focus on specific requirements while quickly creating applications. The platform excels in speed and includes common features required for most applications.

Customization Options: Reviewers appreciate the extensive customization options in Oracle Application Express, requiring knowledge of various technologies like Oracle SQL, PL/SQL, Javascript, and JQuery to create a wide range of applications with personalized functionalities.

Ease of Use: Customers highlight the ease of use, configuration, report building capabilities of Oracle Application Express. They mention its user-friendly UI providing a variety of templates for designing screens and enabling the creation of basic CRUD screens without detailed technical knowledge, making it accessible for users with varying levels of expertise.

Oracle APEX Reviews

12 Reviews

InformationComputer Software6Internet1Telecommunications3Information Services2

Best Low Code platform for Rapid Application Development in Oracle world

Rating: 10 out of 10

Incentivized

March 17, 2025

Use Cases and Deployment Scope

Our organization uses Oracle APEX for below scenarios: Custom Application Development: We use Oracle APEX to create custom web applications tailored to specific business needs. These include HR (Human Resources) management systems as well as Financial applications. Oracle APEX’s low-code environment enables rapid application development without extensive coding expertise, reducing the time required to deliver functional applications. Data Visualization and Reporting: Oracle APEX is being used for building interactive reports and dashboards that provide actionable insights. It allows developers to create graphs, charts, and tables, making it easier for business users to understand and analyze data. Business users are able to visualize business KPIs and other important metrics without needing external tools.

Pros

Data Visualization and Reporting
Process Automation and Workflows
Rapid Application Development with Low Code approach
Integration with Existing Systems
Strong AI Capabilities

Cons

IDCS based Developer accounts
Integration with Fusion Cloud

Likelihood to Recommend

Based on our organization's experience, Oracle APEX is a versatile and powerful tool, but its suitability depends on specific business needs, technical requirements, and the nature of the application being developed. Scenarios where Oracle APEX fits well: Business Process Automation/Workflows Reporting and Dashboards for Data Analytics AI based systems such as Select AI Chatbots for data insights based on LLMs Native-like Mobile Applications using PWA feature of APEX Scenarios where Oracle APEX may be less appropriate: Very Complex and highly interactive applications Use cases based on a non-oracle Database

Amod Joshi

Director Consulting in Information Technology at CGI (Information Services, 10,001+ employees)

Vetted Review

12 years of experience

View profile

Best Low Code Application Development Platform

Rating: 9 out of 10

Incentivized

January 5, 2024

Use Cases and Deployment Scope

My Organization used Oracle Application Express for many custom applications, few are open on Internet. These applications cover areas like ERP security, ERP related complex reports, Dashboards, Manufacturing related, etc. Our apps are integrated with ERP, Cloud based CRMs, many licensing applications, etc.

Pros

Reporting
Dashboards
Various Data forms
Quick applications
Consuming REST Data Services

Cons

Workflows - flexible one, with option to approvals by emails
In-built connector for Microsoft Outlook 365 Cloud and world's most used emailing / Active Directory applications

Likelihood to Recommend

Very fast database level applications
Applications where reports and forms are there
Getting data from various sources like cloud

Verified User

Project Manager in Information Technology (Telecommunications company, 1001-5000 employees)

Vetted Review

5 years of experience

Business Intelligence in Oracle APEX

Rating: 10 out of 10

Incentivized

September 15, 2021

Use Cases and Deployment Scope

Currently we use Oracle Application Express in only one department, but looking at how easy and fast is to add more small apps solving different tasks I believe it will be broadly adopted by a large audience very shortly.
I want to share my experience in one app we did. We are maintaining a relatively large data warehouse, design in star schema. This was used as a source for few BI tools and standard reports presenting some parts of Data Warehouse, but there was always a need for people with no SQL knowledge to get look in some part of data warehouse not presented in existing reports and tools to explore new possibilities or just to verify data. So we need some kind of simple presentation layer that quickly and easily can expose the data model and provide access to end user where they can review data in form of tables or charts. APEX look like is the perfect environment for that.

Missing bit in APEX is built in functionality to define data model but that was easily solved by simple web forms where power user can define relations between fact and dimensions and store that metadata to enable dynamically SQL generation later by end users. The end users can generate dataset automatically using simple graphical interface, without the need to know SQL. Data presentation is power by a dynamically populated APEX interactive data grid. It appears that the solution was adopted by users well and we enriched it quite easily with adding functionality to organize access to app by user, roles and different permissions enabling user to share report definitions between them. This is app working internally but I created an instance of it in OCI where you can see how it works presenting a sample oracle star schema model.
https://simplebimple.com

Login with :
user: demo
pass: demo

Pros

Easily create web application
Rich , ready to use web interface components
Easy deploy and maintain application
Simple and powerful security configuration out of the box

Cons

Some of the configuration options are a bit hidden, probably a bit better organization of workspace and application settings would benefit development process

Likelihood to Recommend

APEX is very well fit for solving fast some day to day activities in every organization.

Verified User

Consultant in Sales (Telecommunications company, 5001-10,000 employees)

Vetted Review

3 years of experience

Snap! The future is here

Rating: 10 out of 10

Incentivized

August 30, 2019

Use Cases and Deployment Scope

Oracle Application Express serves as a prime web and mobile application builder for our organisation. It is used internally to serve apps that we use on a daily basis and also build apps for clients. It has provided much needed security and a fast way to build apps by just focusing on the data, taking and presentation of that data to the client while still being fully integrated on the oracle platform with easy access to database and services.

Pros

Manages security well
Provides a responsive environment to build apps in
Easy connection to database services
Manages sessions very well

Cons

Javascript functionality
Mobile app development- more versatility required especially with the display of reports
More documentation that is easy to understand
More sample apps on configuration of services and authentication schemes
Make it easy to customize templates
More themes required

Likelihood to Recommend

Best for web applications. Less appropriate, however, for mobile applications. Applications that deal with businesses are quite useful.

Verified User

Technician in Information Technology (Computer Software company, 11-50 employees)

Vetted Review

1 year of experience

Oracle Application Express: the pinnacle of data driven software

Rating: 9 out of 10

Incentivized

August 6, 2019

Use Cases and Deployment Scope

Oracle APEX is used throughout the company on different levels. Within the company, APEX is used as a back-office management system, like registration of hours and billing. But also as a communication tool: the company news is spread through an APEX application. APEX is also used as one of the main tools to develop applications for our customers.

Pros

APEX is incorporated in the database, which gives it better performance then other tools.
Fast in implementing changes.
Out-of-the-box responsive applications thanks to the universal theme.

Cons

When you have an highly customized application upgrading can be a pain.
Single page applications are hard to build.

Likelihood to Recommend

APEX is data-centric. When you have a data-driven company with large data flows, APEX is a great choice. Because APEX is installed directly in the database, the data is always available. The Universal Theme allows you to make responsive applications without the need to write extra code. So users can access the data even their phones/tablets when they're on location. Applications build with APEX are most of the times multi-page applications. Today single-page applications (SSA) are more popular. Building an SSA can be quite difficult with APEX.

Boyd Timmerman

Oracle-consultant / APEX developer in Information Technology at Transfer Solutions (Computer Software, 51-200 employees)

Vetted Review

3 years of experience

View profile

APEX covers all - quick and efficient development and implementation

Rating: 10 out of 10

Incentivized

July 24, 2019

Use Cases and Deployment Scope

tennisapp.bfw-design.de (Oracle APEX 4.2/5.2/18.2)

BIB-Lueneburg APP (Oracle APEX-Mobile)

BIB-Lüneburg - Fairground Booking system (Oracle APEX)

ESFA - Clubmember Administration and Bookkeeping (Oracle APEX 5.2/18.2)

Facility Management with Financial Acconting (Oracle APEX 18.2)

KIS - Kundeninformationssystem (CRM + ERP + Controlling + HR) für Gutachterbüro - 200+ Mitarbeiter (Oracle APEX 5.2/18.2)

Module: Enter Order (ERP), Sales (CRM), Controlling, Management/Reports, Training Planing, Complaint Management,
Vacation/Absence Administration with approval process and calendar visualisation
73 Tables, 309 pages, Accounting: hostet (cloud) application
In production sind August 2017 - daily entering of about 900-1000 orders by 200 employees, daily settlement.
Printing (PDF) based on Jasper-Reports.

Construction Company: Working hours collection/monitoring with Tablet/Smartphone inkcl. Interface to DATEV und external Salary calculation provider (Oracle APEX 18.2)

Pros

Ideal for quick prototyping
Ideal for quick amendments and enlargements
Numerous types of pages/regions (forms, lists, reports, diagrams)
Oracle JET integration
REST
Optional Jasper Reports integration (not OOTB)

Cons

Printing in good shape not so easy.
Diagrams, charts need more detailed explanation concerning the SQL queries needed (examples).
No more cons.

Likelihood to Recommend

Almost any business requirement with data-centric aspects can be covered - no limitations.
ERP, CRM, HCM, Financials, mobile apps.

Bernhard Fischer-Wasels

Application Developer in Information Technology at bfw-design (Computer Software, 1-10 employees)

Vetted Review

17 years of experience

View profile

Low code development that flies high : Oracle Application Express

Rating: 9 out of 10

Incentivized

July 3, 2019

Use Cases and Deployment Scope

Oracle Application Express (APEX) is used by my organization to solve business problems for other organizations. APEX enables us to create data-centric web applications using a low-code development tool. Developed applications are fast, responsive, scalable and secure.
The business problems are totally diverse, ranging from HR, CRM, ERP, mobile apps and portals.
APEX is mostly used in an environment where an Oracle database is already present -- that could be for developing in-house applications, or hosting Oracle's own ERP systems like Oracle E-Business Suite or any other Fusion product. APEX is the tool of choice if you want to build extensions or customizations to these standard applications.
And APEX is by design "cloud ready" -- it always has been and will always be.

Pros

Fast development due to the low code approach.
Responsive out of the box due to the built-in Universal Theme.
Cloud enabled by design. You can build applications only using a web browser.
Scalable: if it runs inside the Oracle database, it uses the full power of that database.
Free: it is a no-cost option for the Oracle database.
It runs everywhere where Oracle runs, from a small (free) XE database on your laptop, to an Exadata machine.
The only languages you need to know are SQL and PL/SQL. Some JavaScript and CSS knowledge might be handy but not strictly necessary.

Cons

Version control. As all metadata is stored in the database, there are no files to store in a GIT or Subversion repository (unless you export from the database).
Lock in: you are locked in into the Oracle database, and that's why it is mostly used in an environment where that database is already present.
Oracle is not "popular" at the moment, so the average developer is somewhat older than the regular (JavaScript) developer.

Likelihood to Recommend

It's well suited if you need to display (or enter/change) data from an Oracle database. If you (or your customer) think you definitely need a native app, then it is not a good fit. Creating a dashboard with different kinds of charts and KPI's is easy using APEX. If you need a real data-mining solution, then you better switch to Oracle Analytics. As APEX offers an easy interface for RESTful services, you can also create forms, reports, and charts upon any RESTful service that's available on the internet -- either within or outside your organization.

Roel Hartman

Director in Professional Services at APEX Consulting (Computer Software, 1-10 employees)

Vetted Review

12 years of experience

View profile

Oracle Express

Rating: 8 out of 10

Incentivized

February 11, 2019

Use Cases and Deployment Scope

It is being used across the whole company. It is used for authentication and security purposes. It makes sure that we are all verified in each system that we access. It allows our developers to focus on the task at hand thanks to the suite of sample and productivity applications.

Pros

Eliminates the complexity involved with multi-faceted web applications.
Oracle Express supports enhanced productivity in low code apps.
It requires no complex build scripts to operate.
The software supports effortless customization and design.

Cons

Lack of a native app.
Installation time can be improved, it takes a while to download.

Likelihood to Recommend

We have converted a lot of old SharePoint processes to Apex applications. We are developing new applications using this tool. Most of the applications are being utilized to transition old processes to make them more efficient. The worst part of the software is having to strictly follow the structure, we cannot put as many columns and items as we would like and we would enjoy that customization.

Jesse Boring

Retail Sales Supervisor in Sales at Sprint (Telecommunications, 10,001+ employees)

Vetted Review

2 years of experience

View profile

Oracle APEX: A quick tool for building responsive Web pages

Rating: 7 out of 10

Incentivized

November 6, 2018

Use Cases and Deployment Scope

We used Oracle Application Express for the improvements of our Business.The tool is being used in several departments to access different systems. The use of Oracle APEX has replaced use of paper-based and spreadsheet-based checking of data on a day to day basis.

Pros

Oracle APEX can be used as good replacement for Excel data entry sheets.
It provides high level of security about their personal information.
It is very easy to install.

Cons

As it is Oracle-specific, it is not suitable for other databases.
Everything is stored online, if there is no internet we can't access the tool.

Likelihood to Recommend

Oracle APEX is a Versatile tool. Though it is database specific, it can be used with many other different technologies. Also, it is accessible from browser as well as mobile.

Verified User

Analyst in Information Technology (Computer Software company, 10,001+ employees)

Vetted Review

2 years of experience

Design and develop dynamic data driven apps

Rating: 9 out of 10

Incentivized

June 12, 2018

Use Cases and Deployment Scope

We have used Oracle Application Express to design and develop dynamic and responsive web applications that heavily rely on an underlying database. We have used as we are upgrading our system to perform better.

Pros

Support for dynamic data driven applications
Easy connection to SIS
Helpful support team

Cons

Steep learning curve

Likelihood to Recommend

Oracle Application Express is best suited for web applications that are data-driven, requires high reliability and intended to be scalable.

Mwangi Wanjohi

Android Developer in Information Technology at Upwork (Internet, 201-500 employees)

Vetted Review

2 years of experience

View profile

Loading Reviews List....

Low code development that flies high : Oracle Application Express

Rating: 9 out of 10

Incentivized

July 3, 2019

Use Cases and Deployment Scope

Pros

Fast development due to the low code approach.
Responsive out of the box due to the built-in Universal Theme.
Cloud enabled by design. You can build applications only using a web browser.
Scalable: if it runs inside the Oracle database, it uses the full power of that database.
Free: it is a no-cost option for the Oracle database.
It runs everywhere where Oracle runs, from a small (free) XE database on your laptop, to an Exadata machine.
The only languages you need to know are SQL and PL/SQL. Some JavaScript and CSS knowledge might be handy but not strictly necessary.

Cons

Version control. As all metadata is stored in the database, there are no files to store in a GIT or Subversion repository (unless you export from the database).
Lock in: you are locked in into the Oracle database, and that's why it is mostly used in an environment where that database is already present.
Oracle is not "popular" at the moment, so the average developer is somewhat older than the regular (JavaScript) developer.

Likelihood to Recommend

Roel Hartman

Director in Professional Services at APEX Consulting (Computer Software, 1-10 employees)

Vetted Review

12 years of experience

View profile