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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

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)!= 238200349
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

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       40      0.03       0.03          0          0          0           0
Execute     40      0.00       0.00          0          0          0           0
Fetch       40   1296.48   18985.46    5139913  180518936          0       19418
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      120   1296.52   18985.50    5139913  180518936          0       19418

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