2Update Project Performance Data and Generate KPIs

This chapter contains the following:

Project managers, project application administrators, and project administrators can run the Update Project Performance Data process to summarize performance data for a project unit, business unit, a range of projects, or the projects managed by a project manager. This process:

  • Summarizes data for different data sources, such as actual costs, commitments, contract revenue, invoice amounts, budgets, control budgets, allocations, forecasts, and awards.

    • Summarizes data in the project currency, project ledger currency, and transaction currency.

    • Summarizes data in the accounting and project accounting calendars.

    • Summarizes contracts.

  • Generates KPI values and determines the overall project health status.

  • Updates the financial project plan with summarized amounts from actual cost transactions.

  • Updates Oracle Essbase cubes so that you can view the summarized data using Oracle Smart View for Office.

Summarized Data

Use the summarized data to analyze the health of projects and drill down to the causes of any deviation from set thresholds.

You can use summarized data to:

  • Analyze project performance.

  • Analyze KPI categories and KPIs.

  • Track project health and progress across different periods.

  • View summaries for revenues, invoices, actual costs, budgets, allocations, forecasts, and commitments.

    Note: On the Review Project Performance page, the transfer order commitments are reported as part of Other Commitments. That is, the ITD Transfer Order Committed Cost is reported as part of ITD Other Committed Cost, the PTD Transfer Order Committed Cost is reported as part of PTD Other Committed Cost, and so on.
  • Build dashboards and analyses to review project performance using the Projects - Performance Reporting Real Time subject area.

  • Create reports using Oracle Smart View for Office.

When to Run the Update Project Performance Data Process

You can run the Update Project Performance Data process for different situations. For example, run it when:

  • The summarized data is out of date and you want to update it. For example, if you don't see the latest summarized data in the Project Management infolets, in the Project Performance Dashboard regions, or in the My Projects page.

  • Large volume of data isn't summarized yet, and you want to summarize the entire data in one run.

    Note: If you have large volumes of data, run the Update Project Performance Data Without Producing Report process when the workload is low. For example, you can run the process on a nightly basis.

The following processes run as part of the Update Project Performance Data process and summarize data. So, don't run these processes if you're running the Update Project Performance Data process:

Process Notes

Distribute Project Resource and Task Effort by Day

None.

Update Project Contract Performance Data or Update Project Contract Performance Data Without Producing Report

The Update Project Performance Data process or the Update Project Contract Performance Data process summarizes project and contract performance data. Submit or schedule either of these processes without specifying any parameters that determine the range of projects or contracts for the process. You must leave any such parameters (for example, project unit, business unit, and so on) blank so that the application can summarize the eligible projects and contracts.

Generate KPI Values or Generate KPI Values Without Producing Report

The Update Project Performance Data process doesn't spawn a subprocess for generating KPIs. KPIs are generated as part of the Update Project Performance Data process.

Update Award Project Performance Data Without Producing Report

None.

Update Project Plan Data or Update Project Plan Data Without Producing Report

If the Enable automatic pushing actual to project plan after every online cost summarization profile option is enabled, the Update Project Plan Data process runs as part of the Update Project Performance Data process. Otherwise, navigate to the Manage Financial Project Plan page, click Update Amounts > Update Actual Amounts from the Actions menu, and submit the Update Project Plan Data process.

Settings That Affect Performance Data Summarization

Tip: We recommended that you run the Update Project Performance Data process with the default parameter values.

Before you run the Update Project Performance Data process from the Scheduled Processes page, select one of the following summarization methods:

Summarization Method Usage

Incremental

Summarizes new transactions that are yet to be summarized. Also, processes all the planning resource breakdown structure and reporting resource breakdown structure changes that are associated to summarized projects.

Delete and resummarize

Corrects summary data when the source system data changes outside the regular transaction flow.

This option is disabled by default. But, if you want to delete and resummarize performance data, ask your application administrator to set the Enable Maintain Project Performance Data job profile option to Yes. The profile option is in the Setup and Maintenance work area.

Resource breakdown structure

Migrates all summary data from one resource breakdown structure version to the next. If you select this option, you must also specify the resource breakdown structure header.

