The Oracle APEX blog is your source for APEX news, technical tips and strategic direction

Modernizing an Oracle Forms Application to an Oracle APEX Application

Monica Godoy
Principal Product Manager

Oracle Forms is an established technology that has been popular for building data applications for decades, particularly in South America you can find a vast array of companies working with Oracle Forms, even with an unsupported version. Most of these companies are looking for a similar tool that lets developers keep delivering their projects faster while taking advantage of implemented Oracle database business logic and features. To read about similarities and differences between Oracle Forms and Oracle APEX, go to Modernizing Oracle Forms.

Having said that, I'll show you how to modernize a sample Oracle Forms application with:

  • Master - Detail relationship
  • List of values
  • Triggers
  • Validations
  • Procedure or Functions call.

What Do You Need?

An Oracle Forms Application and access to an Oracle APEX Workspace is all that you would need to follow this blog post series, I'll show you how to take advantage of the Migration Project, create an APEX Application and customize it. 

Benefits of Application Migration Project

  • You can have a full list of components inside of your Forms Application, so it's easier to track every component in each form.
  • You can filter, sort, download the list of components and more using the Actions button from Interactive Report.
  • Determine if the trigger, program unit, list of value, etc. is applicable or not to the conversion process.
  • Assign the priority of the component object.
  • Track if the conversion of the component object is complete or not.
  • Enter notes and assign tags to the component object.

The forms used are:

  • Customers form
  • Orders form

The functionality implemented in both forms are described in the following video:

Let's start by:

  1. Creating a Workspace.
  2. Converting FMBs to XML.
  3. Creating a Migration Project.
  4. Creating the APEX Application.
  5. Customizing the APEX Application - Customers Form.
  6. Customizing the APEX Application - Orders Form.
  7. The Last Enhancements.

At the end of these blog posts you will review and run the final APEX Application created, are you ready?

The APEX version used is

Update: As of APEX 21.1, the Migration Project is desupported. So, please omit steps 2 and 3.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.