Migrating Oracle forms and report application from 10g to 12c

oracle oracle-sqldeveloper oracleforms oraclereports
Vivek Pant picture Vivek Pant · Feb 16, 2016 · Viewed 10.9k times · Source

We have a oracle forms and reports application build in 10g. We are planning to migrate the application to 12c from 10g.

can we simple compile the forms in 12c like we do in 10g ? or we need to re write the complete code again in 12c builder.

If anyone have any article on this, please share the link. That will be really helpful to understand the requirements for migration.

Thanks

Answer

Sten Vesterli picture Sten Vesterli · Feb 22, 2016

On the Forms side, you generally only need to recompile your Forms with Forms Designer 12c. There are a few minor changes that you can quickly fix.

On the server side, however, you need to move from Oracle Application Server to WebLogic. Oracle does not document the process for moving directly from Forms 10g to 12c, so it would probably be easiest for you to migrate to 11c first and then to 12c:

  1. Follow the instructions in "Fusion Middleware Upgrade Guide for Oracle Portal, Forms, Reports, and Discoverer" (http://docs.oracle.com/cd/E12839_01/upgrade.1111/e10130/toc.htm) to move from Forms 10g to 11c
  2. Follow the instructions in "Oracle Fusion Middleware Installing Oracle Forms and Reports," chapter 5 (https://docs.oracle.com/middleware/1221/formsandreports/install-fnr/upgrade_forms.htm#FRINS420) to move from Forms 11c to 12c.

Related questions

How to export query result to csv in Oracle SQL Developer?

I'm using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window doesn't give me any export options.

Read More
Changing password with Oracle SQL Developer

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. I can't get the SQLPlus command "password" to work in SQL developer. When I hit run, I get an invalid command …

Read More
How to generate an entity-relationship (ER) diagram using Oracle SQL Developer

I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. What is the process for creating an ER diagram in SQL Developer?

Read More