Q&A Forms to APEX on autonomous database

Does it surprise you that APEX is increasingly finding its way into companies? Almost 2/3 of over 150 companies that have participated in our webinar series “Oracle Forms Goes APEX 20.1 and Autonomous Database” so far stated they are operating APEX apps side to side with their business-critical Oracle Forms-based systems.
Clearly, this is an excellent opportunity to integrate Oracle’s Autonomous Database
(ADB). Companies can make use of its automated database maintenance services – especially when administrating several databases, which more than half of the participants said they are doing.
See the FAQs from this webinar, which helps you on the way to autonomous.

List of questions to Forms Development

How to export the application on Weblogic?

There are no specific changes. Apex Application running on the Weblogic are 100% compatible with the autonomous database in the backend. There are no restrictions.

What kind of Identity Management is available in APEX?

Identity Management in Oracle APEX consists of 2 Components: authentication and Authorization. 

Authentication is the process of establishing each user’s identity before they can access your application. In Application Express, you can create authentication by:

  • Selecting a built-in authentication scheme
  • Creating a custom authentication scheme

The following are pre-configured Oracle APEX authentication schemes:

  • Open Door Credentials
  • Application Express Accounts
  • Database Accounts
  • LDAP Directory
  • No Authentication (Using DAD)
  • Oracle Application Server Single Sign-On
  • Custom
  • HTTP Header Variable
  • Social Sign-In


Authorization involves controlling access to resources based on user privileges. You can use authorization schemes to implement authorization in an application. You can apply an authorization scheme for:

  • An entire application
  • A page
  • Specific control such as a region, item, or button
Is APEX a true replacement to Oracle Forms with all complicated features Forms have?


There are more similarities with Forms and Oracle APEX. Forms Developers are easy to train, because they already know SQL and PLSQL. If you want to make a modernisation for your forms application, Oracle APEX is definitely the best way to go. During our Modernization process  we remove all  unnecessary components that we don’t need in Oracle APEX. Example we remove Alerts, Graphics etc…  and we have 4 Phases for forms Modernization.  The first Phase is very important: The first phase, the preparation phase, consists of the following steps:

  • Forms analysis
  • Dead code cleanup
  • Move Business Logic to the database
  • Merging redundancies
  • Clearing the forms of objects that are not needed
Is there a true 1:1 conversion of existing Forms to APEX ?

We cannot migrate 1:1 Oracle Forms  to APEX, because there are better components that we can use in Oracle APEX. We try to use new modern components in Oracle APEX during our modernization process.

How to migrate Oracle Forms to APEX?

You can use the PITSS modernization process to migrate Oracle Forms to APEX. Our modernization process consists of:

  • Forms Preparation (Forms analysis, Dead code cleanup, Move Business Logic to the database, Merging redundancies, Clearing unused Objects)
  • Migration ( Refine the Architecture for Forms Application, APEX Migration)
  • Application Fine Tuning (Refine Output, Business Logic Redesign, UI Enhancing)
  • Rollout (Integration & Test)
What is the best strategy to migrate from Forms to APEX ?

The best strategy is to use the PITSS modernization process.

What considerations should we have before performing the migration?

We need to do following steps performing the migration

  • Forms analysis
  • Dead code cleanup
  • Merging redundancies
  • Move Business Logic to the database
  • Clearing the forms of objects that are not needed
What are the benefits of what APEX can do vs a traditional Oracle EBS Form can do?

APEX is more general, has more features, APEX can connect with remote data service, APEX can integrate several data formats, etc. With this APEX complement and extend the EBS forms functionalities.

How can APEX help us accomplish our business needs?

Oracle APEX has been designed from the very beginning to help developers build modern, beautiful, responsive applications without the need to become experts. Oracle APEX does the following for you

  • Eliminating Complexity: Oracle APEX eliminates the complexity of developing and deploying applications at all layers.
  • Simple Development: Oracle APEX is easy to use and easy to learn
  • Secure: Oracle APEX is designed to build web apps which are highly secure out of the box
  • Portable: You can run Oracle APEX everywhere – on the Oracle Cloud, on-premises, or anywhere else there is an Oracle Database.
