What do you like best?
The FOEX Plugin Framework gave us the possibility to redevelop our complex backend applications without retraining our developers.
We made the decision to transition from Oracle Forms and Reports to Oracle APEX, but soon realized that some requirements could not be done without using 3rd party plugins for APEX. That’s when we learned about FOEX and how it enriches the APEX development environment.
FOEX helped us build data-centric screens which are similar to Forms in functionality, but look more modern. Since we don’t need to write so much code anymore, the apps we develop are also easier to maintain.
What do you dislike?
In addition to the FOEX Plugin Framework, they also sell a couple of addons as separate products. It would have been great to have that functionality included in the main software.
Not necessarily a dislike, but it would be great if they’d spend some time to create some video tutorials. Also the documentation should have more examples on how to use their components together.
Recommendations to others considering the product
If you’re thinking of using APEX for more complex projects have a look at what FOEX can do for you before you start. If we’d known about FOEX when we started our first migration project it would have saved us at least 4-6 months of development.
Since the project was quite in an advanced stage, we decided to move ahead as planned and use FOEX for our next projects. Suffice to say the other apps we had to migrate took way less time to rebuild with APEX + FOEX.
We had no budget for trainings, so we opened a trial account and went through the 2-day Developer Guide they provide. After that we asked for an online web meeting to discuss about a POC we wanted to build and used the developer forum to get answers to our questions. They usually reply within a day.
There is a bit of a learning curve at the beginning, but their team is willing to help. If you already know PL/SQL or have some experience with APEX, it should be relatively easy to learn your way around how FOEX works.
They call them FOEX apps (to highlight the fact that an app was built with the FOEX Plugin Framework), but essentially they are APEX apps which use FOEX plugins to do the work that would normally be done by the custom code you would have to write.
What business problems are you solving with the product? What benefits have you realized?
We have a small team of developers who worked with Oracle Forms & Reports for the most part. It was really important to find a tool that would allow us to build web apps using a similar approach to how we used to develop them in Forms.
Improving development speed is the key benefit of FOEX. We can deliver POC’s and production ready apps much more faster saving us quite a few $$$ in the process.
Everything is AJAX-centric with the FOEX Plugin Framework, which is a major plus for our users since they don’t need to refresh the whole page when making changes.