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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms