Configure jobStatusRepository in Oracle Reports 12c

Posted by Dirk Nachbar on Wednesday, September 21, 2016 with 1 comment
Within this blog post I will show you how to configure the Oracle Reports 12c jobStatusRepository against an Oracle Database.

Within Oracle Reports since release 11.x a major change is, that within the jobStatusRepository configuration, we have now to use an entry in the Credential Store Facility (CSF).

At first create in your target database for the Reports Server Queue a user:

create user rwadmin identified by "Oracle12c" default tablespace users quota unlimited on users;
grant create table to rwadmin;
grant create view to rwadmin;
grant create trigger to rwadmin;
grant create procedure to rwadmin;
grant create sequence to rwadmin;

After you have created your user for the Reports Server Queue, go to the $ORACLE_HOME/reports/admin/sql directory of your Oracle Forms & Reports Installation, open a sqlplus and connect to your target database with the above created user and execute the rw_server.sql. This will create all necessary and required objects for the Reports Server Queue.

SQL> connect rwadmin/Oracle12c@<your tnsnames_entry>
SQL> @rw_server.sql

As next we need to create an entry in the Credential Store Facilty. For this connect to your Enterprise Manager for Fusion Middleware http://server:port/em and select from the WebLogic Menu the Option "Security / Credentials"

Here we need to create a Map

Providing a Map Name, e.g. reports and confirm with OK

After creating the Map, you should see as following and we can now create a Key attached to our Map.

Provide following informations:

  • Select the Map, in this example "reports"
  • Leave Type with "Password"
  • Provide User Name = choose Oracle Database User from above
  • Prove the Password of the Oracle Database User 2 times
  • Optionally you can provide a description

After you have created the Key, you should see following:

The next step would be normally to invoke the System MBean Browser in order to configure your jobStatusRepository, but as there is a small "unexpected feature" (some people call it even a bug :-) ), I will go now directly into the configuration file of the underlying Reports Server and add the necessary elements.

Simply go to the Directory $DOMAIN_HOME/fr_domain/config/fmwconfig/components/ReportsServerComponent/<your_reports_server_name> and open the configuration file rwserver.conf with an editor.

In case you are using the System MBean Browser to configure the below settings, the System MBean Browser will not add the necessary class reference "oracle.reports.server.JobRepositoryDB" and will cause that you can not startup your Reports Server.

For the below configuration provide the following values:

  • dbpassword = csf:<Your_Map_Name>:<Your_Key_Name>
  • dbconn = <Your_DB_Servername>:<LISTENER_PORT>:<ORACLE_SID>
  • dbuser = <Your_DB_Username>

   <jobStatusRepository class="oracle.reports.server.JobRepositoryDB">
      <property name="dbpassword" value="csf:reports:reports_repository"/>
      <property name="dbconn" value="forms12:1521:FRREPO"/>
      <property name="dbuser" value="rwadmin"/>

Finally restart your Reports Server

./ <Your_Reports_Server_Name>
./ <Your_Reports_Server_Name>

Now you can generate a Report and you should be able to see the executed Reports in your Reports Server Queue in the Database