If you update a project-specific resource breakdown structure that allows resource changes at project level, then run the Update Project Performance Data process in the Resource breakdown structure mode for the changes to reflect in reporting. If you want the changes to apply to new projects that use this resource breakdown structure, then use the Manage Planning and Billing Resource Breakdown Structures task in the Setup and Maintenance work area to make the changes at the setup level.

If you update a resource breakdown structure that doesn't allow resource changes at project level and you want these changes to reflect in the projects that are currently associated with this resource breakdown structure, then click Update Mapping or run the Update Project Performance Data process in the Resource breakdown structure or Incremental mode.

Each time you run the summarization process manually, specify the summarization parameters and whether to summarize the following transactions:

Transaction Data Summarized

Budget and Forecast

Approved current and previous forecasts, and current and original budgets that have a baseline version. This includes approved budgets and primary forecasts.

Commitment

Commitments such as supplier invoices, purchase orders, and requisitions from other Oracle Cloud applications.

Actual Costs

The actual costs incurred for your projects.

How to Run the Update Project Performance Data Process

Project application administrators can schedule the Update Project Performance Data process to run periodically by clicking Schedule New Process on the Scheduled Processes page.

Project managers can submit these processes from the Project Performance Dashboard or the Project Management work area. Project administrators can submit these processes from the Project Performance Dashboard or the Project Financial Management work area.

After you run the Update Project Performance Data process, you can track its progress on the Scheduled Processes page.

Troubleshooting

After an environment refresh or a production-to-test refresh, the Update Project Performance Data or Update Project Contract Performance Data process ends in a warning if its sub process Maintain Project Performance Data: Maintain Oracle Essbase Cube ends in an error. To fix this error, run the Maintain Project Performance Data Without Producing Report process in the target environment with the Recreate Cube with Existing Summary Data parameter set to Yes and the rest of the parameters set to their default values.

A key performance indicator (KPI) lets you define thresholds of possible values for a performance measure for any project in a project unit. During KPI definition, you associate a performance status indicator with each threshold level. When you generate KPI values, the value is compared with the thresholds defined for the KPI. If the value falls within any of the defined threshold levels, then the status indicator of that threshold is associated with the performance measure.

The key components of a KPI are:

  • Performance Measure

  • Performance Status Indicator

  • Threshold Level

  • Performance Trend Indicator

  • Tolerance Percentage

Performance Measure

Performance measures are predefined criteria for performance or schedule that are used to determine if a project is on track. You can create your own performance measures based on existing custom performance measures to effectively determine the overall health of your projects. Use any of the available performance measure to create a KPI.

Performance measures are defined for budgets and forecasts, billing and revenue, costs, effort, margin, capitalization, and so on. Following are examples of predefined performance measures:

  • EAC Budget Cost (the estimate at completion burdened cost from the current baseline approved budget)

  • ITD Forecast Revenue Variance (the inception-to-date current baseline budget revenue - inception-to-date current approved forecast revenue)

  • Prior Period Margin Percentage Variance (the prior period current baseline budget margin percentage - prior period actual margin percentage)

You can rename these performance measures to make the measure names more relevant for your business needs. For example, rename EAC Budget Cost to Budget at Completion.

A performance measure is associated with one of the following time dimensions:

  • Estimate-at-completion (EAC)

  • Inception-to-date (ITD)

  • Prior Period

  • Period-to-date (PTD)

  • Quarter-to-date (QTD)

  • Year-to-date (YTD)

A performance measure set, such as Budget Cost, can have as many as six performance measures; one for each time dimension.

A performance measure can be expressed as a currency amount, as a percentage, or in time units such as hours when effort is measured. If a KPI is used on projects that use different currencies, you can enter different thresholds levels for each currency you need.

Performance Status Indicator

Performance status indicators indicate the status of a project, such as critical, at risk, and on track. Each icon indicates the status and severity of performance.

During KPI definition, you first associate status indicators with performance statuses:

  • Critical

  • Severe

  • At risk

  • On track

  • Ahead

You then associate these statuses with threshold levels. When KPI values are generated for a project, each value is compared to the defined thresholds and the corresponding status indicator for the KPI appears in the project performance reports.

A status can identify negative performance so that you can take the appropriate actions to prevent or quickly resolve problems. Conversely, a status can identify positive performance to help you track expected or excellent performance.

