How to Upgrade or Migrate from Forms and Reports 6i to 12c

 Migrate forms and Reports 6i to 12c in Linux/Unix Environment

1. Ensure the DB and Unix Server are upgraded to 12c version is 12.2.1.19.0

 OS: Oracle Linux Server release 7.9

Database: 19c

2. Once the Environment is set, identify the list of 6i forms to be migrated.

3.First you need to install the forms 10g and Forms 12c,the patch which is available to install Forms and Reports 12c are 

DLP:

Oracle Forms and Reports 12.2.1.19.0 ( Oracle Forms and Reports )

You can download from https://edelivery.oracle.com/osdc/faces/SoftwareDelivery

4.Once you have downloaded and installed you will have frmbld which is the form builder

Forms Migration:

1. First open forms 10g builder and open the 6i form and just save it, without this step if you open directly the 6i form in 12c it will error out and does not allow you to open.

2. Now once the form is saved from 10g builder you can open the form directly in 12c forms builder

3. You need to set the FORMS_PATH just like you set it for forms 10g where all the pll's,olb's and other library files are copied.

4. You need to regenerate or re compile all the 6i plls in 12c and just copy the olb's to the FORMS_PATH

5.All the icons should be copied in icons.jar/frmall.jar file and mention the path of this jar file in the FORMS_PATH in the Linux Server to reflect the icons/images for the buttons.

6.Attach the required pll's in Attached Libraries in the form builder 12c when the form is opened, open the OLB file also if its reading from OLB and then save and compile and ensure that fmx is generated.

7.To Run the form you need to have the URL 

 http://hostname:port/forms/frmservlet?config=webutil_webstart

8.If you have any login form which has to appear initially then in the URL you need not give the form name ,but you can do the setup 

8.When you run this in the browser it will open the form 

To access Web Configuration page: ---> https://docs.oracle.com/middleware/1221/formsandreports/deploy-forms/configure.htm#FSDEP171 ----> Image is displayed

Access Fusion Middleware Control.

From the Fusion Middleware Control main page, click the Target Navigation link to expose the navigation side panel.

In the tree, expand the Forms node and click on the instance you want to configure.

From the Forms page and in the Forms Deployments table, click on Web Configuration and right corner you will have "Lock and Edit option and click on it"

Click on webutil_webstart and down you will have ADD button. Click on it :

Add the following parameters and it's values :

parameter : form

value: S016

next

parameter : userid

value: <give your userid/password@dbconnect string>

Apply and in right top corner you will have "Activate Changes" --Click on it.

Now access your forms URL just until ---> http://hostname:port/forms/frmservlet?config=webutil_webstart

This should solve this issue

9. If you want to download or upload the files from local machine from your forms then you should use CLIENT_TEXT_IO and CLIENT_GET_FILE_NAME builtin functions in 12c forms, for that webutil.pll and webutil.olb is must.If the webutil is not working for some reasons then you can follow the document How to Configure Webutil in Forms 12c (Doc ID 2070183.1)