We changed our name from IT Central Station: Here's why

Oracle Application Express (APEX) Room for Improvement

AG
Senior Database Developer at a tech services company with 51-200 employees

The first thing I can think of that needs to be improved with this product is that there is a problem with security. In all of the applications I saw, they stored the passwords in the configuration files. I think this is a big issue. The security module is supposed to be included in the APEX connection component, but people connect to the Oracle HTTP Server and the password goes to the HTTP server. It is using the HTTP server for the security part. We did some analysis and we figured out that we had to move to another product.  

Because security is not satisfactory, we created our own connection mechanism in ORDS. It was a better way to keep the passwords encrypted and to make access to the APEX applications a little bit more secure. But the way APEX causes applications to store the security information is a big issue and a security vulnerability. ORDS is pretty straightforward and Oracle WebLogic Server is very flexible and a very nice feature.  

Also, the Oracle application page is supposed to be able to cancel access to the application. From what we found, this is not done properly. The connection is hanging and sometimes different people who connect to the application use the same ID. This can seriously interfere with users who are already connected. These are both very bad security issues.  

There is also a disadvantage in that it is pretty hard to fix bugs in APEX. It is very tricky. Basically, the Oracle objects generate the HTML code and cast it to the HTTP server. You have to be very careful with the HTTP Syntax for the sake of compatibility. Some browsers accept the code that gets generated and some browsers not. It is very hard to debug these coding issues.  

View full review »
Senior Chief Engineer at ministry of electricity

Connecting with Oracle and the relation with Oracle at the database as a procedure needs improvement. 

The front-end development that's looking for HTML, Java, C++, etc also needs improvement. In order to get more out of APEX, there should be more training courses to help beginners start from A to Z. When I started with APEX, I focused on the first part, the relation between database procedure, and later I found I needed more learning courses for the HTML. There should be more training or books looking at the relationship between APEX and Oracle, not between APEX and HTML, CSL, or JavaScript. In order to go more and more with APEX, it needs to start with HTML, CSL, JavaScript, and web development.

The main drawback is that APEX doesn't talk with other databases. It would be great for the tool if you could combine it with different open-source databases. 

View full review »
Founder at Avsa Danismanlik Ltd Sti

It would be my dream to merge two products into one. Visual Builder and APEX should meld in one product. 

Each has different strengths. Visual Builder is very strong in Java, and you can build HTML applications very easily with low code. APEX is very important to have a direct connection to the Oracle database.

If these two products would meld into one in the future, it would be very nice. 

In the future of APEX, I would expect features more like Visual Builder. Also being able to use HTML codes directly. Visual Builder produces HTML codes and source codes.

APEX does not have source code, it runs from the database. We can export our objects, our source, and import them in different environments and different hardware, but it's not readable in HTML codes. 

View full review »
Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
563,327 professionals have used our research since 2012.
MW
Consultant at a energy/utilities company with 51-200 employees

The collaboration and the workflow engine could use some improvement. If you have a larger team working with APEX, it is not that easy to synchronize the team. It is easier with a code-rich application because of the tools. It is not that easy in a low-code environment.

In the next release, I would like to see a better workflow tool.

View full review »
HN
CTO at a tech services company with 51-200 employees

The solution does not offer everything under one umbrella solution.

In terms of the VPNs and process management, Oracle can make it better. It's an area that definitely could be improved upon. They really don't have anything going on there.

The solution has some stability problems that need to be resolved.

The product should add a separate site with a development language supporting Java, or other languages such as this.

View full review »
IA
Freelancer with 1-10 employees

It has been reported that the technology is tough to learn, and the service is expensive. The online supporting documentation could be better and offered in other languages, as Malaysian does not seem to be covered. Oracle could improve server and data migration from the cloud. This is achieved easier via a hybrid version. Sometimes we perform migrations and have to roll them back, as there are unforeseen issues.

View full review »
Sr. Director at LogiCorner Info Tech.

1. Need more backup options, such as more than 25 backups, option for choosing what conditions to trigger the backup action, etc.

2. If APEX could add the workflow engine feature, that will be awesome.

3. If there could be a kind of chart to make the link graphics between the parent nodes and the child nodes, (currently there is a Tree feature), but sometimes the hierarchy is not only one-to-many, could be many-to-one, or many-to-many.  

4. More mobile-friendly UI features will make APEX more powerful and engaging.

View full review »
Manager / Oracle Applications Consultant at ASAM Conseil Inc

Maybe some people go with other technologies because they are more familiar with them. Oracle probably needs more communication about APEX and to show people that they have something free on their hands and that they need to give it a chance.

Maybe there are other technologies that offer what APEX cannot. Oracle is working hard on APEX to put it more on the cloud, so it is more useful for people that know how to code.

View full review »
Managing Partner & Oracle ERP Technical Consultant at a tech services company with 1-10 employees

I don't like the URL syntax—for example, the parameters in the URL for the pages. If there are any parameters, all the users see all the parameter names. This may require some caching. The UI could be improved as well. Sometimes, based on the customization, load balancing isn't running behind the F5. 

View full review »
Computer Specialist at a government with 10,001+ employees

There is not a lot of Wiki help or in Google, but there is some.

View full review »
Coordinador de inteligencia empresarial at Grupo Orbis

Some of the application interfaces of Oracle Application Express are not very attractive and could be improved.

View full review »
Specialist EHR Implementation at siut

I think Apex is like many similar tools that are currently available. If you want specific reports, you have to implement third party tools. It would make a big difference if the reporting was included in the product so that we wouldn't need to get it from third parties. 

View full review »
SA
Engineer at a university with 10,001+ employees

Occasionally when trying to un a page, I would be faced with an error number; however, not much information would be provided on the error itself outside of the programming language. It would be nice if more information could be provided.

View full review »
Founder and Technical Director at a tech vendor with 1-10 employees

Workflow capabilities should be added.

Better connection and integration with non-Oracle databases is needed.

View full review »
Developer at Watronix Information Technology Ltd

It has a bit of a strict framework, you have to make all the time adjustments in their JavaScript. Another downside is that it's only available for Oracle databases.

View full review »
General manager at Temporis Latin America Spa

It should have the functionality to develop mobile applications. It would also be good if they can improve development in videos and other formats.

View full review »
Learn what your peers think about Oracle Application Express (APEX). Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
563,327 professionals have used our research since 2012.