9Reports

This chapter contains the following:

Advanced Controls Reports

You can run the following reports about Advanced Controls.

Result Reports

Result reports include:

Report Title Description

Access Point Report

Lists paths to access points involved in conflicts. Each record in the report isn't a conflict in itself, but rather one path (potentially among many) to one of the access points involved in a conflict. This report applies only to Advanced Access Controls.

Access Violations by User Report

Lists ten users with the greatest number of conflicts, the number of conflicts for each, and information about those conflicts. This report applies only to Advanced Access Controls.

Access Violations within a Single Role (Intra-Role) Report

Lists roles you can't assign individually to any user without a conflict occurring, because each role contains privileges that controls define as conflicting. This report applies only to Advanced Access Controls.

Intra-Role Violations by Control Report

Lists access controls that generate conflicts involving privileges granted within individual roles. It identifies roles that have violated each control, and it lists incidents at the Assigned, Remediate, or Accepted status. This report applies only to Advanced Access Controls.

Global Users Report

Provides information about global users: IDs, each identifying one person and correlating to any number of potentially varying IDs that person may have in business applications subject to advanced controls. This report applies only to Advanced Access Controls.

Result by Control Summary Extract Report

Lists controls that have generated pending incidents, and provides information about each control. This report applies to both Advanced Access Controls and Advanced Financial Controls.

Users with Access Violations by Control Report

Lists access controls that have generated incidents at the Assigned, Remediate, or Accepted status. For each control, it lists users whose work assignments have violated the control. This report applies only to Advanced Access Controls.

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.

From each of the Results by Control Summary and Results pages, you can run reports about the items each page lists.

  1. In either of these pages, filter the list of items to include only the controls or incidents you want the report to cover. For example, you can filter a list to include controls at a particular priority, or incidents at a particular status.

  2. In the Run Report fields, select the report you want to run. Also select Excel as its format. This is the only format available for a contextual report. It produces a file for export to Excel.

  3. Click the Go button. A message identifies a job number. Note the number, then close the message.

  4. Click the Monitor Jobs button to open the Monitor Jobs page.

  5. Locate the row representing the job whose number you noted. When the status displayed in that row reaches Completed, click the Download icon.

  6. A file-download window offers you options to open or save the export file. If you select Open, the report opens in a Microsoft Excel instance. If you select Save, use a distinct save-as dialog to navigate to the folder where you want to save the file.

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.