Perform API Poor Performance When Adding Percent Complete To Workplan (Doc ID 1939347.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Performance issue when updating progress via Oracle API
PA_STATUS_PUB.Update_Progress is taking over an hour

INSERT INTO PJI_FM_XBS_ACCUM_TMP1 ( PROJECT_ID, STRUCT_VERSION_ID, PROJECT_ELEMENT_ID, CALENDAR_TYPE, PERIOD_NAME, PLAN_VERSION_ID, QUANTITY, TXN_RAW_COST, TXN_BRDN_COST, TXN_REVENUE, TXN_LABOR_RAW_COST, TXN_LABOR_BRDN_COST, TXN_EQUIP_RAW_COST, TXN_EQUIP_BRDN_COST, TXN_BASE_RAW_COST, TXN_BASE_BRDN_COST, TXN_BASE_LABOR_RAW_COST, TXN_BASE_LABOR_BRDN_COST, TXN_BASE_EQUIP_RAW_COST, TXN_BASE_EQUIP_BRDN_COST, TXN_LPB_RAW_COST, TXN_LPB_BRDN_COST, TXN_LPB_LABOR_RAW_COST, TXN_LPB_LABOR_BRDN_COST, TXN_LPB_EQUIP_RAW_COST, TXN_LPB_EQUIP_BRDN_COST, PRJ_RAW_COST, PRJ_BRDN_COST, PRJ_REVENUE, PRJ_LABOR_RAW_COST, PRJ_LABOR_BRDN_COST, PRJ_EQUIP_RAW_COST, PRJ_EQUIP_BRDN_COST, PRJ_BASE_RAW_COST, PRJ_BASE_BRDN_COST, PRJ_BASE_LABOR_RAW_COST, PRJ_BASE_LABOR_BRDN_COST, PRJ_BASE_EQUIP_RAW_COST, PRJ_BASE_EQUIP_BRDN_COST, PRJ_LPB_RAW_COST, PRJ_LPB_BRDN_COST, PRJ_LPB_LABOR_RAW_COST, PRJ_LPB_LABOR_BRDN_COST, PRJ_LPB_EQUIP_RAW_COST, PRJ_LPB_EQUIP_BRDN_COST, POU_RAW_COST, P OU_BRDN_COST, POU_REVENUE, POU_LABOR_RAW_COST, POU_LABOR_BRDN_COST, POU_EQUIP_RAW_COST, POU_EQUIP_BRDN_COST, POU_BASE_RAW_COST, POU_BASE_BRDN_COST, POU_BASE_LABOR_RAW_COST, POU_BASE_LABOR_BRDN_COST, POU_BASE_EQUIP_RAW_COST, POU_BASE_EQUIP_BRDN_COST, POU_LPB_RAW_COST, POU_LPB_BRDN_COST, POU_LPB_LABOR_RAW_COST, POU_LPB_LABOR_BRDN_COST, POU_LPB_EQUIP_RAW_COST, POU_LPB_EQUIP_BRDN_COST, LABOR_HOURS, EQUIPMENT_HOURS, BASE_LABOR_HOURS, BASE_EQUIP_HOURS, LPB_LABO
.....
(HEAD.WK_PLAN_VER_ID , HEAD.BASE_PLAN_VER_ID, HEAD.LPB_PLAN_VER_ID ) AND FACT.PROJECT_ELEMENT_ID = NVL(HEAD.PROJ_ELEM_ID, FACT.PROJECT_ELEMENT_ID ) AND FACT.CALENDAR_TYPE = CAL_TYPE AND FACT.PERIOD_TYPE_ID = PERIOD_ID AND BITAND(FACT.CURR_RECORD_TYPE_ID, 28) = 4 AND FACT.RBS_AGGR_LEVEL = 'T' AND FACT.PRG_ROLLUP_FLAG IN (:B1 , 'N') AND FACT.RBS_VERSION_ID = -1 GROUP BY FACT.PROJECT_ID, FACT.PROJECT_ELEMENT_ID, FACT.CALENDAR_TYPE, HEAD.WK_PLAN_VER_ID, HEAD.STRUCT_VER_ID



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