Threshold Level

During KPI definition, you define threshold levels to cover all possible values for a KPI. If a KPI value exceeds the threshold levels you defined, the closest threshold is used to determine the KPI status. For example, if a KPI value falls lower than the lowest threshold level, the status of the lowest threshold level is assigned to the KPI.

A status indicator can be associated with more than one threshold level. For example, both underutilization and overutilization of resources can indicate a critical performance status.

Performance Trend Indicator

Performance trend indicators show the improving or worsening KPI value trends on the project. Each icon indicates whether an increasing performance trend has a positive or negative impact. For example, an increase in nonbillable costs is considered unfavorable to organizations that are able to bill costs to their clients. In this example, the performance trend indicator shows a negative impact.

Tolerance Percentage

A tolerance percentage is used to compare the previous KPI value with the current value to show if the performance trend is increasing, decreasing, or staying the same. For example, if the tolerance percentage is 10 percent for a KPI and the difference between the previous KPI value and the current value is greater than 10 percent, then the trend is increasing. If the difference is greater than -10 percent, then the trend is decreasing. If the difference is between -10 percent and 10 percent, then the trend shows no change. A single tolerance percentage value, such as 10 percent in this example, represents both negative and positive tolerances.

Schedule or submit the Update Project Performance Data process to generate KPI values and analyze project performance. However, if you want to generate KPI values for a particular period, then submit the Generate KPI Values process with an appropriate KPI period determination date. You can assign a threshold level for the KPI values. The KPI values are generated and then a status indicator is assigned to the KPI based on the threshold you define.

Settings That Affect KPI Values

Before you submit the Generate KPI Values process from the Scheduled Processes page, you can set the following parameters:

Parameters Description

KPI Period Determination Date

Date used to derive the project accounting calendar and accounting calendar periods for performance measure calculations when KPI values are generated.

Replace Current KPI Values

Replaces the existing KPI values with the values that you're generating now.

Delete Previous KPI Values

Deletes the KPI values that were generated by prior runs of the Generate KPI Values process.

Number of Days to Retain KPI Values

Retains the KPI values for the specified number of days starting from the current date. The KPI values generated prior to the specified number of days are deleted.

This parameter is applicable only when the Delete Previous KPI Values parameter is set to Yes.

Suppose that you set the KPI Period Determination Date parameter value and generate the KPI values as mentioned in the following table:

KPI Period Determination Date Generation Date

October 29, 2010

November 12, 2010

September 30, 2010

October 15, 2010

If you select the Replace Current KPI Values parameter and generate KPI values on November 18, 2010, then the KPI values generated on November 12, 2010 are replaced with the KPI values generated on November 18, 2010. You must select to replace the current KPI values for a given period if you want to retain one set of KPI values during the period.

You can also delete KPI values that aren't required for reporting. The Delete Previous KPI Values and Number of Days to Retain KPI Values parameters let you to delete KPI values that were generated prior to a specific number of days. For example, if today is November 18, 2010 and you want to remove all KPI values generated in the previous year, then select the Delete Previous KPI Values parameter and set the Number of Days to Retain KPI Values parameter to 322. All KPI values generated since January 1, 2010 are retained and KPI values generated before that period are deleted.

Note: Don't delete previous KPI values if you're generating KPI values for the first time in a period or if you want to see trending information for the KPIs over the life of the project.

How KPI Values are Generated

KPI values are calculated based on the value of the performance measure associated with the project. The Update Project Performance Data process generates KPI values using the current date as the KPI period determination date. If you submit the Generate KPI Values process to generate KPI values, the KPI period determination date is used to determine the period. KPI values are generated for the period based on the options in the KPI definition.

Only one set of KPIs are maintained for a KPI period determination date. If KPIs are generated for the same date more than once, then the existing KPI values are overwritten by the latest KPI values.

Suppose that the KPI values are generated with the KPI period determination date of August 24 at 8:15 a.m. for projects A and B. For project B, KPI values are also generated with a KPI period determination date of August 24 at 10:45 a.m.. The KPI values for project B that are generated at 8:15 a.m. are deleted, but the KPI values of project A are retained.

Note: To keep historical information, use a unique KPI period determination date.

Generate KPI Notifications

