My Oracle Support Banner

R12: After Upgrade to 12.2.7, the HTML Project Search Screen Freezes after Clicking on the Project Number/Name Link (Doc ID 2580259.1)

Last updated on AUGUST 22, 2019

Applies to:

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

Symptoms

After upgrade to 12.2.7, the Project Search page in the self service application freezes when the project number is selected. The statement with the performance issue, appears to be:

select
WBS_Element_Name,
project_element_id,
nvl(budget_cost,0) budget_cost,
nvl(total_cost,0) total_cost,
nvl(forecast_cost,0) forecast_cost,
nvl(billable_cost,0) * contract_flag billable_cost,
nvl(non_billable_cost,0) *contract_flag non_billable_cost,
nvl(budget_labor_hours,0) budget_labor_hours,
nvl(total_labor_hours,0) total_labor_hours,
nvl(forecast_labor_hours,0) forecast_labor_hours,
nvl(billable_labor_hours,0)*contract_flag billable_labor_hours,
nvl(non_billable_labor_hours,0)*contract_flag non_billable_labor_hours,
nvl(budget_revenue,0)*contract_flag budget_revenue,
nvl(revenue,0)*contract_flag revenue,
nvl(forecast_revenue,0)*contract_flag forecast_revenue,
nvl(budget_margin,0)*contract_flag budget_margin,
nvl(margin,0)*contract_flag margin,
nvl(forecast_margin,0) forecast_margin,
round(DECODE(
revenue, 0, NULL,
((NVL(revenue,0)-NVL(total_cost,0))/revenue)*100
),2) margin_percent,
round (DECODE(
budget_revenue, 0, NULL,
((NVL(budget_revenue,0)-NVL(budget_cost,0))/budget_revenue)*100
),2) budget_margin_percent,
round (DECODE(
forecast_revenue, 0, NULL,
((NVL(forecast_revenue,0) -NVL(forecast_cost,0))/forecast_revenue)*100
),2) forecast_margin_percent,
scheduled_variance scheduled_variance,
cost_variance cost_variance,
project_id project_id,
owner_wbs_version_id owner_wbs_version_id,
child_element_id child_element_id,
rollup_flag rollup_flag,
budget_cost_ac budget_cost_ac

....


,DECODE(fct.prg_rollup_flag, 'Y', -3,-99)
,DECODE(fct.prg_rollup_flag, 'Y', -4,-99)
  )*/
AND fct.PA_PLAN_VERSIONS_DM = plnver.plan_version_id
AND fct.PA_plan_typeS_DM IN(params.actual_type_id
,plnver.cst_bud_type_id
,plnver.cst_fcst_type_id
,plnver.rev_bud_type_id
,plnver.rev_fcst_type_id )
AND wbs_denorm.relationship_type IN ('WF', 'LF')
) ) innersql
WHERE 1=1
GROUP BY
innersql.name,innersql.project_element_id,child_element_id,rollup_flag,display
_sequence
ORDER BY rollup_flag, display_sequence)

Changes

 

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
Changes
Cause
Solution
References


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