Setting Up Oracle Report Manager

Setup Overview

Oracle Report Manager leverages features of Oracle XML Publisher and Oracle Web Applications Desktop Integrator.

When you submit a Standard or Variable Report request, Oracle Report Manager uses the Oracle XML Publisher formatting engine to apply a layout template to the request data to generate the report in the desired output format. Oracle Report Manager then publishes the report to the Reports Repository and to any selected menu items.

When you design a template using the Financial Report Template Editor, Oracle Report Manager uses Oracle Web Applications Desktop Integrator to generate and download the Microsoft Excel spreadsheet to your desktop and then uploads the template to the Oracle XML Publisher Template Manager.

When you view a Financial Statement Generator report in Microsoft Excel, Oracle Report Manager uses Oracle Web Applications Desktop Integrator to generate and download the Microsoft Excel spreadsheet to your desktop.

Setup for Oracle Report Manager therefore includes steps for Oracle Web Applications Desktop Integrator and Oracle XML Publisher.

Implementation steps are listed in the following table. Detailed instructions are given in the sections that follow:

Oracle Report Manager Implementation Steps
Step Required/Optional Product
Set profile option values Optional Oracle Report Manager and Oracle Web Applications Desktop Integrator
Attach functions to user menus Required Oracle Report Manager
Add the Report Manager - Transfer FSG Custom Templates program to a request group Optional Oracle Report Manager
Perform setup for Financial Report Template Editor and Financial Statement Generator reports Conditionally required. Each user of the Financial Report Template Editor and each user who views Financial Statement Generator reports in Microsoft Excel must configure their Microsoft Excel settings and their client PC Web browser settings. Oracle Web Applications Desktop Integrator
Set request concurrent programs to generate XML Conditionally required. Standard and Variable report concurrent programs published by Oracle Report Manager must be set to generate XML in the concurrent program definition. Oracle XML Publisher
Register concurrent programs as Data Definitions in the Template Manager Conditionally required. Standard and Variable reports published by Oracle Report Manager must be registered as a Data Definition in the Oracle XML Publisher Template Manager. Oracle XML Publisher
Create report templates Conditionally required. All Standard and Variable reports published by Oracle Report Manager require an Oracle XML Publisher RTF template. Oracle XML Publisher
Register report templates in the Template Manager Conditionally required. Templates created for use with Standard and Variable Reports must be registered in the Oracle XML Publisher Template Manager. Oracle XML Publisher

Set Profile Options

Use the System Administrator Responsibility to set the following profile options. For more information about setting profile options, see Overview of Setting User Profiles, Oracle E-Business Suite Setup Guide.

Oracle Report Manager Profile Options
Profile Option Name Default Description
FRM: User to Value Owner Access No The profile option is only set at the user level. When set to "Yes" it enables a user to add participating value sets and assign owner access. For more information, see User to Value Security.
Additionally, setting this profile option to "Yes" for a user gives that user owner privileges for all folders and reports in the repository, overriding any repository security restrictions defined for individual folders or reports. See Defining Repository Security.
FRM: Set Auto Archive Null This profile option sets a default value for the Set Auto Archive option on the Publishing Parameters page. Enter a positive integer to specify the number of months from the date of publishing that the report will be marked for archive in the Reports Repository.
For example: To automatically mark reports for archive after one month, enter "1".
Users can override the default value at submission time on the Publishing Parameters page. Note that reports are not actually archived until the Maintain Repository concurrent request is run. For more information, see Archiving Reports.
ADI: Allow Sysadmin to View All Output No Set this to "Yes" to allow users with the System Administrator responsibility to view the output for all users. This option overrides user to value security for System Administrators.
FRM: Excel View Row and Column Headings No Set this profile option to "Yes" to display row and column headings in the Microsoft Excel spreadsheet when users output a report to Microsoft Excel. Row and column headings let users easily select an entire row or column at once to perform actions such as editing, formatting, or copying the row or column.
This profile option is set to "No" by default. When this profile option is set to "No", row and column headings are not displayed unless users manually enable the headings within their Microsoft Excel settings.

Note: If you update this profile option, the change takes effect the next time a user outputs a report to Microsoft Excel. You do not need to republish reports for the change to take effect.

FRM: OOXML Enabled No Set this profile option to "Yes" to enable Oracle Report Manager to create spreadsheets according to the Office Open XML (OOXML) standard. When using the OOXML format, Oracle Report Manager performs the processing to generate Microsoft Excel files for templates and Financial Statement Generator reports on the Oracle E-Business Suite server rather than on the desktop. With this option, no macros are used during document creation and limited macros are used during upload. Consequently, the Trust access to the VBA project object model security option is not required to work with OOXML documents. Additionally, because the processing is performed on the server, the file generation uses minimal desktop resources.

Additionally, check that the following Oracle Web Applications Desktop Integrator profile options are set to appropriate values for the Oracle Report Manager features you want to use. These profile options control both Oracle Web Applications Desktop Integrator and the Oracle Report Manager features that use Oracle Web Applications Desktop Integrator. For more information, see: Setting Profile Options, Oracle Web Applications Desktop Integrator Implementation and Administration Guide.

