8Reports

This chapter contains the following:

Financial Compliance Reports

You can run the following reports about Financial Reporting Compliance.

Assessment Reports

Assessment reports include:

Report Title Description

Assessment Details Report

Displays information about assessments conducted against selected objects.

Control Assessment Report

Lists controls and their related assessment activities in PDF format.

Control Assessment Extract

Lists controls and their related assessment activities in a format for export to an application such as a spreadsheet.

Control Reports

There's a single control report:

Report Title Description

GRCM Control Details Report

For each in a selection of controls, gives the name, description, and other defining values; identifies users who created or updated it; and tells when they did so.

Issue Reports

Issue reports include:

Report Title Description

Issue Details Report

Provides information about selected issues, including the object each issue is raised against, issue status and state, users who created and updated the issue, and when they did so.

Issue Listing Extract

Provides similar information in a format for export to an application such as a spreadsheet.

Risk Reports

Risk reports include:

Report Title Description

Risk Control Matrix Report - Financial Governance

Documents the relationships of selected processes, risks, or controls to other objects and perspective values.

Risk Control Matrix Extract - Financial Governance

Provides similar information in a format for export to an application such as a spreadsheet.

Business Intelligence Analyses

Apart from these reports, predefined dashboards provide analyses (displays of real-time data) that track change history, identify records that aren't accessible by any user, and identify perspective hierarchies and values that aren't assigned to any object. These dashboards are available in the Oracle Business Intelligence Catalog.

Run Reports

You can run reports on demand or schedule them to be run at intervals over a period you define. The reporting management page saves the scheduled reports it generates, enabling you to view them at any time.

  1. From the home page, open the springboard for the module whose reports you want to run, Financial Reporting Compliance or Advanced Controls. Then select the Reports icon. Or, open the Navigator and select the reporting option for either module.

  2. Open the Related Links panel tab and select a category of reports.

  3. The reporting management page lists reports belonging to the category you selected. Click in the row for the report you want to run.

  4. Click the Run Now action or the Schedule action.

  5. A Parameters dialog opens. In it, select parameter values to focus the content of the report.

  6. If you selected Run Now, the Parameters dialog displays a Submit button. Click it to generate the report.

    If you selected Schedule, this button is replaced by a Schedule Information button. Click this button to produce a Schedule Parameter dialog. Enter values that set a name for a schedule, the date and time it should start, how regularly the report should run, and the date and time (if any) the schedule should expire. Then click the Schedule button.

Report Parameters

You can select parameter values that focus the content of reports you generate. Parameters vary from one report to another. In general, they correspond to the selections users make as they work with the object you're reporting on. As you set parameters, you would select among the same values.

For example, a Control Details Report enables you to select among values you would set as you work with Financial Reporting Compliance controls. You can filter by name; select controls with specific method, frequency, or stratification values; designate controls associated with particular perspective values; or select other values that apply to controls. You may also select a report format, either PDF (Adobe Acrobat file) or CSV (a text file for export to another application, such as a spreadsheet).

Select parameter values in the Parameters dialog that opens as you run or schedule reports.

Save Parameter Values

You can save sets of parameter values, so that you can select them easily as you run reports:

  1. In the Parameters dialog that opens when you select the Run Now option in the reporting management page, select a set of parameter values. Then click the Save Report Parameters button.

  2. A Create Saved Report Parameters dialog opens. In it, create a name for the set of parameter values, and click the OK button.

To use a set of saved parameter values, select it in the Select Saved Report Parameters field, which appears in the Parameters dialog as you run or schedule a report.

In this field, you can select a Personalize option. This opens a Personalize Saved Report Parameters dialog. Select one of the sets of saved parameters. Then do any of the following:

  • Click the Delete button to delete the set of saved parameters.

  • Select or clear a Show in Saved Report Parameters check box to make the set of parameters available, or hide it, in the Select Saved Report Parameters field.

  • Select or clear a Default Report Parameter check box to apply the set of parameters each time you run the report. (Select this option for only one set of parameters per report. Clear the existing selection before setting this option for a new set of parameters.)

Select the Apply button in the Personalize Saved Report Parameters dialog to implement your selections, and the OK button to close the dialog.

Review Scheduled Reports

If you schedule a report to run, the reporting management page can display a row for each generation of the report. Or, it can display a row for each schedule configured for the report.

To view a report generated on a schedule:

  1. Click the title of the report you want to see.

  2. Click Display, then Report History.

  3. Click the row representing the instance of the report you want to see. Then select the View Report action.

(To remove an instance of a report, click its row and then select the Delete action.)

To view or modify a report's schedule:

  1. Click the title of the report whose schedule you want to see.

  2. Click Display, then Scheduled Reports.

  3. Click the row representing a current schedule. (Schedules that have reached their end dates are removed from the list.) Then select the Manage Report Job Schedule action. The Schedule Parameters dialog reopens. You can:

    • Enter modified schedule values and select a Reschedule button.

    • Discontinue the schedule by selecting a Cancel Schedule button.