Oracle Fusion Middleware & Application Server

Monday, August 15, 2016

Oracle Forms & Reports 12c is released since a quite long time and I had now some chance to have a more detailed look on the Oracle Reports 12c component.

After you have successfully installed and configured the Oracle Forms & Reports 12c, you might find out that your Oracle Reports 12c is not working ... because its not yet configured, even you completed the Configuration Assistent successfully :-)

The following steps are describing the necessary tasks for Linux.

There some steps to take as "Post-Configuration":

Create a Reports Tool Instance

Create a Reports Server Instance

if you are running under Linux 7 (either Oracle Enterprise Linux or RedHat) fix libXm.so.3 issue

libXm.so.3 Problem

in case you are using an Oracle Enterprise Linux 7 or RedHat 7, you need to fix a small libXm.so.3 problem. Oracle Reports is looking for the libXm.so.3, but under OEL 7 and RH7 you will find only a libXm.so.4

Adjust the Application Roles within your WebLogic Server Domain

At first you need to login to the Fusion Middleware Enterprise Manager, normally http://<your_server_name>:7001/em and access under the menu "Security / Application Roles"

Within the Application Roles option chose from the drop down menu the option reports, than click on the arrow button, mark the line with the Role Name RW_ADMINISTRATOR and finally click the Edit button to modify the selected role

Under "Edit Application Role : RW_ADMINISTRATOR" use the Add button

In the Add Principal screen, select under the option Type "User", click the arrow button and mark the line with the Principal "weblogic" and proceed with the button OK

The last OK button will redirect you to the Application Roles screen, there simply click the OK button on the top right corner, when everything works fine you will get following Information

Now, you are able to access the Reports Status URLs by providing the username and password of the weblogic user

I have a strange situation for which the approach is not properly defined in Oracle documentation for Forms , it is as below

We are installing Weblogic Cluster via Golden Image from OEM which delivers a Weblogic setup consisting of 5 servers consisting of 2 OHS , 1 Admin and 2 managed server forming a cluster , all part of a domain.

Now on this above setup i need to install Forms and Reports, for installing forms i need to create domain but here i already have one standard Weblogic domain.

So my thought is can i install the Forms and Reports installer and update the existing domain with forms component. Will that work ?