To automatically notify project managers after you generate KPI values:

  1. Go to Projects > Project Financial Management.

  2. In the My Projects page, right-click the project and select Manage Financial Project Settings.

  3. In the Manage Financial Project Settings page, click Reporting.

  4. Select the Notify project manager check box in the KPI Notifications section.

Trend indicators show whether the trend of a key performance indicator (KPI) is favorable or unfavorable for a project. When you define KPIs you specify a value for tolerance percentage. The tolerance percentage is taken into account while calculating trend indicators for a KPI.

Note: KPI trends may not be useful if KPI values are generated often. The reason is, if the tolerance percentage is 10 percent and KPI values are generated every day, the values decrease by 1 percent each day. In this scenario, no change is observed in the trend as the decrease is well within the tolerance. However, if you generate KPI values at the start and end of the month, a significant change is observed in the trend.

Settings That Affect KPI Trends

The trend indicator that appears for a KPI is based on the default set in the performance trend indicator setup. The different trend indicators available are:

  • Up, favorable: The project performance trend is increasing in value and is desirable.

  • Up, unfavorable: The project performance trend is increasing in value and is undesirable.

  • Down, favorable: The project performance trend is decreasing in value and is desirable.

  • Down, unfavorable: The project performance trend is decreasing in value and is undesirable.

  • Unchanged: The project performance trend is unchanged.

You can change the sort order of the trend indicators based on how you want to sequence KPIs in a table based on the performance of KPIs in a project.

How KPI Trends Are Calculated

Trend Indicators are calculated based on the percentage increase or decrease in a KPI value, while taking into consideration the tolerance percentage specified while creating the KPI. The following example illustrates how trend indicators are calculated for a KPI.

Consider a scenario where KPI values are generated for the first time on January 15, 2011, and again on February 15 and April 15. KPI trends are calculated when there are at least two values that exist for a KPI.

KPI Values Generated on January 15, 2011

This table displays the trend when KPI values are generated the first time on January 15, 2011. All values in the following tables are percentages unless specified otherwise.

KPI Tolerance Percentage and Trend Indicator Setting Current KPI Value and Status Indicator Previous KPI Value and Status Indicator Trend Indicator

PTD Actual Spent Labor Effort Percentage

5

Up is Favorable

70

On Track

NA

NA

PTD Actual Spent Equipment Effort Percentage

5

Up is Unfavorable

30

On Track

NA

NA

PTD Actual Invoice Amount

5

Up is Favorable

$5000

Warning

NA

NA

Actual Billable Cost Percentage

2

Up is Favorable

90

On Track

NA

NA

PTD Actual Margin Percentage

2

Up is Favorable

30

On Track

NA

NA

After generating KPI values on January 15, 2011, the most critical KPI is PTD Actual Invoice Amount. The overall project health status is Warning, because the most critical KPI, PTD Actual Invoice Amount, has a status of Warning.

KPI Values Generated on February 15, 2011

This table displays the trend when KPI values are generated on February 15, 2011.

KPI Tolerance Percentage and Trend Indicator Setting Current Period KPI Value and Status Indicator Previous Period KPI Value and Status Indicator Trend Indicator based on Previous Period

PTD Actual Spent Labor Effort Percentage

5

Up is Favorable

71

On Track

70

On Track

Unchanged

PTD Actual Spent Equipment Effort Percentage

5

Up is Unfavorable

29

On Track

30

On Track

Unchanged

PTD Actual Invoice Amount

5

Up is Favorable

$4800

Warning

$5000

Warning

Unchanged

Actual Billable Cost Percentage

2

Up is Favorable

91

On Track

90

On Track

Unchanged

PTD Actual Margin Percentage

2

Up is Favorable

30.2

On Track

30

On Track

Unchanged

This table shows how the trend indicator is calculated based on the previous period. Although the KPI values for the current period are different from the previous period, the difference in the values isn't significant enough to change the trend indicator, based on the tolerance percentage defined for each KPI. For example, the PTD Actual Spent Labor Effort Percentage is 71 percent, compared to the previous period KPI value of 70 percent. If the current period KPI value is more than 73.5 percent, which is more than 5 percent higher than the previous period, then the trend indicator is Up, Favorable. If the current period KPI value is less than 66.5 percent, which is more than 5 percent lower than the previous period, then the trend indicator is Down, Unfavorable.

