Deploying Oracle Report Manager R12.1

on Tuesday, 01 January 2013. Posted in Blog, Oracle Financial Applications

Oracle Report Manager is the online report distribution system that provides a secure and centralized location to produce and manage point-in-time reports. Reports can be published and presented to certain responsibilities without additional security or a variety of security models can be applied, allowing only authorized users to view entire reports or parts of reports. In addition, we can use specific templates to integrate reports displayed by Report Manager using the organization's individual style. The key benefit of Report Manager in R 12.1 is that the report can be directly viewed and opened in Excel (as against earlier releases wherein it can be viewed only in PDF or html).  

The approach to deploy should begin by looking at the Menu Functions that are available. Oracle does not seed specific responsibility for being used to run Report Manager, as the reports could be called and published from any of the base application’s responsibility. Hence, the suggested approach of Oracle is to add these functions to the appropriate responsibility. 

 1. Financial Report Template Editor

2. Financial Report Submission

3. Report Set Publish

4. Report Set Publishing Options

5. Ad Hoc FSG Submission

6. Security Workbench

7. Repository Management

8. Upload File

9. Standard Report Submission

10. Request Set Publishing Options

11. Variable Report Submission

 The following table lists, one of the suggested approach to associate the above Functions to specific responsibility: 

Responsibility Menu Function to be added to it from above
General Ledger Financial Report Template Editor
  Financial Report Submission
  Report Set Publish

Report Set Publishing Options


Ad Hoc FSG Submission

  FSG Drilldown: Launch Page *
  FSG Drilldown: Select Content Set Rows *
  FSG Drilldown: Effective Range Selection Page *
  FSG Drilldown: Balance Inquiry Page *
  Account Analysis and Drilldown *

Report Manager Administration

Repository Management


Upload File


Financial Report Template Editor


General Operations

Standard Report Submission


Request Set Publishing Options

Financial Assets Standard Report Submission

Variable Report Submission

Copyright 2018 All rights reserved.