Run reports

This topic describes how to create and submit report queries, as well as how to access and view the results.

Submit reports

This section provides details on how to submit reports.

Tip: You can also submit a report by interacting with Navigator. For details, see Submit a report.

To submit a report:

Prerequisite: To view or submit reports, you must have the System: Submit Report access grant.
From the main menu, select Reports > Create Report.
In the Submit New Report page, do either of the following to select the report to be submitted:
- In the Recently Submitted Reports section, click the link for the report you want to run.
- In the Select Report by Category section, select the appropriate category for Report Category and then click the link for the report you want to run.
You can only select the reports to which you have access. In addition, the list of available reports are further restricted by security settings on the individual report types. For more information about report security, see the Security Model Guide and Reference.

Once a report is selected, the Submit Report: <Report Name> window opens. This window is also called the "report submission page."
In the Report Parameters section, type or change information in the fields to define the report results.

The fields in this section vary depending on the report you selected. For details on report fields, see the description in:
- The relevant topics in this document. For example, to find information about Deployment management reports, see Deployment Management Reports.
- The applicable Deployment Management Extension document. For example, to find information about report types related to Oracle E-Business Suite, see the Deployment Management Extension for Oracle E-Business Suite Guide.
In the Scheduling and Output Options section, select when to run the report and whether to send a notification when the report is completed.
- To run the report right away, select Run Report Immediately.
- To run the report (once) at a later time, select Run Report On, and select a date.
- To run the report on a periodic basis:
  1. Select Run Report On and provide a date when the report is first run.
  2. Select Repeat Every, and then provide the frequency and the date when the report is last run.
- To send an email notification when the report it completed:
  1. Select the Send email to checkbox.
  2. To send the notification to individual users, select the Users option and then select specific users from the list.
  3. To send the notification to groups of users, select the Security Groups option and then select the relevant user groups.
  4. To include the report in the email, select Include report as email attachment.
To send a notification that has more comprehensive features than those available with Send email to:
1. Expand the Advanced Notifications section.
2. Click Add a Notification.
3. Provide relevant information in the Edit Advanced Notifications window.
4. Click Add.
Click Submit.
- For reports that are run immediately:
- For reports that are scheduled to run at a later time:

View previously submitted report results

You can view the results or status of previously submitted reports from either the My Reports or the View Reports menu.

From the My Reports menu

To view the results of previously submitted reports using the My Reports menu:

From the main menu bar, select Reports > My Reports to open the My Reports page.

To view the report results, do either of the following:
- In the Report # column, click the link for the report in the Report # column.
- Click Modify Search to filter reports you want to see.

From the View Reports menu

To view the results of previously submitted reports using the View Reports menu:

From the main menu bar, select Reports > View Reports.

In the Search for Reports section, provide the search criteria in the appropriate fields, and then click Search.

Filter	Description
Report Type	Filters reports of the selected report types.
Report #	Filters the report with the report number.
Created By	Filters reports submitted by the selected users.
Repeating	Filters reports that are submitted in the selected frequency.
Status	Filters reports in the selected status.
All Reports	Filters all submitted reports
Scheduled Reports	All Scheduled Reports: Filters all scheduled reports. Scheduled to run within the next: Filters reports that are scheduled to run within the specified future periods. Scheduled to run From To: Filters reports that are scheduled to run during the specified time range.
Previous Reports	All Previous Reports: Filters all reports that were run. Run within the last: Filters reports that were run within the specified last periods. The starting time of this filter is 00:00 xxx periods ago. For example, if the filter is "Run within the last 1 day", it filters reports that were run starting from 00:00 the previous day to the current. Run From To: Filters reports that were run during the specified time range.

To view the report results, do one of the following:
- In the Report # column, click the link for the report in the Report # column.
- Click Modify Search to filter reports you want to see.

View and cancel running reports

You can view and cancel a running report.

Prerequisite

To access the View Running Reports page, you must have the Administrator License and the Sys Admin: Server Tools: Execute Admin Tools access grant.

To view or cancel a running report:

Click the Administration button from the masthead.

From the Administration menu, select Report Execution > View Running Reports to open the View Running Reports page.

The Report Details section lists and provides summary information about reports currently running and reports scheduled to run.

The following table lists the fields displayed on the View Running Reports page.

Field Name	Description
Summary section
Currently Running	Provides the number of reports currently running.
Waiting to Run	Number of submitted reports waiting to run. These are not the reports that are scheduled to run. Rather, they are not running because of current load on the system and will run as soon as the current report runs are completed.
Report Details section
Report #	Report ID.
Report Type	Report name.
Launched By	Full name of the user who submitted the report.
Launched Time	Time at which the report was submitted.
Running	Indicates whether the report is running (Yes) or waiting (No).
Server	Name of the PPM Server running the report.
Session ID	Oracle database session ID for the session that the report uses to query data.
Process ID	Oracle database process ID for the process that the report uses.
Cancel	Cancels a report that is currently running or waiting to be run. You can cancel only the reports listed in Reports that can be cancelled.

To cancel a report, click Cancel in the row for the report.

After you cancel the report submission, the page refreshes and no longer lists the report.

When a report submitter is disabled, you can configure PPM to skip and delete the reports scheduled by that user by setting the SKIP_SCHEDULED_REPORT_WHEN_SUBMITTER_DISABLED and DELETE_SCHEDULED_REPORT_WHEN_SUBMITTER_DISABLED_FOR_DAYS parameters to true. For details, see Server parameters.

Note: Reports that do not use the ksc_run_jsp_report special command are subject to some limitations and cannot be cancelled from the View Running Reports page. The following section, Reports that can be cancelled, lists the reports you can cancel from the View Running Reports page.

Reports that can be cancelled

You can cancel the following reports from the View Running Reports page:

ALM - Change Summary Report
ALM - Forward Schedule of Releases
ALM - Forward Schedule of Changes for RFC
ALM - Release Content Report
ALM - Release Summary Report
Contact Detail Report
Import Users
Notification History Report
Project Cost Breakdown
Project Cost Details
Request Detail (Filter by Custom Fields) Report
Request Detail Report
Request History Report
Request Quick View
Request Summary (Filter by Custom Fields Report)
Request Type Detail Report
Time Sheet Details
Time Sheet Summary
User Detail Report

Delete report results

You can delete report results that are outdated and no longer useful.

To delete report results:

From the main menu, select Reports > My Reports to open the My Reports page.

You can find the results of the reports that you submitted in the Search Results: Reports section.
You can delete one or more report results.
- To delete all the report results:
  1. Click Check All.
    
    If you change your mind about your choices, you can either clear single check boxes, or click Clear All to clear all of the check boxes.
  2. Click Delete.
- To delete one or more report results:
  1. Select the check box of the report results to delete.
    
    If you change your mind about your choices, you can either clear single check boxes, or click Clear All to clear all of the check boxes.
  2. Click Delete.

Run and view reports in a multilingual user interface

If you run a report on a PPM instance that supports multiple languages, the report is displayed in the language you selected at logon (your session language). Because a report is generated only once, the language used to display the contents does not change, and any user who later views the report sees it in its original language. For information about multilingual support in PPM, see Multilingual User Interface.