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.
During my over eight-year career as an Oracle APEX Developer, I've developed numerous applications using Oracle APEX technology for various industries, including telecommunications, banking, and pharmaceuticals. The business challenge is usually similar: creating a web application in the shortest possible time. I believe Oracle APEX is an excellent tool for such tasks. Thanks to the many components we can use out-of-the-box, application development is very fast and highly effective.
Pros
Great reporting tool!
Create charts and dashboards in a fun and clear way.
A way to work with flat files like Excel or CSV.
A great connection between the Oracle database and the web-based interpretation of that database in the form of an application.
Cons
Difficult work for offline applications: APEX should maintain a connection to the database at all times.
Harder work with typical mobile applications.
One-page applications. APEX is a typical framework with many smaller pages.
Likelihood to Recommend
If you need to develop an application very quickly, without unnecessary lengthy specifications or business requirements, something you need right away, while utilizing all the capabilities of the Oracle database, APEX is the right choice. Thanks to the many components you use from the vast Oracle APEX library, working with this tool is exceptionally pleasant, fast, and effective.
Oracle APEX is our main UI and reporting tool and it is used across the whole organisation. It provides day to day activity tracking and monitoring, providing SLA reporting to top management. Integrated with other internal and external systems using REST services.
Pros
Tightly integrated with the database which help developer to use same knowledge of SQL and PL/SQL to develop the full stack application.
Easy to learn and using low-code we can develop application in no time.
Cons
Improvement on screen layout, specifically designing dashboard with drag and change position and save by user.
Report with sub-reports as drill-down report configuration.
Security across application.
Oracle should develop some plugin and maintain it, like displaying images, start and end date validation plugin, separate time component plugin.
More functionality in IG and standard reports.
Likelihood to Recommend
It is good for database application, the UI is good but needs some improvement for complex things.
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
We are using Oracle Apex for internal development like creating forms or automation of medium complex processes. It is a Power app so provide us both Web app and mobile app features. We are also creating reports in it with good visualization features. But it becomes difficult to develop the program in it, when the process is too mouch complex.
Pros
Creating forms for collecting data from users.
Automating manual process to systems
creating mobile app for existing process.
Cons
It is not fully customizable for a developer
It becomes to develop complex programs in it
The infra of Oracle apex in high in cost.
Likelihood to Recommend
It is well suited where we have to create forms in which user enters data and it will go to decided authority for maintaing data.
It is not well suited where we have to convert whole manual work to system in which lot of logics complex logics and difficult to maintain that program.
VU
Verified User
Executive in Information Technology (5001-10,000 employees)
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
VU
Verified User
Project Manager in Information Technology (1001-5000 employees)
<div>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. </div><div>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.
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.
At first, Oracle Application Express was used by only one department. However, after realizing the benefit, gradually it has been adopted by the whole organization. Majority of the use case is for Internal Application, with user mostly from employee. Example of Internal Application such as small-scale ERP, workflow framework, tracking assets and licenses, issue tracking system, and also can be used to analyze and monitor various data, such as activity log and sales dashboard. To use Oracle APEX for commercial application is not recommended, unless you have very good Oracle DBA.
Pros
Fast. Nothing beats Oracle Application Express in terms of speed of development. Almost all common and must-have features for most application has been built into Oracle Application Express, and we only need to focus to the business requirements.
Quality. Luckily, fast doesn't always translate to low quality. Even using basic wizard, within five minutes, we can build a quality application that has good security, a good user interface and good features, and this can be a very good standard for a company. The default is basic, but it's easy to tweak to achieve higher than standard quality. Notable features are checksum to enable integrity of web application, interactive report, interactive grid, modular ajax functionality, instrumentation for every user and developer action, PWA ready.
Customization. The apps created are very customizable. You only need to understand Oracle SQL and PL/SQL, Javascript, CSS3, and JQuery. Then, you can create nearly any application you have in mind.
Prototyping. When we are working for a client, sometimes it's hard to be on the same page when at first we only talk about the application concept. Using Oracle Application Express helps to create a prototype application and adjust it according to the client's input within minutes. This greatly helps bringing IT and non-IT clients on the same page faster.
Cons
It's tied up to Oracle Database only. If you don't have Oracle Database, forget Oracle Application Express.
I wish it has offline mode so it could be used in no-internet areas and sync it when it's back online.
It's not critical, but it would be nice if there were more choices of themes. I know Oracle Application Express has couple of themes, but in my opinion, currently only Universal Theme is the theme for Oracle Application Express.
Likelihood to Recommend
The most suitable case for Oracle Application Express is any application, web desktop or mobile used by internal employee, that only needs to store and manipulate data in Oracle Database, and be accessed online all the time. If you don't use Oracle database, forget about Oracle Application Express. To use Oracle Application Express for wider user base is not impossible, but you will need to tweak the configuration and need a very good DBA to make sure that the potential load is manageable. And since all the business logic will be inside the database, you can only scale up vertically.
VU
Verified User
Manager in Information Technology (1001-5000 employees)
Oracle Application Express is being used by IT engineers. They build reports and small applications for our users in other departments, especially the marketing and financial departments.
Pros
Easy to use.
Easy to configure.
Easy for building reports.
Easy for building forms.
Likelihood to Recommend
Oracle Application Express is good for easy and fast application and reports development. You can develop entire applications and you do not need another web server. However, you cannot access the source code of applications built in Oracle Application Express.
VU
Verified User
Director in Information Technology (501-1000 employees)
Right now I created a small app to track pending/ongoing tasks using APEX on the newly available Oracle Cloud Free Tier. I decided to create it to simplify how I manage and execute my daily tasks in order to be able to both track advance and manage dependencies between tasks. I use Trello to keep boards with simple tasks but managing dependencies was something not simple to achieve, so I decided to try a solution that solved my problems while starting to use APEX.
Pros
The UI is very easy to use, and you can choose from a number of templates for each "screen" you design.
You can design basic CRUD screens without knowing the "details" (technology) under the hood.
It's easy to test. Just one click, and the page you are working on is executed.
Cons
Deployment on an OnPremise DB is not so simple. You need to follow many steps (that's why I used the Cloud version!).
Likelihood to Recommend
I would definitively use APEX for small (department size) applications that can be developed and maintained by a small development team, without a complex design/develop/test/deploy process.
Also, to generate all basic CRUD on complex applications, rather than programming them using other languages (Java. c#, etc) and having more complex deployment processes.
First of all, it's very easy to use and within hours I can have an application made. I like that the interface is useable and easy to navigate. I also liked that there is a lot of configuration possibilities. I found a lot of plugins available for it, so it makes our development much easier.
Pros
Easy set-up.
Plugins.
Lot of configurable options.
Cons
Hard to use version control.
Likelihood to Recommend
If you need rapid application development, this is the tool that you need. It is easy to use, and you can develop an application easily and fast. But they should really improve the version control, sometimes its hard to use.