Shared Profile Options for Oracle Web Applications Desktop Integrator and Oracle Report Manager
Profile Option Name Default Description
BNE Enable Digital Signature No Set this profile option to Yes to enable Oracle Web Applications Desktop Integrator and Oracle Report Manager to affix a digital signature to the spreadsheets you create, identifying them as coming from a trusted source. You can then select a macro security level in Microsoft Excel that requires digital signatures when working with these spreadsheets.
BNE Server Log Level ERROR This profile option determines the level of detail that is recorded in the Oracle Web Applications Desktop Integrator log file. Additionally, if you set this profile option to TRACE, then Oracle Report Manager does not delete the ReportManager.xls file after the report spreadsheet has been created. If you set any log level other than TRACE, then Oracle Report Manager displays the ReportManager.xls file while the report is being created, but deletes this file when the report rendering is complete. The recommended value for a production environment is ERROR.

Attach Functions to Navigation Menus

Use the System Administrator responsibility to assign the Oracle Report Manager menu items to the navigation menus of the appropriate responsibilities. For more information on adding functions to menus, see Navigation Menus, Oracle E-Business Suite Security Guide.

Following are the Oracle Report Manager user function names:

In addition, users access Oracle Report Manager every time they view a report published by it. In this case, the reports being distributed by menu items created by report producers can be placed in any responsibility.

Note that the View Reports page is secured by the FRM_REP_MANAGE_WORKBENCH (Repository Management) function. You must add this function to a responsibility assigned to a user to enable that user to access the page and view reports.

Additionally, the following features are secured by the BNE_ADI_CREATE_DOCUMENT function:

Consequently, you must add the BNE_ADI_CREATE_DOCUMENT function to a responsibility assigned to a user to enable that user to view Microsoft Excel output and to use the drilldown links. You must also add this function along with the Financial Report Template Editor menu item, to enable a user to work with Financial Statement Generator templates.

Add the Report Manager - Transfer FSG Custom Templates Program to a Request Group

The Report Manager - Transfer FSG Custom Templates concurrent program lets you transfer custom Financial Statement Generator report templates between Oracle E-Business Suite instances. Before a user can run this program, you must add the program to the request group for a responsibility assigned to that user. See Request Security Groups, Oracle E-Business Suite Setup Guide.

Note: For releases earlier than Oracle E-Business Suite Release 12.2.9, you must first apply a patch to make the Report Manager - Transfer FSG Custom Templates concurrent program available in your instance. See My Oracle Support Document 2338674.1, Oracle Report Manager Release Notes for Patch 26879913:R12.FRM.C.

Perform these steps on the target Oracle E-Business Suite instance to which you want to transfer templates.

  1. From the System Administrator responsibility, choose Security > Responsibility > Define. In the Responsibilities window, query the responsibility from which you want users to run the transfer program and make a note of the name of the request group for that responsibility. For example, if you want users to run the program from the System Administrator responsibility, note that the request group for that responsibility is named System Administrator Reports.

  2. From the System Administrator responsibility, choose Security > Responsibility > Request. In the Request Groups window, query the request group you noted in the previous step. Add the Report Manager - Transfer FSG Custom Templates program to this group and save your work.

Set Up Financial Report Template Editor and Financial Statement Generator Reports

Oracle Report Manager uses the Oracle Web Applications Desktop Integrator integration with Microsoft Excel to generate spreadsheets for the Financial Report Template Editor and for the Microsoft Excel output for Financial Statement Generator reports. The following setup is required to use these features.

Prerequisites

Using the Office Open XML Format

Beginning in Release 12.2.5, you can choose to create templates and Financial Statement Generator reports according to the Office Open XML (OOXML) standard, an XML format developed by Microsoft to represent spreadsheets and other types of documents. When using the OOXML format, Oracle Report Manager generates the spreadsheet entirely on the Oracle E-Business Suite server, and the completed spreadsheet is then downloaded to the desktop. With this option, no macros are used during document creation and limited macros are used during upload. Consequently, the Trust access to the VBA project object model security option is not required to work with OOXML documents. Additionally, because the processing is performed on the server, the file generation uses minimal desktop resources. To use the OOXML format for your Oracle Report Manager spreadsheets, set the FRM: OOXML Enabled profile option to "Yes".

Migrating Financial Report Templates to the OOXML Format

If you have existing financial report templates that were created before you enabled the OOXML format, then you must migrate these templates to the new format. To do so, submit a concurrent request for the Report Manager - Template Migration (FRM_TEMPLATE_MIGRATION) program. See: Running Reports and Programs, Oracle E-Business Suite User's Guide.

For testing purposes, when you run the Report Manager - Template Migration program, you can optionally select the code for an individual template in the Template Code parameter to convert only that template to the OOXML format. When you enable OOXML in your production system, however, you should migrate all existing templates to the OOXML format by running the program with the Template Code parameter left blank.

Selecting Macro Security Settings in Microsoft Excel

In Microsoft Excel, you must select the macro security settings that you want to enable the macros used by Oracle Report Manager.

