R12: PA: Performance issues with PRC: Update Project Performance Data process

(Doc ID 1292449.1)

Last updated on DECEMBER 11, 2016

Applies to:

Oracle Project Planning and Control - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 28-Dec-2013***

Symptoms

Performance issues with the PRC: Update Project Performance Data process. 

The performance may be inconsistent, e.g., there are times when the process might in 10-15 minutes, but others it may take 2-3 hours to complete even for single project.

Problem statements per the trace files:

INSERT /*+ parallel(PJI_FP_AGGR_PJP1) */ INTO PJI_FP_AGGR_PJP1 PARTITION(P1)
( 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,
....
= SUP_FIN_VER.STATUS_CODE (+) AND PJP1_I.SUP_EMT_ID =
SUP_WPA.PROJ_ELEMENT_ID (+) AND 'N' = SUP_WPA.WP_ENABLE_VERSION_FLAG (+) AND
(PJP1_I.SUP_ID IS NULL OR (PJP1_I.SUP_ID IS NOT NULL AND
(SUP_FIN_VER.PROJECT_ID IS NOT NULL OR SUP_WPA.PROJ_ELEMENT_ID IS NOT
NULL)))

and

MERGE INTO PJI_FP_XBS_ACCUM_F FACT USING ( SELECT /*+ leading(tmp)
rowid(tmp)
*/ TMP.WORKER_ID , TMP.PROJECT_ID , TMP.PROJECT_ORG_ID ,
.....
PJP1.CUSTOM9 , PJP1.CUSTOM10 , PJP1.CUSTOM11 , PJP1.CUSTOM12 ,
PJP1.CUSTOM13 , PJP1.CUSTOM14 , PJP1.CUSTOM15 , PJP1.PLAN_TYPE_CODE )

 

Changes

 On 11i the issue was noticed to occur after applying the following patches:

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