The overall project health status is Warning, based on the most critical of all KPI statuses. After generating KPI values on February 15, 2011, the most critical KPI is PTD Actual Invoice Amount.

KPI Values Generated on April 15, 2011

This table displays the trend when KPI values are generated the on April 15, 2011.

KPI Tolerance Percentage and Trend Indicator Setting Current Quarter KPI Value and Status Indicator Previous Quarter KPI Value and Status Indicator Trend Indicator Based on Previous Quarter

PTD Actual Spent Labor Effort Percentage

5

Up is Favorable

75

On Track

71

On Track

Up, Favorable

PTD Actual Spent Equipment Effort Percentage

5

Up is Unfavorable

25

On Track

29

On Track

Down, Favorable

PTD Actual Invoice Amount

5

Up is Favorable

$3500

Critical

$4800

Warning

Down, Unfavorable

Actual Billable Cost Percentage

2

Up is Favorable

91

On Track

91

On Track

Unchanged

PTD Actual Margin Percentage

2

Up is Favorable

28.5

Warning

30.2

On Track

Down, Unfavorable

This table shows how the trend indicator is calculated based on the previous quarter. The current KPI values are compared to the latest generation date of KPIs for the previous quarter.

It is possible that the previous period trend and the previous quarter trend are calculated based on KPI values from the same generation date. This occurs when the previous period generation date is the same as the latest generation date in the previous quarter.

The first three KPI values changed enough since the previous quarter to change the trend calculator. For example, the current quarter value of PTD Actual Invoice Amount is $3,500, which exceeds the threshold tolerance of 5 percent from the previous quarter KPI value of $4,800. Therefore the KPI is in a Critical status, and the trend indicator is Down, Unfavorable. If the current quarter value is greater than $5,040, which is more than 5 percent higher than the previous quarter, then the trend indicator is Up, Favorable.

A project manager might review the KPI values, statuses, and trends shown in this table and determine that a transaction was not billed, because the KPIs that are based on revenue and invoice amounts have both dropped.

The overall project health is critical because of the status of the PTD Actual Invoice Amount.

A key performance indicator (KPI), if enabled for use, can be defined against one of two calendars: accounting calendar or project accounting calendar.

To generate KPI values, you enter a KPI period determination date for the application to determine the accounting calendar period and project accounting calendar period. This example shows you how current period, prior period, and prior quarter KPI values are calculated.

Scenario

Vision Corporation designs and implements heavy engineering projects for government and private customers. The Finance department is interested in measuring revenue and margin on the accounting calendar, and budget to actual variance of labor effort on the project accounting calendar. The KPIs defined for this purpose are Period-to-Date (PTD) Revenue Variance Percentage on the accounting calendar and PTD Labor Effort Variance Percentage on the project accounting calendar.

The following table shows the accounting calendar used by InFusion Corporation.

Period Name Period Start Date Period End Date Quarter Name Quarter Start Date Quarter End Date

Jun-09

1-Jun-09

30-Jun-09

Q2

1-Apr-09

30-Jun-09

Jul-09

1-Jul-09

31-Jul-09

Q3

1-Jul-09

30-Sep-09

Aug-09

1-Aug-09

31-Aug-09

Q3

1-Jul-09

30-Sep-09

Sep-09

1-Sep-09

30-Sep-09

Q3

1-Jul-09

30-Sep-09

Oct-09

1-Oct-09

31-Oct-09

Q4

1-Oct-09

31-Dec-09

Nov-09

1-Nov-09

30-Nov-09

Q4

1-Oct-09

31-Dec-09

The following table shows the project accounting calendar used by InFusion Corporation.

Period Name Period Start Date Period End Date Quarter Name Quarter Start Date Quarter End Date

W1-Apr-09

4-Apr-09

10-Apr-09

Q2

4-April-09

3-Jul-09

W1-Sep-09

2-Sep-09

9-Sep-09

Q3

4-Jul-09

3-Oct-09

W2-Sep-09

10-Sep-09

17-Sep-09

Q3

4-Jul-09

3-Oct-09

W3-Sep-09

18-Sep-09

25-Sep-09

Q3

4-Jul-09

