My Oracle Support Banner

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 FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.