R11i: PJI_PJP_SUMMARIZE_INCR Performance Issue With PRC: Update Project Performance Data
Last updated on MARCH 08, 2017
Applies to:Oracle Project Planning and Control - Version 18.104.22.168 to 22.214.171.124 [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.
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