R12 Performance Issue With PRC: Delete Project Performance Reporting Data (Doc ID 1551623.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Performance issue with the following statement when running the PRC: Delete Project Performance Data process:


INSERT /*+ parallel(PJI_FP_AGGR_PJP1) */ INTO PJI_FP_AGGR_PJP1 ( WORKER_ID ,
 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 , 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 ,
 CAPITALIZABLE_BRDN_COST , LABOR_RAW_COST , LABOR_BRDN_COST , LABOR_HRS ,
 LABOR_REVENUE , EQUIPMENT_HOURS , BILLABLE_EQUIPMENT_HOURS ,
 SUP_INV_COMMITTED_COST , PO_COMMITTED_COST , PR_COMMITTED_COST ,
 OTH_COMMITTED_COST , ACT_LABOR_HRS , ACT_EQUIP_HRS , ACT_LABOR_BRDN_COST ,
 ACT_EQUIP_BRDN_COST , ACT_BRDN_COST , ACT_RAW_COST , ACT_REVENUE ,
 ACT_LABOR_RAW_COST , ACT_EQUIP_RAW_COST , ETC_LABOR_HRS , ETC_EQUIP_HRS ,

...

ORGINFO.PA_CALENDAR_ID , 'G', ORGINFO.GL_CALENDAR_ID , - :B3 ) =
 PJI_TIME.CALENDAR_ID AND PLR.PERIOD_NAME = PJI_TIME.NAME GROUP BY
 PLR.PROJECT_ID , PLR.PROJECT_ORG_ID , PLR.PROJECT_ORGANIZATION_ID ,
 PLR.WBS_ELEMENT_ID , DECODE(PLR.TIME_PHASED_TYPE_CODE , 'N', -1 ,
 PJI_TIME.CAL_PERIOD_ID) , DECODE(PLR.TIME_PHASED_TYPE_CODE , 'P', 32 , 'G',
 32 , 'N', 2048 , -1) , DECODE(PLR.TIME_PHASED_TYPE_CODE , 'P', 'P' , 'G',
 'G' , 'N', 'A' , 'X') , PLR.CURR_RECORD_TYPE , PLR.CURRENCY_CODE ,
 PLR.RBS_ELEMENT_ID , PLR.RBS_STRUCT_VERSION_ID , PLR.BUDGET_VERSION_ID ,
 PLR.PLAN_TYPE_ID , DECODE(PLR.TIME_PHASED_TYPE_CODE, 'P', 'OF', 'G', 'OF',
 'N', 'NTR', 'X') , PLR.PLAN_TYPE_CODE

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