Sample P6 EPPM Reports
The following sample reports are available with P6. You can use these reports to display various types of project and portfolio data. Your administrator can modify the list of reports available for your use, including removing the sample reports or adding additional reports to your view.
Note: The P6 EPPM sample reports were designed to be run against the small data set included in the sample database. These reports are provided as an example of the product's capability only. Oracle provides no guarantee, implied or explicit, that the sample reports will run against your database or will produce meaningful data when they are run against your database. You may modify the sample reports to suit your own data set, including adding filter criteria to limit data output or changing filter criteria to suit your data.
Activity
Report Name | Description | Parameters |
|---|---|---|
Displays activities whose predecessors are all complete and which are ready to start for the project. Also displays all the predecessor activities for each of the activities listed. | Project ID | |
Displays activities, along with their dates and status, occurring within specified weeks for the selected projects. | Project ID, Number of Weeks | |
Lists the activities for the selected projects along with their predecessors and successors. Report includes relationship type and lag along with dates and float of the related activities. | Project ID | |
Produces an Excel file showing activities, days, and times in a format similar to a Gantt Chart. | Project ID, Start Date, Number of Days | |
Lists the projects and associated activities that are predecessors or successors to the selected project, providing visibility into cross project impacts. | Project ID | |
Compares planned and actual duration of the activities for the selected projects along with upper and lower thresholds to analyze duration estimates. | Project ID | |
Provides a list of activities for the selected projects along with all associated notebook topics. | Project ID |
Administrative
Report Name | Description | Parameters |
|---|---|---|
Timesheets | Description | Parameters |
Lists the projects with the selected EPS node and shows the EPS Activity Code assignment counts for each project. | EPS ID, EPS Activity Code Specify the EPS Activity Code before selecting the EPS ID. | |
Lists projects and shows the Global Activity Code assignment counts for each project. | Global Activity Code | |
Lists projects and shows the Project specific Activity Code assignment counts for each project. | Project ID, Project Activity Code Specify the Project Activity Code before selecting the Project ID. | |
Lists the date and time from which and to which audit data is presented and the audit date. Also lists the time the change was made, the application from which the change was initiated, the username which changed the table, and information about the changes made for each change recorded by the auditing feature including the primary key, database column, old and new values, and the operation for each table that was changed. | User, Start Date, End Date Specify the tables to be audited. | |
Lists the Project Name and Project ID selected for the report the date and time from which and to which audit data is presented and the audit date. Also lists the time the change was made, the application from which the change was initiated, the username which changed the table, and information about the changes made for each change recorded by the auditing feature including the primary key, database column, old and new values, and the operation for each table that was changed. | Start Date, End Date, Project ID Specify the tables to be audited. | |
Lists all Global, Project, and Resource calendars, including identification of the projects and resources using each calendar. | NA | |
Lists the privileges that are enabled for each global and project-level security profile. | NA | |
Lists core project-level settings for each project, highlighting setting values that are not compliant. | Project ID | |
Lists all project templates along with status, division, and added by person and date. | NA | |
Lists all users that have logged into P6 EPPM within the specified period. | NA | |
Lists users that have not logged into P6 EPPM within the specified period. | NA | |
Lists all users and their personal name along with their associated resource and global security profile. | NA | |
Displays all OBS elements along with the corresponding security profile assigned to selected users. | User Name | |
Displays OBS elements along with the corresponding security profile, EPSs, and Projects assigned to selected users. | User Name | |
Lists timesheets for resources along with the status, submitted and reviewed dates, name of the last reviewer, and associated timesheet notes. | Number of Weeks | |
Lists timesheets for resources along with the status, submitted and reviewed dates, and name of the last reviewer. | NA | |
Lists timesheets for the specified date range. For each timesheet, the activities and detailed hours per day are provided. | Start Date, End Date |
Industry Samples - Utilities - Online
Report Name | Description | Parameters |
|---|---|---|
Provides a list of activities which are completed according to the schedule, but where the Work Order is not complete. For each activity, the report lists the ID and Name (as Title), Actual Start, Actual Finish, and the following User Defined Fields: Dpt, Sys, Status, WO, and WO Type. | Project ID | |
Provides a list of high risk activities for a specified number of days from the data date. For each activity, the report lists the ID and Name (as Title), Start, Finish, Remaining Duration, Critical, the following User Defined Fields: Dpt, Sys, Equip ID, WO Type, and WARM. | Project ID, Number of Days | |
Provides a list of activities that are on hold, listing the Activity ID, Activity Name (as Title), Start, Finish, Remaining Duration, and the following User Defined Fields: Dpt, Sys, Equip ID, Status, WO, and WO Type. | Project ID, T-Week | |
Provides a list of activities for the specified T-week, listing the Activity ID, Activity Name (as Title), Start, Finish, Remaining Duration, and the following User Defined Fields: Dpt, Sys, Equip ID, WO, Status, Pri, WO Type, Crit, WARM, and SAP. See or an example. | Project ID, T-Week | |
Shows the week name, T-Week, Resource name, Scheduled Hours, Available Hours, and Scheduled shown as a percentage of Available. | Project ID, Resource ID |
Industry Samples - Utilities - Outage
Report Name | Description | Parameters |
|---|---|---|
Provides a list of activities in the selected project which are critical for a given number of days. Enter parameters at runtime to define critical (by supplying a maximum Total Float) and a date range (the number of days from the data date). For each critical activity, the report lists the Activity ID, Activity Name (as Title), Start and Finish dates, Original and Remaining Duration, Total Float, and the following User Defined Fields: Dept, System Equip ID, WO, Stat WOT, Pri, Crit, and Risk. | Project ID, Crit Path+, Number of Days | |
Shows a list of activities for the specified number of days from the data date. For each activity, the report shows Activity ID, Activity Name (as Title) Start, Finish, Original Duration, Remaining Duration, Total Float, and the following User Defined Fields: Dept, System Equip ID, WO, Stat WOT, Pri, Crit, and Risk. | Project ID, Number of Days | |
Shows a list of activities which have a schedule varience for the specified number of days from the data date. For each activity, the report provides Activity ID, Activity Name (as Title), Baseline Start, Baseline Finish, Start, Finish, Variance, Total Float, and the following User Defined Fields: Dept, System Equip ID, and Risk. | Project ID, Number of Days |
Portfolio
Report Name | Description | Parameters |
|---|---|---|
Provides a list of projects for the specified portfolio along with the code values assigned for the selected project code. | Project Code, Portfolio Name | |
Displays a bubble chart that plots selected projects against their strategic and financial rating with the bubble size representing the At Completion Cost. | Project ID | |
Provides a count of all projects and activities within the selected portfolio. In addition, two pie charts display the number of open and closed issues and risks. | Portfolio Name | |
Identifies issues and risks within the selected portfolio and groups them by project. Includes status and priority of the issue or risk along with project-level information. | Portfolio Name |
Project
Report Name | Description | Parameters |
|---|---|---|
Displays all of a project's baselines including the date the baselines was added, original and current budget, planned labor units, and activity counts. | Project ID | |
Provides a list of all documents assigned to activities and WBSs within the specified project, grouped by document category. | Project ID | |
Lists all issues identified for the selected projects, grouped by status. The issue details include priority, criticality, and issue description, if provided. | Project ID | |
Displays planned value, actual total cost, earned value, and estimate to complete as periodic and cumulative charts and pivot tables. | Project ID, Start Date, End Date | |
Displays the project plan which lists all WBSs and activities for the selected project. The activity details include the status, start and finish dates, and the associated activity steps. | Project ID | |
Provides a project overview that includes project code values, project costs, issues, risks, status of the milestones, and a list of notebook topics. | Project ID, Project Status | |
Reports on all risks for the select projects. Includes risk information, risk impact assessment, impacted activities, and risk response plans. | Project ID | |
Report of the project risk scoring matrix. Includes threshold definitions grouped by type (Probability, Schedule, Cost, User-defined, and Tolerance) and numeric and alphanumeric probability and impact diagrams (PIDs). | Project ID | |
Displays the originally planned hours, additional work, and work achieved as planned in a bar chart and table. | Project ID, Report Date, Milestone Date | |
Compares the activity actual finish date to the baseline finish date. Activities are grouped by week and project. The report displays information starting four weeks prior to the date set in the report parameters. | Project ID, 4 Weeks Prior To: <date> |
Resource
Report Name | Description | Parameters |
|---|---|---|
Lists resources assigned to each activity in the selected projects. Information includes start and finish dates along with duration. | Project ID | |
Displays actual units, remaining units, over allocated units, and limit for a Resource. | Resource ID, Start Date, End Date | |
Displays a list all resource codes and resource code values along with the resources assigned to each code value. | NA | |
Displays a list of all roles in the system and the resources assigned to each role. The primary role and proficiency level are identified for each resource. | NA | |
Lists all resources along with their assigned roles. The primary role and proficiency level are identified for each role. | NA | |
Displays a stacked bar chart showing planned units by month and by project. | Project ID, Resource ID, Start Date, End Date |
Last Published Thursday, October 12, 2023