What is the best way to do a migration from Forms to APEX?

Follow our proven methodology.
Start with an analysis of the existing application to identify obstacles, decide architecture and calculate time, effort and budget.
Use a preparation phase to document the application and eliminate technical debt.
Then start the migration.

Is there a tool to migrate Oracle Forms & Reports to APEX?

PITSS provide the Forms Replacer Kit as a tool to do all necessary steps on the way from Oracle Forms to APEX. Starting with the analysis of all source code, eliminating technical debt, configure the proper architecture in APEX, running the migration and supporting the necessary fine tuning. The product is checked by Oracle and certified to generate APEX applications running on Oracle autonomous database. 

How much conversion work is there?

This depends on the complexity of the existing Oracle Form landscape and could be easily calculate with PITSS Forms Replacer Kit. We rely on these numbers in our fix price projects. 

How easily we can migrate an Oracle Forms applications to APEX 20.1?

The best way to migrate Oracle Forms 2 APEX is to use our PITSS.CON tool. We can migrate forms to any version of APEX

How to migrate 6i to APEX?

You could use PITSS Forms Replacer Kit to migrate direct from Oracle Form 6i to APEX.

What elements or processes (For example: send email, working with excel, word, file upload / download from and to the client) could be the most difficult to migrate from Oracle Forms to APEX?

We don’t need to migrate all of the above components to Oracle APEX as we have all of these components in Oracle APEX out of the BOX.

Most complex replacement is the usage of Function-Keys in Oracle Forms. 

How to implement heavy pages and tons of info on the same page as Forms does?

What you mean is a single page application. You can use the Oracle APEX Page Designer as an example. The page designer is a single page application.

With the page designer you can do everything on one page. You can insert delete and update form data without reloading the page.

To create an application like a page designer you need to work with:

  • Dynamic actions
  • Ajax requests
  • Javascript


However, if you want to build a more complex single-page application in Oracle APEX. There is a better way of doing this. You can integrate below JavaScript Frameworks in Oracle APEX:

  • Vue js
  • React JS
  • Angular.
  • etc..
How can I identify where to start in my migration from Oracle Forms to APEX?

Within the analysis with PITSS Forms Replacer Kit we calculate and advise clusters to split the monolithic Application down into smaller apps. Clusters allow a staged approach for go live and the coexistence of Forms and APEX during the migration phase. We advise clusters in which the customer could start getting familiar with APEX.

How Forms which are build using template.fmb in Oracle EBS will be moved as it has lot of EBS related objects?

There is no general solution for this case, but the analysis will figure out the possibilities. For more detail information see Oracle Documentation for “Extending Oracle E-Buines Suite using Oracle APEX” https://www.oracle.com/technetwork/developer-tools/apex/learnmore/apex-ebs-extension-white-paper-345780.pdf

How to migrate Oracle Form 11g master/detail to APEX Form easily?

PITSS Forms Replacer Kit is the best way to go. You saw in the demo how we migrate a form app to APEX. After the migration, you saw a master / details relationship component. We were able to identify the master / detail relationship for the form and migrate to Oracle Apex using APEX components(APIs)

What's about mixing Forms and/or APEX in the cloud, database on premises?

Yes, that is definitely possible. You can have a hybrid environment with Forms and APEX and with components on the cloud and on-premises. 

Are we going to use Forms directly in Oracle APEX application?

No, with the migration you get rid of the former Oracle Forms framework. No wrapper – pure APEX

I want to create interactive parent/child Form in Oracle APEX?

To create an interactive parent/child Form in Oracle APEX you have many possibilities: you can use Interactive Grid master detail forms:

  • Stacked
  • Side by Side
  • Drill Down
  • You can also use a Report with Form in Oracle APEX

Any question left?

Could you find all the answers to your questions on this page? If not, we will be happy to be there for you personally and clarify all open points. Just fill out the form below and we will get back to you as soon as possible.

[ninja_form id=6]