My Oracle Support Banner

R11: PRC: Distribute Total Burdened Cost Process Taking Extremely Long To Complete (Doc ID 1644382.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Project Costing - Version to [Release 11.5.10]
Information in this document applies to any platform.


The PRC: Distribute Burden Process is taking extremely long to complete. This is causing us serious delays in getting the financials in a timely manner for the close.

Steps to Reproduce
1. Load expenditure lines to Oracle Projects.
2. Distribute Labor/Usage and Miscellaneous Costs
3. Run the distribute Burden cost process (This process took 18 hrs to complete)


Longest running query:
SELECT   ITEM.Expenditure_Item_ID , DECODE(PTYPE.Total_Burden_Flag,'Y','S','C')
FROM     PA_Expenditures EXP,                                  
        PA_Expenditure_Items ITEM,                                  
        PA_Projects_all PROJ,                                  
        PA_Project_Types_all PTYPE
WHERE    EXP.Expenditure_Status_Code       = 'APPROVED'
AND      EXP.Expenditure_ID                = ITEM.Expenditure_ID
AND      NVL(ITEM.Request_ID, 238200349 + 1)!=  <id>
AND      ITEM.Cost_Distributed_Flag        = 'Y'
AND      ITEM.Cost_Burden_Distributed_Flag = 'N'
AND      ITEM.Burden_Cost IS NOT NULL
AND      ITEM.Project_ID                   = PROJ.Project_ID
AND      PROJ.Project_Type                 = PTYPE.Project_Type
AND      (PROJ.Org_id = PTYPE.Org_id       OR     PROJ.Org_id is NULL)
AND      PTYPE.Burden_Cost_Flag            = 'Y'
ORDER BY ITEM.Expenditure_Item_Date




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

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