My Oracle Support Banner

R11i: PJI_PJP_SUMMARIZE_INCR Performance Issue With PRC: Update Project Performance Data (Doc ID 761743.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

PJI_PJP_SUMMARIZE_INCR PRC: Update Project Performance Data
is taking too long to complete.
It takes approximate 4 hours to finish this process.
The following is the expensive query:

INSERT INTO PJI_FP_AGGR_PJP1 PJP1_I ( WORKER_ID, RECORD_TYPE, PRG_LEVEL,
LINE_TYPE, PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID,
PROJECT_ELEMENT_ID, TIME_ID, PERIOD_TYPE_ID, CALENDAR_TYPE, RBS_AGGR_LEVEL, WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG, CURR_RECORD_TYPE_ID, CURRENCY_CODE, RBS_ELEMENT_ID, RBS_VERSION_ID, PLAN_VERSION_ID, PLAN_TYPE_ID, PLAN_TYPE_CODE, RAW_COST, BRDN_COST, REVENUE, BILL_RAW_COST, BILL_BRDN_COST, BILL_LABOR_RAW_COST, BILL_LABOR_BRDN_COST, BILL_LABOR_HRS, EQUIPMENT_RAW_COST, EQUIPMENT_BRDN_COST, CAPITALIZABLE_RAW_COST,
.....

STEPS
The issue can be reproduced at will with the following steps:
Responsibility: Projects Implementation SU
Submit New Request: PRC: Update Project Performance Data

BUSINESS IMPACT
The issue has the following business impact:
Unable to update the projects and carry out any reporting on a timely manner.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.