36 Oracle Reports

This chapter describes issues associated with Oracle Reports. It includes the following topics:

36.1 General Issues and Workarounds

This section describes the general issues and their workarounds.

36.1.1 Assigning Reports Target to an Agent in Multi-Agent Case

When a Farm has multiple Enterprise Manager agents, Reports target in a particular Instance may not be assigned to an agent automatically. This may lead to some data loss in Reports Enterprise Manager pages.

Perform the following steps to fix this issue:

  1. Log in to Enterprise Manager.

  2. From the Farm menu, select Agent Monitored Targets.

  3. Click the Configure icon for the target that does not have any agent assigned to it.

    The Configure Target page is displayed.

  4. Click Change Agent.

  5. From the Agent Host drop-down list, select the appropriate agent.

  6. Click OK.

36.1.2 Mapping Users and Roles to Reports Application

11g Release 1 (11.1.1.2.0) installation, roles and users are not added to the Reports application, by default. To run a report using JPS security, you must add roles and users to the Reports application.

For more information, see:

36.1.3 Viewing Your Report in Adobe Reader 9

If you pass the argument pdfuser=xxxx&pdfsecurity=NOCOPY and try to open the report in Adobe Acrobat reader 9, the PDF Security option does not work.

To workaround this problem and to view your report in Adobe Reader 9, You must:

  • Pass the argument in the order, pdfsecurity=NOCOPY&pdfuser=xyz

    OR

  • Add the property pdfowner=abc to the current string.

36.2 Interoperability Issues and Workarounds

This section describes interoperability issues and their workarounds. It includes the following topic:

Section 36.2.1, "Interoperability between Reports 11g Server and Reports 10.1.2.3 Client"

36.2.1 Interoperability between Reports 11g Server and Reports 10.1.2.3 Client

This interoperability scenario requires the patch 7597820 to be installed. You can download this patch from http://updates.oracle.com/download/7597820.html. This patch is required to address the CORBA IDL changes between the two releases for the Job Status information. If you want to use rwservlet of Reports 10g Release 2 (10.1.2.3) with the Reports 11g Release 1 (11.1.1) Server, ensure that you install this patch on 10.1.2.3 installation. You can download this patch from http://metalink.oracle.com.

36.3 Documentation Errata

This section describes documentation errata. It includes the following topic:

Section 36.3.1, "Searching Application Policies and Roles in Enterprise Manager"

36.3.1 Searching Application Policies and Roles in Enterprise Manager

Information about searching application policies and application roles by using Oracle Enterprise Manager is not included in the Publishing Reports to the Web with Oracle Reports Services manual.

To search Application Policies using Enterprise Manager, perform the following steps:

  1. Log in to Oracle Enterprise Manager.

  2. Navigate to the WebLogic Domain menu.

  3. From the WebLogic Domain menu, select Security > Application Policies.

    The Application Policies page is displayed.

  4. From the Search content pane, select the Select Application Stripe to Search radio button and select reports from the drop-down list.

    You can enter the name of the principal and permission in the Principal and Permission fields respectively to refine your search.

    Note:

    If you click Select Application Name to Search and select WLS_REPORTS/reports(11.1.1.2.0) from the drop-down list, none of the application policies will be displayed.
  5. Click the search icon.

To search Application Roles using Enterprise Manager, perform the following steps:

  1. Log in to Oracle Enterprise Manger.

  2. Navigate to the WebLogic Domain menu.

  3. From the WebLogic Domain menu, select Security > Application Roles.

    The Application Roles page is displayed.

  4. From the Search content pane, click the Select Application Stripe to Search radio button and select reports from the drop-down list.

    You can enter the role name in the Role Name field to refine your search.

    Note:

    If you click Select Application Name to Search and select WLS_REPORTS/reports(11.1.1.2.0) from the drop-down list, none of the application roles will be displayed.
  5. Click the search icon.