3-Oct-09

W4-Sep-09

26-Sep-09

3-Oct-09

Q3

4-Jul-09

3-Oct-09

W1-Oct-09

4-Oct-09

10-Oct-09

Q4

4-Oct-09

3-Jan-10

W2-Oct-09

11-Oct-09

18-Oct-09

Q4

4-Oct-09

3-Jan-10

W3-Oct-09

19-Oct-09

26-Oct-09

Q4

4-Oct-09

3-Jan-10

W4-Oct-09

27-Oct-09

3-Nov-09

Q4

4-Oct-09

3-Jan-10

Assume the KPI period determination date is October 2, 2009. In the calendar shown, October 2, 2009, occurs in the period OCT-09 on the accounting calendar, but in the W4-SEP-09 period on the project accounting calendar.

The following scenario describes how the current period, prior period, and prior quarter KPI values are calculated based on different KPI period determination dates.

KPI Values Generated on October 3, 2009

The first generation of KPI values occurs on October 3, 2009. On the KPI watchlist, the key performance indicator PTD Labor Effort Variance Percentage shows the current period as W4-Sep-09, prior period as W3-Sep-09, and prior quarter as Q2. The key performance indicator PTD Revenue Variance Percentage shows the current period as Oct-09, prior period as Sep-09, and prior quarter as Q2.

This table displays how the current period, prior period, and prior quarter KPI values are calculated for the date October 3, 2009 on the accounting and project accounting calendars.

KPI Period Determination Date Generation Date Period Name for Generation Date KPI Name Is KPI Value Current? Current Period Prior Period Prior Quarter

3-Oct-09

October 3

W4-Sep-09

PTD Labor Effort Variance Percentage

Yes

W4-Sep-09

W3-Sep-09

Q2

3-Oct-09

October 3

Oct-09

PTD Revenue Variance Percentage

Yes

Oct-09

Sep-09

Q2

KPI Values Generated on October 4, 2009

KPI values are generated again on October 4, with a KPI period determination date of September 25, 2009. Even though the KPI period determination date is prior to the previous generation date, the KPI values generated on October 4 for September 25, 2009 are marked as current.

This table displays how the current period, prior period, and prior quarter KPI values are calculated for the date October 4, 2009 on the accounting and project accounting calendars.

KPI Period Determination Date Generation Date Period Name for Generation Date KPI Name Is KPI Value Current? Current Period Prior Period Prior Quarter

3-Oct-09

October 3

W4-Sep-09

PTD Labor Effort Variance Percentage

No

W4-Sep-09

W3-Sep-09

Q2

3-Oct-09

October 3

Oct-09

PTD Revenue Variance Percentage

No

Oct-09

Sep-09

Q2

25-Sep-09

October 4

W3-Sep-09

PTD Labor Effort Variance Percentage

Yes

W3-Sep-09

W2-Sep-09

Q2

25-Sep-09

October 4

Sep-09

PTD Revenue Variance Percentage

Yes

Sep-09

Aug-09

Q2

KPI Values Generated on October 10, 2009

KPI values are again generated on October 10, 2009 with a KPI period determination date of October 10, 2009. These KPI values are now used for the current period, prior period, and prior quarter.

This table displays how the current period, prior period, and prior quarter KPI values are calculated for the period October 10, 2009 on the accounting and project accounting calendars.

KPI Period Determination Date Generation Date Period Name for Generation Date KPI Name Is KPI Value Current? Current Period Prior Period Prior Quarter

3-Oct-09

October 3

W4-Sep-09

PTD Labor Effort Variance Percentage

No

W4-Sep-09

W3-Sep-09

Q2

3-Oct-09

October 3

Oct-09

PTD Revenue Variance Percentage

No

Oct-09

Sep-09

Q2

25-Sep-09

October 4

W3-Sep-09

PTD Labor Effort Variance Percentage

No

W3-Sep-09

W2-Sep-09

Q2

25-Sep-09

October 4

Sep-09

PTD Revenue Variance Percentage

No

Sep-09

Aug-09

Q2

10-Oct-09

October 10

W1-Oct-09

PTD Labor Effort Variance Percentage

Yes

W1-Oct-09

W4-Sep-09

Q3

10-Oct-09

October 10