You can choose to set a medium macro security level, in which case you are prompted to enable the macros each time you open an Oracle Report Manager spreadsheet. Alternatively, you can set the BNE Enable Digital Signature profile option in Oracle E-Business Suite to have Oracle Report Manager affix a digital signature to the spreadsheets you create. In this case, you can select a high macro security level in Microsoft Excel. After you initially identify the Oracle Report Manager macros as coming from a trusted source, Microsoft Excel automatically allows the macros to run.

Settings for Unsigned Spreadsheets

If you do not use digital signatures in Oracle Report Manager, then you must set your Microsoft Excel macro security to let you enable macros on a case by case basis. The steps to do so may vary depending on your version of Microsoft Excel. For example:

For Microsoft Excel 2010, 2013, and 2016:

  1. Choose the File tab, and then choose Options. In the Options dialog box, choose Trust Center and then Trust Center Settings. In the Trust Center, choose Macro Settings.

  2. Select the Disable all macros with notification option.

  3. If you did not enable OOXML, then select the Trust access to the VBA project object model option.

    Note: If you enabled OOXML, then this option is not required.

With these settings, Microsoft Excel prompts you to enable the macros whenever you create or open an Oracle Report Manager spreadsheet.

Settings for Digitally Signed Spreadsheets

If you want to use digital signatures in Oracle Report Manager, set the BNE Enable Digital Signature profile option to Yes. When this option is set, Oracle Report Manager affixes a digital signature to the spreadsheets you create. You can then select a macro security level in Microsoft Excel that requires digital signatures. The steps to do so may vary depending on your version of Microsoft Excel. For example:

For Microsoft Excel 2010, 2013, and 2016:

  1. Choose the File tab, and then choose Options. In the Options dialog box, choose Trust Center and then Trust Center Settings. In the Trust Center, choose Macro Settings.

  2. Select the Disable all macros except digitally signed macros option.

  3. If you did not enable OOXML, then select the Trust access to the VBA project object model option.

    Note: If you enabled OOXML, then this option is not required.

With these settings, the first time you create a signed Oracle Report Manager spreadsheet, you must identify the Oracle Report Manager macros as coming from a trusted source. Subsequently, whenever you create a signed spreadsheet, Microsoft Excel automatically allows the macros to run.

Note: If you create a digitally signed spreadsheet, it is recommended to work without saving in order to preserve the signature. If you save an Oracle Report Manager spreadsheet, then the Oracle signature is discarded, because the content of the spreadsheet is no longer controlled by Oracle. To continue working on the spreadsheet, you can use one of these options:

Selecting Microsoft Internet Explorer Settings

If you use Microsoft Internet Explorer as your Web browser, select the following downloads setting so that you can download the spreadsheets created by Oracle Report Manager to your desktop.

  1. From the Tools menu, select Internet Options and then select the Security tab.

  2. Select the zone in which you are working, such as Trusted Sites, and select the Custom level button.

  3. In the Downloads settings, select Enable for the File download option.

Additionally, select the following scripting setting so that Oracle Report Manager can complete the spreadsheet creation process.

  1. From the Tools menu, select Internet Options and then select the Security tab.

  2. Select the zone in which you are working, such as Trusted Sites, and select the Custom level button.

  3. In the Scripting settings, select Enable for the Allow status bar updates via script option.

Creating FrmFsgImages Directory and Setting Permissions

This step is required only for the Financial Report Template Editor. To enable the Financial Report Template Editor to upload the images in your template to your Web server, you must create a directory for the images to be uploaded to, as follows:

  1. Create the FrmFsgImages directory in the physical directory designated by the OA_MEDIA virtual directory on your Web server. For information on the OA_MEDIA directory in your installation, see your Web server administrator.

  2. Set the permissions on the FrmFsgImages directory to allow reading and writing for the process running your Web server.

Perform Setup Required for Standard and Variable Report Publishing

Every standard or variable report that you wish to publish through Oracle Report Manager must first be set up in Oracle XML Publisher. Beginning with Oracle E-Business Suite 11.5.10, some reports are delivered with the Oracle XML Publisher components and therefore will not require any additional setup.

For those reports not delivered with Oracle XML Publisher components, following is an overview of the setup steps. For complete information, see the Oracle XML Publisher Administration and Developer's Guide, available from My Oracle Support Document 1640073.1, Notes for Using Oracle Business Intelligence Publisher 10g in Oracle E-Business Suite Release 12.2.

  1. Set the report concurrent program to generate XML.

    This can be achieved in one of two ways:

    • If you plan to publish the Standard report only using Oracle Report Manager, use the Concurrent Programs window to change the Output Type of the report definition to XML.

    • If you plan to generate another output from the Standard report (such as Text), you may want to use the "Copy to" feature of the Concurrent Programs window to create a duplicate of the existing program. Set the Output Type of the copy of the concurrent program to XML.

    Note: For more information, see Concurrent Programs Window, Oracle E-Business Suite Setup Guide.

  2. Create a layout template for the report using Microsoft Word.

  3. Register the concurrent program as a Data Definition in the Oracle XML Publisher Template Manager.

  4. Register and upload your layout template to the Oracle XML Publisher Template Manager.