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 18.104.22.168 to 22.214.171.124 [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,
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