1. Create reports Tool instance

For communitcation between forms and reports we need reports Tool component. The only way to create a reports Tool is to use Weblogic Scripting Tool (wlst)

 

 Create Report Tool

/u01/middleware/oracle_common/common/bin/wlst.sh

connect('weblogic','')

Connecting to t3://localhost:7001 with userid weblogic ...

Successfully connected to Admin Server "AdminServer" that belongs to domain "frdomain".

Warning: An insecure protocol was used to connect to the server.

To ensure on-the-wire security, the SSL port or Admin port should be used instead.

 

createReportsToolsInstance(instanceName='reptool1', machine='AdminServerMachine')

 

If you want you are able to delete this reports tool with delete Reports Tool

deleteReportsToolsInstance(instanceName='reptool1')

 

2. Create Report Server

After we have created the reports Tools we will create a standalone Report Server. This can be done by EM or by wlst. We have taken wlst.

So start wlst like before and connect to the AdminServer (connect(‘weblogic’))

 

Create Report Server

Creating a Report Server will be:

createReportsServerInstance(instanceName='test', machine='AdminServerMachine')

 

you are able to delete / drop the Report Server. Deleting the Server will delete all configuration for this Report Server too.

 

Delete Report Server

Example of deleting a Report Server

deleteReportsServerInstance(instanceName='test')

 

3. Configure Report Server

After we have created the Report Server we need to configure the connection to the Server. The Security Rules have changed between 10g and 12c. For calling Reports out of Forms we need to run the Web Command /getjobid. This was allowed under 10g by default, but with Version 12c it is denied. So the first step will be to allow some access Commands for this Report Server.

Under Forms / Reports 12c we have to enable : To enable connection to the report server we have to enable webcommandAccess to L2

 

For this we need the connection to the system mbean Browser. We will start via EM- Console. WebcommandAccess is a property out of the Reports Servlet. We will find this Property under Oracle ReportsApp config, rwservlet.

Please lock and edit this screen Goto the Property WebcommandAccess and change to “L2”

 

After we have changed press apply and activate the changes.

 

Change Security Id for the Report Server

Within Oracle Forms / Reports there is a new Property called “SecurityID”. This Property will force the url /getjobid for a username and password. Normally using the forms build_in run_report_object we do not use a username/password for connection to the report Server. So right now we have to turn off this feature.

We use the System MBean Browser and goto the newly created Report Server.

 

We will set this property to “null”.

Please apply and activate.

 

Add Report Server Information

At the moment the report server does not know where to find the Reports, the Language he has to work with and so on. 

Within 12c the configuration Template has changed. We have to create an EnvId. Under this EnvId we will setup all the information we need. All this information will be stored inside the file called server.conf.

This file will be placed under DOAMIN_HOME/config/fmwconfig/components/ReportServerComponent/<NAME OF REPORTS SERVER>/server.conf.

To create the EnvId we will use the System MBean Browser again.

Go to the oracle reports serverconfig, rwserver_<ReportServerName>

 

On Tab Operation’s you will find “addEnvironment”.  Press this Operation to add a new Environment. The only think you have to do give this a Name

After press Button “Invoke” and activate your changes. After you have done  refresh the screen by pressing the Refresh Button.

 

Change the Information

On the new EnvId you will find on the Operation’s tab „addEnvVariable“. Press this and than we are able to add information to this Environment.

 

The first we have to add is the Path to all the reports we want to use. So we will create a Variable called REPORTS_PATH. Insert all the Folder we have reports inside.

Press Button invoke and activate these changes.

Set default envId for this engine

 

For using this envId we have to setup a default Id for this server Engine.

Inside the Reports Servers Properties you will find „DefaultEnvId“ for this engine. We have to change to the name oft he Id we have created. The name of the id is case sensitive.

 

Apply and activate.