R12 - Slow performance running the PACODTBC PRC: Distribute Total Burdened Cost Process (Doc ID 1681427.1)

Last updated on SEPTEMBER 30, 2014

Applies to:

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

Symptoms

Running the PACODTBC PRC: Distribute Total Burdened Cost process encounters slow performance.  The most expsnsive query is:

 update PA_Cost_Distribution_Lines CDL  set (System_Reference1, 

 System_Reference2,System_Reference3,Budget_ccid,Encumbrance_Amount,
 Liquidate_Encum_Flag,Encumbrance_Type_Id,budget_line_id,budget_version_id)=
 (select CDL2.System_Reference1 ,CDL2.System_Reference2 ,
 CDL2.System_Reference3 ,
 DECODE(pa_funds_control_utils.get_bdgt_link(NVL(CDL.project_id,(-99)),'STD')
 ,'Y',DECODE(EI.system_linkage_function,'VI',CDL2.budget_ccid,'ST',
 DECODE(EI.po_line_id,null ,null ,CDL2.budget_ccid),null ),null ) ,
 DECODE(pa_funds_control_utils.get_bdgt_link(NVL(CDL.project_id,(-99)),'STD')
 ,'Y',DECODE(EI.system_linkage_function,'VI',DECODE(CDL.line_type,'D',
 CDL.Amount,(CDL.Amount* (-1))),DECODE(EI.po_line_id,null ,null ,
 DECODE(CDL.line_type,'D',CDL.Amount,(CDL.Amount* (-1))))),null ) ,
 DECODE(pa_funds_control_utils.get_bdgt_link(NVL(CDL.project_id,(-99)),'STD')
 ,'Y',DECODE(EI.system_linkage_function,'VI',
 DECODE(PA_UTILS2.Get_Burden_Amt_Display_Method(NVL(CDL.project_id,(-99))),
 'S','Y','N'),'BTC','N',DECODE(EI.po_line_id,null ,'N',
 DECODE(PA_UTILS2.Get_Burden_Amt_Display_Method(NVL(CDL.project_id,(-99))),
 'S','Y','N'))),'N') ,DECODE(pa_funds_control_utils.get_bdgt_link(NVL(CDL.pr
 oject_id,(-99)),'STD'),'Y',DECODE(EI.system_linkage_function,'VI',
 DECODE(CDL2.Encumbrance_Type_Id,null ,
 pa_funds_control_utils.get_encum_type_id(NVL(CDL.Project_Id,(-99)),'STD'),
 CDL2.Encumbrance_Type_Id),DECODE(EI.po_line_id,null ,null ,
 DECODE(CDL2.Encumbrance_Type_Id,null ,
 pa_funds_control_utils.get_encum_type_id(NVL(CDL.Project_Id,(-99)),'STD'),
 CDL2.Encumbrance_Type_Id))),null ) ,DECODE(CDL.Line_Type,'D',
 CDL2.budget_line_id,CDL.budget_line_id) ,DECODE(CDL.Line_Type,'D',
 CDL2.budget_version_id,CDL.budget_version_id)  from
 PA_Cost_Distribution_Lines CDL2 ,PA_Expenditure_Items_All EI
where
((((CDL.Expenditure_Item_ID=CDL2.Expenditure_Item_ID and
 EI.Expenditure_Item_ID=CDL2.Expenditure_Item_ID) and CDL2.Line_Type='R')
 and CDL2.Reversed_Flag is null ) and CDL2.Line_Num_Reversed is null ))
 where (CDL.Line_Type in ('D','C') and CDL.Expenditure_Item_ID in (select
 Expenditure_Item_ID  from PA_Expenditure_Items ITEM where
 ITEM.Cost_Burden_Distributed_Flag='S'))

 

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