Skip to Main Content

Cloud Platform


For appeals, questions and feedback, please email

Oracle Forms To APEX Migration & Modernization

Oracle APEX is the right platform if you want to transform your old Oracle Forms applications to modern web apps. Forms Stored Procedures and PL/SQL packages work as it is in APEX, And reduces the effort for the migrating the form level business logics.
Similarities & Differences:
The recommended best-practice approach with Forms was to have as much of the code as possible reside in the database, including business logics and roles related tables for security. Forms acts as a front-end to all this functionality while most of the business logic resides in the database. All is secure, centralized, easy to maintain, easy to deploy, and performant. APEX works the same way.
Oracle Forms is based on a relational data model, meaning most application screens or blocks of information are based on tables in the database. Often, these are management applications: Client management, order management, PL Management, etc. APEX uses this same relational data model.
Forms development is procedural and not object-oriented such as with Java or .Net. So is APEX.
Forms and APEX share the same coding language, PL/SQL. There are, of course, many new functions in APEX, but the base is still the same. APEX even allows you to reuse much of the code you already have in Forms.
However, there are also some key differences. Oracle APEX runs completely through a web browser and requires zero client-side tools or browser plugins (for both development and runtime), it saves app definitions using a metadata repository so there is no need for file generation, includes out of the box theming, and produces fully responsive apps (so it runs on any device).
Why Oracle APEX?
Oracle APEX apps are generally very easy to use and are similar to other modern web apps end users already use.
Your users run on a variety of different devices including large desktops, tablets, and even mobile devices and they expect the apps to work equally well on any form factor.
Cost is one more major factor, There are no licensing costs associated with Oracle APEX. Oracle APEX is a feature of Oracle Database, thus if you have a license for Oracle Database, you already have Oracle APEX.
With Oracle APEX you have a lot of flexibility with where you do development, from developing on a laptop, on-premises, or in the cloud. Where you develop your apps doesn't limit where you can deploy your applications. You can develop and deploy wherever there is an Oracle Database, with Oracle APEX installed. For example, develop in-house on-premises and deploy to partners on the cloud, or work with a consulting company developing on the cloud and deploy on-premises.
What we are proposing?
We have a tool "Forms to APEX Migration Tool" (F2A) which automatically migrates "Oracle forms" application to "Oracle APEX" application.
Three step Approach:
Its a simple three step approach. Convert --> Migrate --> Replace.
Convert your Fmb's to xml's. Upload the converted xml's to F2A tool (as a zip file contains all the xml). Tool will read each and every file, Analyze it and generate a complexity report. This is one the main advantage of the tool where user gets the complexity report which will be used for the migration estimations. And here goes with a magic step where oracle forms will be converted to oracle apex pages on a single button click.

What we are claiming:
We are saving so much of development efforts when migrating from Oracle Forms to Oracle APEX.

Additionally, We will be working with the business to determine the best way to perform various tasks in today's business world. We will make sure how large, multi-step processes can be streamlined, and ensure the most common tasks require the fewest steps in the new apps.
So, As mentioned earlier, Oracle APEX is the best platform to migrate old oracle forms applications. And with our "Forms to APEX Migration Tool" (F2A) tool we are making the job simpler.
Thanks & Regards,

This post has been answered by Mónica Godoy -Oracle on Jan 15 2024
Jump to Answer
Post Details
Added on Jul 5 2022