Oracle 12c Forms / Reports Post Installation Configuration Steps.

How To Configure Oracle Forms And Reports Application.

After Installation of Oracle 12c Forms And Reports.
We will configure the application.
Follow below steps to configure and run the 12c application.

---------------------FOR FORMS------------

Step-1) Change in file Default.env  (default environment file)

Location of this file in the server will be:-

E:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.\config

                                             In Linux, it will be

/u01/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/config/fmwconfig
/servers/WLS_FORMS/applications/formsapp_12.2.1/config

1-a) In this file Enter the Location for.FMX/.PLX/
                                                            image-default.env

Step-2) Change in file Formsweb.cfg (formsweb configuration file)

Location for Formsweb.cfg

E:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig

\servers\WLS_FORMS\applications\formsapp_12.2.1\config

                                             In Linux, it will be

/u01/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/config/fmwconfig

/servers/WLS_FORMS/applications/formsapp_12.2.1/config

2-a) In this file create the named configurations (sets of parameters) in the last of the file.
                                             image-Formsweb.cfg
                                   

2-b) In this file change the name of a first form, database connection string as required.
        You can change the set of the parameter as required like
        width, Hight, colour scheme etc.

Step 3) After doing the above changes Restart the WLS_FORMS by a console.
            to open console use url
            http://server_ip:7001/console
       
                                 

Then after Shutdown click on Start and Start the WLS_FORMS.
Then run the forms using URL
http://server_ip:7777/forms/frmservlet?config=named configuration
i.e.
http://172.31.43.17:7777/forms/frmservlet?config=jois

It will download a jnlp and then run that jnlp using java web start and see the impact on the application.
                                                  image-application
                                         

-------------------FOR REPORTS-------------------------------

Step 4) we know character mode reports are not compatible with the standard report calling methods of oracle like using Rp2rro we cannot run these reports
but for normal reports, we can use this normal means default mode reports.


After configuring the Rp2rro we have to change on some files of Oracle server to run these reports.
the configuration of rp2rro I will show this you on another blog.

change in reserve.conf file (report server configuration file)
Location for this file:-

E:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration
                                                  in Linux it will be
/u01/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/config/fmwconfig/servers/WLS_REPORTS/applications/reports_12.2.1/configuration

4-a) Enter the directory of your reports in this file.
                       

4-b) Restart The WLS_REPORTS by a console.
   

Then run the application and run the reports.

This is the basic configuration for running forms and reports on the application.
Rest all the configurations for application will be published in future.