Oracle Forms applications are the backbone of many organizations. They’ve evolved over time to fit the needs of order processing, shipping, finance, and more. They can be a model of efficiency. Yet, Forms at its core is still Client-Server technology, and only partially adapted to today’s web-based business reality. This is one of the main reasons many business administrators are looking for Forms migration options.
Oracle had to de-support Oracle Forms’ use of a Java plugin for web browsers due to quickly evolving browser technology. This issue was addressed, with a tool called Standalone Launcher which allows Forms 12c to operate “browserless”. Forms is better off with it, but it is much more in line with the client-server experience than a web one.
A survey we did earlier this year during our Webinar entitled “Protect your Investment by Modernizing Oracle Forms” shows that a majority of Forms administrators believe a web-based user experience and functionality must play a role in the future of Oracle Forms.
With so many businesses still using Forms, Oracle is still active in supporting and updating it. But can your business afford to wait for Forms to catch up with the times? What about easily connecting to web services? What about implementing mobile applications, taking advantage of SaaS (Software as a Service) offerings, or real-time interactive reporting (more about Oracle Reports in an upcoming blog)? It might be a long wait.
So, what are the options available to an organization looking to replace Forms? Here are a few.
Some organizations have chosen to replace Oracle Forms with open-source technology. For example, the LAMP approach: Linux, Apache, MySQL, PHP. These are license-free and can be used to build systems that are fully compatible with modern web technology. An open-source web development framework could help you generate web applications to replace your Forms applications. The disadvantage here is that there is no integration with Forms, and you are starting from scratch. Here’s a popular example of such a framework, called openxava which is based on your re-writing data structure and business logic code in Java.
Open source is free and without licensing fees, which is very attractive to the cost-conscious. In the above example, you could theoretically not only eliminate the licensing costs of your applications but those of your Oracle Database as well, if you were to migrate the Database to something like PostgreSQL, for example.
The main issue here, however, is that long-term support on such platforms is a question mark. Even the most popular open-source software risks being superseded. The result can be fewer upgrades and dwindling support.
It’s true that some open source software has large-manufacturer support. For example, Oracle supports MySQL. However, open-source tools often lack structure. The understanding and use of these tools will often depend on how well the specific technology suits the developer.
These standardized platforms, consisting of a bundled suite of business applications became very popular in the early 2000s. They’ve helped businesses grow, but they didn’t necessarily grow with all business needs. Companies using these systems are increasingly calling on software developers to extend their ERP’s capabilities. Each division of a large company can end up having custom needs outside the ERP’s parameters. This could come from managing new products, new technologies, new processes. ERPs may cover 80%-90% of your application needs, but that remaining 10%-20% is often what makes your business unique.
All in all, the associated costs of moving to an ERP are high. This can make sense if the new system covers your business functions. In my experience though, there is always something of Forms that isn’t. When this happens, you can use Oracle APEX to extend the ERP to integrate the necessary functionality. More on APEX later.
Some businesses change over to a different technology entirely, such as Java or .NET. But, does your development team have the time and talent to convert to a completely new application framework? Can they deal with suddenly being novices at a new programming language and having to continue to solve complex business problems with that limited knowledge? Can your company withstand this lost productivity and get safely through such a transition? If not, it can become a job for 3rd party technologists with the costs that this entails.
Many companies have application suites with Forms-like behavior created for them by 3rd parties using a combination of technologies. But, just as with open source technology, who knows how that will turn out in the long term? You might end up with a system that is just as difficult to maintain as your Forms system was.
All of the above approaches are basically “From Scratch”. They put aside the efficiencies of Forms, and those of your developers. However, there is a way, thanks to Oracle, to reuse much of what your company has painstakingly developed over the years with Forms, to create thoroughly web-based applications.
It’s by using Oracle Application Express (APEX). APEX comes standard with the Oracle database and is already covered under your licensing program. As a no-cost option of the Oracle database, APEX allows you to create as many applications and have as many users as you want.
Best of all, it enables you to access the latest web technologies while utilizing your existing data model, business logic, and PL/SQL code.
APEX is a declarative application development platform that uses PL/SQL code. Unlike Forms though, its engine renders applications in real-time from data stored in tables on the database and displays them on a web browser. Whether you are running an application or developing one, it is done through a web browser.
