R12 Inconsistent Performance Issue when Navigating to the View Budget (Task Summary) Page in the Self Service Application. (Doc ID 2099888.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

Inconsistent performance issue when navigating to the View Budget (Task Summary) page in the self service application.

1. Search a project. Any project demonstrates this issue. Click Go button
2. Open the project you searched, by clicking on the Project Name or Project Number.
3. Go to Financial tab, Budget and Forecasts
4. Select the Approved Cost Budget, then click the Maintain Versions pencil.
5. Click on any version name. It does not matter which version name you click on.
6. This screen comes up, but it does not display the results. Nor does the IE View Budget show that it is loading. Sometimes this comes up in seconds,
and sometimes it times out in 5 minutes.

The problem query appears to be:

SELECT * FROM (SELECT name,
  parent_element_id,
  child_element_id,
  display_child_flag,
  project_element_id,
  SUM(plan1_cost_mask * brdn_cost) plan1_burdened_cost,
  SUM(plan1_rev_mask * revenue) plan1_revenue,
  SUM(plan1_cost_mask * raw_cost) plan1_raw_cost,
 SUM(plan1_report_hr_mask * labor_hrs) plan1_people_effort,
 SUM(plan1_report_hr_mask * equipment_hours) plan1_equipment_effort,
 Pji_Rep_Util.measures_total(SUM(plan1_report_hr_mask *
 labor_hrs),SUM(plan1_report_hr_mask * equipment_hours)) plan1_effort,
  TO_NUMBER(NULL) plan1_margin,
  TO_NUMBER(NULL) plan1_effort_var,
 TO_NUMBER(NULL) plan1_people_effort_var,
 TO_NUMBER(NULL) plan1_equip_effort_var,
 TO_NUMBER(NULL) plan1_effor_var_perc,
 TO_NUMBER(NULL) plan1_people_eff_var_perc,
 TO_NUMBER(NULL) plan1_equip_eff_var_perc,
 TO_NUMBER(NULL) plan1_raw_cost_var,
 TO_NUMBER(NULL) plan1_raw_cost_var_perc,
 TO_NUMBER(NULL) plan1_burden_cost_var,
 TO_NUMBER(NULL) plan1_burden_cost_var_perc,
 TO_NUMBER(NULL) plan1_rev_var,
 TO_NUMBER(NULL) plan1_rev_var_perc,
 TO_NUMBER(NULL) plan1_margin_var,
 TO_NUMBER(NULL) plan1_margin_var_perc,
 TO_NUMBER(NULL) plan1_margin_perc,
  SUM(plan2_cost_mask * raw_cost) plan2_raw_cost,
  SUM(plan2_cost_mask * brdn_cost) plan2_burdened_cost,
Pji_Rep_Util.measures_total(SUM(plan2_report_hr_mask *
labor_hrs),SUM(plan2_report_hr_mask * equipment_hours)) plan2_effort,
SUM(plan2_rev_mask * revenue) plan2_revenue,
SUM(plan2_report_hr_mask * labor_hrs) plan2_people_effort,
SUM(plan2_report_hr_mask * equipment_hours) plan2_equipment_effort,
...
'TASK' project_or_task_flag FROM PJI_REP_XBS_DENORM denom,
PA_PROJ_ELEMENT_VERSIONS ver,
PA_PROJ_ELEMENTS ele,
(SELECT
:20 project_id,
:21 parent_element_id,
:22 wbs_version_id
FROM dual) params
WHERE denom.sup_project_id = params.project_id
AND denom.parent_element_id = params.parent_element_id
AND denom.wbs_version_id = params.wbs_version_id
AND denom.relationship_type IN ('WF', 'LF')
AND denom.rollup_flag = 'Y'
AND ele.proj_element_id = denom.child_element_id
AND ver.parent_structure_version_id = params.wbs_version_id
AND ver.proj_element_id = denom.child_element_id
)
 GROUP BY child_element_id,
  parent_element_id,
  project_element_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