This chapter covers the following topics:
Oracle Report Manager is an online report distribution system that provides a secure and centralized location to produce and manage point-in-time reports.
Oracle Report Manager users can be either report producers or report consumers. Report producers submit, publish, and set security for reports. Report consumers view and approve 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, you can use your templates to integrate reports displayed by Report Manager using your organization’s individual style.
Oracle Report Manager:
Provides a centralized report distribution system for point-in-time reports.
Enables information producers to submit and publish Financial Statement Generator (FSG), Ad Hoc FSG, Variable Format, and Standard reports to a central repository.
Enables information producers to present reports in the repository to information consumers via menu items on the Oracle E-Business Suite Home page or portal.
Is accessible by any Oracle E-Business Suite user using a Web browser.
Offers approval requirement before making reports available for general viewing.
Permits report availability in a future timeframe.
Allows you to view spreadsheets or PDF files for further analysis.
Secures reports by three content security paradigms - User to Value, custom, and flexfield segment - as well as by repository security.
Provides an archive facility to maintain reports for future reference that no longer need to be displayed to report consumers.
Enables the publishing of reports that have been submitted as part of request sets or report sets.
Enables you to upload any type of file and publish it to a central repository. Reports in the repository can then be distributed to the Oracle E-Business Suite home page.
There are four types of reports you can access through the Oracle E-Business Suite Home page:
Single Report: A complete report for a specific time period. For example, your corporate income statement for May 2002.
Single Report Over Time: A single report produced for different periods. For example, your corporate income statement for the periods April, May, and June 2002.
Expanded Report: One report displayed in a variety of ways depending upon an expansion value. For example, you can publish your corporate Income Statement for May 2005 based on department. User views of the Income Statement are limited to those departments for which the user has viewing privileges.
For Financial Statement Generator (FSG) reports, reports are expanded by content sets. Content sets are defined in Oracle E-Business Suite. For example, if a content set for departments is set up, then applying it to a report creates a separate report for each department.
Expanded Report Over Time: An expanded report available for different time periods.
The system administrator assigns Report Manager menu items to various responsibilities. Following are the available menu items:
Financial Report Submission
Financial Report Template Editor
Repository Management
Security Workbench
Standard Report Submission
Upload File
Variable Report Submission
Publish Report Set
Define Report Set Publishing Options
Publish Request Set
Define Request Set Publishing Options
Ad Hoc FSG Submission
Report access generally varies by responsibility. The following example gives a likely scenario of an implementation of Oracle Report Manager menu items.
Responsibility: General Ledger
Menu Item: Financial Report Submission
Menu Item: Financial Report Template Editor
Menu Item: Publish Report Set
Menu Item: Define Report Set Publishing Options
Menu Item: Ad Hoc FSG Submission
Responsibility: Report Manager Administration
Menu Item: Security Workbench
Menu Item: Repository Management
Menu Item: Upload File
Menu Item: Financial Report Template Editor
Responsibility: Manufacturing Operations
Menu Item: Standard Report Submission
Menu Item: Publish Request Set
Menu Item: Define Request Set Publishing Options
Responsibility: Financial Assets
Menu Item: Standard Report Submission
Menu Item: Variable Report Submission
Responsibility: Accounts Payable
Menu Item: Standard Report Submission
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.