Oct-09

PTD Revenue Variance Percentage

Yes

Oct-09

Sep-09

Q3

Import Project Key Performance Indicators

Import KPIs for project templates and projects that are enabled for financial management into Oracle Project Portfolio Management Cloud by using the Import Project Key Performance Indicators file-based data import feature.

You can also use the Excel template to update KPI assignments to project templates and projects that are enabled for financial management. For example, if you no longer want to see the values of certain KPIs for a project, then you can disable those KPIs for that project.

The Excel template is part of the External Data Integration Services for Oracle Cloud feature. To download the Project Key Performance Indicators Interface Excel workbook template, see the File-Based Data Import for Oracle Project Portfolio Management guide.

To attach or disable KPIs for project templates or projects:

  1. Prepare your data in the Project Key Performance Indicators Interface macro-enabled Excel workbook template.

  2. Click Generate CSV File in the template to create a comma-separated values file.

  3. Navigate to the Scheduled Processes page.

  4. Click Schedule New Process, select Load Interface File for Import from the Name drop-down list, select Import Project Key Performance Indicators from the Import Process drop-down list, upload the data file, and click Submit.

Output Report

After the Import Project Key Performance Indicators process is complete, the Import Project Key Performance Indicators: Generate Report process runs automatically and creates the Import Project Key Performance Indicators Report. This output report details:

  • The number of KPIs and projects that were processed, attached successfully, and not attached. Also, lists the KPIs and projects that weren't attached.

  • The errors due to which the records weren't processed. Correct these errors in the same output report and re-upload it.

Review the output report and repeat the following steps until all rows are imported successfully and the KPIs are attached to the project templates or projects:

  1. Correct the errors in the Import Project Key Performance Indicators Report output report.

  2. Generate CSV files.

  3. Submit the Load Interface File for Import process.

FAQs for Update Project Performance Data and Generate KPIs

If you're a project manager, you can view your projects on the Project Performance Dashboard.

If you aren't a project manager, you can access the Project Performance Dashboard and view projects using a custom role that includes the functional security privilege Manage Project Performance (PJS_MANAGE_PROJECT_PERFORMANCE_PRIV). For example, if you're an administrator at the project, organization, or business unit level, you can access the Project Performance Dashboard to view the projects that you administer, or those that belong to the organizations or business units that you administer, or the ones to which you have access. You can also navigate to the Project Overview page in context of the Project Financial Management work area.

Additionally, if the following data security privileges are granted to custom roles, you can navigate to the Review Project Performance and Analyze KPI Categories pages from the Project Performance Dashboard:

  • PJS_REVIEW_PROJECT_PERFORMANCE_DATA to access the Review Project Performance page

  • PJS_REVIEW_PROJECT_PERFORMANCE_HEALTH_DATA to access the Analyze KPI Categories page

The result of a business measure, for example product sales or operational costs, evaluated against a target for that measure. You use KPIs to assess the performance of the strategic objectives and initiatives that are part of your organizational strategy. When you define KPIs you should ensure they have these characteristics:

  • Have measurable objectives that may vary over time.

  • Can be evaluated using targets to determine performance status.

  • Can be compared over time for trending purposes.

The following actions can trigger performance data summarization:

  • Running the Update Project Performance Data process from the Project Performance Dashboard or the Project Financial Management work area.

  • Running or scheduling the Update Project Performance Data process from the process scheduler.

  • Creating revenue and invoice transactions.

  • Creating actual cost transactions.

  • Setting a baseline for an approved cost budget.

How can I update project performance data and generate KPI values?

Project managers and project administrators can submit the Update Project Performance Data process from the Project Performance Dashboard, My Projects page, or the Scheduled Processes page. Project application administrators can submit the Update Project Performance Data process from the Scheduled Processes page.

To update performance data for all projects in a project owning organization or business unit, project administrators must submit the Update Project Performance Data process from the Scheduled Processes page.

Project managers must ensure that they run the Update Project Performance Data process so that all the infolets on the Project Management dashboard are up-to-date.

You don't need to submit the Generate KPI Values process separately as KPIs are generated as part of the Update Project Performance Data process. However, if you want to generate KPI values for a particular period, then submit the Generate KPI Values process with an appropriate KPI period determination date.