Performance Issue when Baselining a Budget. Budget Remains 'In Progress'. (Doc ID 2650603.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Symptoms

After making changes to a budget and hitting the baseline button, the page just keeps showing Baseline in progress. The problem statement appears to be:

INSERT INTO PJI_FP_XBS_ACCUM_F FACT ( 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 , LAST_UPDATE_DATE , LAST_UPDATED_BY ,
 CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , 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 , ETC_LABOR_BRDN_COST , ETC_EQUIP_BRDN_COST ,
 ETC_BRDN_COST , ETC_RAW_COST , ETC_LABOR_RAW_COST , ETC_EQUIP_RAW_COST ,
 CUSTOM1 , CUSTOM2 , CUSTOM3 , CUSTOM4 , CUSTOM5 , CUSTOM6 , CUSTOM7 ,
 CUSTOM8 , CUSTOM9 , CUSTOM10 , CUSTOM11 , CUSTOM12 , CUSTOM13 , CUSTOM14 ,
 CUSTOM15 , PLAN_TYPE_CODE ) SELECT /*+ ordered full(rwid) rowid(tmp) */
 TMP.PROJECT_ID , TMP.PROJECT_ORG_ID , TMP.PROJECT_ORGANIZATION_ID ,
 TMP.PROJECT_ELEMENT_ID , TMP.TIME_ID , TMP.PERIOD_TYPE_ID ,
 TMP.CALENDAR_TYPE , TMP.RBS_AGGR_LEVEL , TMP.WBS_ROLLUP_FLAG ,
 TMP.PRG_ROLLUP_FLAG , TMP.CURR_RECORD_TYPE_ID , TMP.CURRENCY_CODE ,
 TMP.RBS_ELEMENT_ID , TMP.RBS_VERSION_ID , VER3.PLAN_VERSION_ID ,
 TMP.PLAN_TYPE_ID , :B6 , :B5 , :B4 , :B3 , :B2 , 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 ,
 DECODE ( VER3.WP_FLAG , 'Y' , DECODE(TO_CHAR(TMP.ETC_LABOR_HRS) , NULL ,
 NVL(TMP.LABOR_HRS, 0) , NVL(TMP.ETC_LABOR_HRS, 0) ) , NVL(TMP.ETC_LABOR_HRS,
  0) ) ETC_LABOR_HRS , DECODE ( VER3.WP_FLAG , 'Y' ,
 DECODE(TO_CHAR(TMP.ETC_EQUIP_HRS) , NULL , NVL(TMP.EQUIPMENT_HOURS, 0) ,
 NVL(TMP.ETC_EQUIP_HRS, 0) ) , NVL(TMP.ETC_EQUIP_HRS, 0) ) ETC_EQUIP_HRS ,
 DECODE ( VER3.WP_FLAG , 'Y' , DECODE(TO_CHAR(TMP.ETC_LABOR_BRDN_COST) ,
 NULL , NVL(TMP.LABOR_BRDN_COST, 0) , NVL(TMP.ETC_LABOR_BRDN_COST, 0) ) ,
 NVL(TMP.ETC_LABOR_BRDN_COST, 0) ) ETC_LABOR_BRDN_COST , DECODE (
 VER3.WP_FLAG , 'Y' , DECODE(TO_CHAR(TMP.ETC_EQUIP_BRDN_COST) , NULL ,
 NVL(TMP.EQUIPMENT_BRDN_COST, 0) , NVL(TMP.ETC_EQUIP_BRDN_COST, 0) ) ,
 NVL(TMP.ETC_EQUIP_BRDN_COST, 0) ) ETC_EQUIP_BRDN_COST , DECODE (
 VER3.WP_FLAG , 'Y' , DECODE(TO_CHAR(TMP.ETC_BRDN_COST) , NULL ,
 NVL(TMP.BRDN_COST, 0) , NVL(TMP.ETC_BRDN_COST, 0) ) , NVL(TMP.ETC_BRDN_COST,
  0) ) ETC_BRDN_COST , DECODE ( VER3.WP_FLAG , 'Y' ,
 DECODE(TO_CHAR(TMP.ETC_RAW_COST) , NULL , NVL(TMP.RAW_COST, 0) ,
 NVL(TMP.ETC_RAW_COST, 0) ) , NVL(TMP.ETC_RAW_COST, 0) ) ETC_RAW_COST ,
 DECODE ( VER3.WP_FLAG , 'Y' , DECODE(TO_CHAR(TMP.ETC_LABOR_RAW_COST) , NULL
 , NVL(TMP.LABOR_RAW_COST, 0) , NVL(TMP.ETC_LABOR_RAW_COST, 0) ) ,
 NVL(TMP.ETC_LABOR_RAW_COST, 0) ) ETC_LABOR_RAW_COST , DECODE ( VER3.WP_FLAG
 , 'Y' , DECODE(TO_CHAR(TMP.ETC_EQUIP_RAW_COST) , NULL ,
 NVL(TMP.EQUIPMENT_RAW_COST, 0) , NVL(TMP.ETC_EQUIP_RAW_COST, 0) ) ,
 NVL(TMP.ETC_EQUIP_RAW_COST, 0) ) ETC_EQUIP_RAW_COST , CUSTOM1 , CUSTOM2 ,
 CUSTOM3 , CUSTOM4 , CUSTOM5 , CUSTOM6 , CUSTOM7 , CUSTOM8 , CUSTOM9 ,
 CUSTOM10 , CUSTOM11 , CUSTOM12 , CUSTOM13 , CUSTOM14 , CUSTOM15 ,
 TMP.PLAN_TYPE_CODE FROM PJI_FP_RMAP_FPR_T RWID , PJI_FP_AGGR_PJP1_T TMP ,
 PJI_PJP_WBS_HEADER VER3 WHERE 1 = 1 AND TMP.WORKER_ID = :B1 AND
 RWID.WORKER_ID = :B1 AND TMP.ROWID = RWID.PJP1_ROWID AND RWID.FPR_ROWID IS
 NULL AND VER3.PLAN_VERSION_ID = TMP.PLAN_VERSION_ID AND VER3.PLAN_TYPE_CODE
 = TMP.PLAN_TYPE_CODE AND TMP.PROJECT_ID = VER3.PROJECT_ID AND
 TMP.PLAN_TYPE_ID = NVL(VER3.PLAN_TYPE_ID, -1)

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.