Reviews (1-25 of 34)
- Oracle Application Express is tightly integrated with and thus leverages all the richness and power of the Oracle database - best RDBMS on the planet
- Promotes declarative Rapid Application Development and thus provides tremendous business value by shortening development cycles
- Can't think of any - the Application Express development team does a fantastic job adopting and supporting emerging trends with each new release.
- Requires Oracle RDBMS; i.e., is not portable to other RDBMS platforms. On the surface this may seem like a con but it is as it should be - Oracle database is best RDBMS available and tight integration with Oracle RDBMS promotes creation of reliable performant apps.
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)
- Ideal for quick prototyping
- Ideal for quick amendments and enlargements
- Numerous types of pages/regions (forms, lists, reports, diagrams)
- Oracle JET integration
- Optional Jasper Reports integration (not OOTB)
- Printing in good shape not so easy.
- Diagrams, charts need more detailed explanation concerning the SQL queries needed (examples).
- No more cons.
ERP, CRM, HCM, Financials, mobile apps.
- Extreme fast application build and production.
- Single sign-on via multiple authentication sources.
- Easy to maintain.
- Easy to administer users.
- Easy to administer authorizations.
- Debugging on several layers.
- Virtually everything is customizable.
- Better CSS editing (WYSIWYG).
- integrated URL masking or better integration via ORDS to make URL masking.
- out-of-the-box ORDS load-balancing.
- 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.
- When you have an highly customized application upgrading can be a pain.
- Single page applications are hard to build.
- Low code.
- Runs on all devices.
- Good charting and representation of data.
- I can prepare some nice chart in seconds instead of using reports.
- Trend and performance is visible in a scale from employees to organization.
- Great productivity.
- The interactive grid has great potential, but there's a lot of work to be done.
- The interactive reports and interactive grid should share the same jet charts.
- Easier integration of JET into APEX.
- Tree grid.
- The interactive grid would have easier navigation using the same principles as in interactive reports (filtering) when you navigate from page to page.
- It would benefit from the possibility to print nice charts from IR or IG.
- Needs a better choice of tool-tips.
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.
- 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.
- 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.
- Easy to learn and to understand.
- Low code. You can create really fast reports with just " SELECT * FROM TABLE".
- People can work on reports simultaneously.
- In Excel, you have to send the file via mail to other people and only one person can work it. Sometimes there are more than one version of this file. With Oracle, this does not happen.
- Sorry but there are still no cons!
I think it's less appropriate when a customer has a lot of special front-end wishes. In this case, it would be better to start with Angular and generate the front-end all manually.
- Easy upgrade path from Forms, allowing reuse of code and a low learning curve for Forms developers.
- Very quick to develop in. Ideal for prototyping or iterative development which is how we usually work.
- Comes with cross browser and mobile compatibility out of the box.
- Easy to incorporate other web technologies.
- Development environment runs straight from a browser. This has proved to be a life saver when issues crop up on a weekend.
- No built in printing solution for reports.
For less standardized tasks, the architecture will allow the use of other web technologies. I have, for instance, incorporated Google Maps into Oracle Application Express in order to visually show data, such as the operating areas, for our consultants. Setting this up in the Application Express framework is relatively straightforward allowing me to concentrate on the heavy lifting in PL/SQL.
The only major area I've found that it isn't well suited in currently is outputting anything printable, typically requiring the use of some 3rd party hardware or Oracle BI (if money is no object). I have also run into issues when working with larger teams as it doesn't lend itself well to source control with all the pages being stored in the database itself.
- Very rapid development of forms and reports.
- Awesome GUI look and feel.
- HTML 5 and CSS 3 compliant. The new version 19.2 now supports rest endpoints for forms and reports.
- Integration with other databases like My SQL, etc.
- Manages security well
- Provides a responsive environment to build apps in
- Easy connection to database services
- Manages sessions very well
- 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
- Rapid prototyping enables us to develop very fast.
- Low code allows us to create applications in a declarative way without too much code written.
- It's free!
- You need to find ways to fulfill special customer requests that are not built in and a little bit more complex.
- You need to have a running Oracle Database (possibly licensed if not XE).
- It is an easy tool to adopt, which allowed us to replace developments in Oracle Forms in many cases.
- It is very simple to develop different kinds of analysis, in a faster and more friendly way than running Oracle Reports.
- It helped us to extend our approval workflow, in order to cope with difficult branches that were hard to solve with the standard workflow.
- It was possible to develop web applications, to share information and transactions with our commercial partners.
- Perhaps is our problem, since we haven’t explored it deeply, but I think that a better portability to mobile devices would help the adoption of APEX.
- Applications weren’t as light as we thought, and we had to move the APEX server to the same data center where our data base was running, due to performance issues. When we started, we supposed that that situation would not be an issue.
- At least in Argentina and Brazil, you can not find as many programmers with experience in APEX as you can find with other technologies.
- Organization - it helps streamline employee information.
- User-friendly - very simple to use once you are trained on it.
- Timely - system works quickly and efficiently.
- Reporting - you have to use a certain code to run reports, and the reports will fail if you don't use the proper coding when requesting them.
- System crashes - our server goes down once or twice a week.
- Searching for employees - we can only search by last name, and sometimes it does not recognize the name the first time you enter it.
- 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.
- Lack of a native app.
- Installation time can be improved, it takes a while to download.
- Development is done quickly. Any change to the application can be seen immediately. No generation time needed.
- Compared to Oracle Forms/Designer this saves a lot of time.
- There is a large community where you can ask questions or read about how other developerS solved certain issues.
- Also the Oracle APEX team itself can be reached quite easily.
- They listen carefully to the suggestions of their users.
- As you have a lot of freedom where to put your code or how you code it, it is important to think well about standarisation.
- Version control must be done in a separate tool like Subversion.
- 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.
- 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.
- Allow you to use data from your Oracle Database to pre-fill forms or reports.
- It allows you to write data back to the Oracle Database.
- It is extremely fast! We have over 100 concurrent users in our APEX application and never get complaints about performance.
- It is highly configurable and can be used to create all kinds of different applications.
- You can only use APEX if you own Oracle Database.
- Very easy to create a dashboard-like app platform with minimal coding knowledge.
- Implementation went off without any issues and the connected systems worked very well.
- Users can create their own reports very easily.
- While we were transitioning to more Oracle based services, we did find that APEX was locked to only Oracle products. So if you are not fully committed, it will have limited functionality.
- No version control and so make sure to keep communication open between developers.
- It's free: it can be used with the different versions of the ORACLE database including the Express Edition.
- It has authentication and authorization features within the development environment, which is totally web.
- High availability in environments with Oracle RAC.
- Installation and configuration of APEX are simple.
- No extensive programming experience is required, the interface is very intuitive and there is a lot of information on the web and on the official site of Oracle.
- It allows exporting interactive reports to different formats: PPT, PDF, HTML, among others. The ability to include graphs for the dashboard simulation is very attractive and quite complete, up to the level of simulating a drill-down, by clicking on a portion of the graph to redirect to a detail table.
- Developing collaboratively can be a challenge because there is no version at the level of pages or applications.
- There is an opportunity for improvement in the way data is exported from the interactive report to PowerPoint format.
- Improve the way to optimize the performance of the application in the database separately from the engine.
Oracle APEX Scorecard Summary
Feature Scorecard Summary
About Oracle APEX
Oracle APEX Technical Details