R11i: PJI_PJP_SUMMARIZE_INCR Performance Issue With PRC: Update Project Performance Data
(Doc ID 761743.1)
Last updated on FEBRUARY 25, 2019
Applies to:Oracle Project Planning and Control - Version 22.214.171.124 to 126.96.36.199 [Release 11.5.10]
Information in this document applies to any platform.
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,
The issue can be reproduced at will with the following steps:
Responsibility: Projects Implementation SU
Submit New Request: PRC: Update Project Performance Data
The issue has the following business impact:
Unable to update the projects and carry out any reporting on a timely manner.
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