R12 Performance Issues with PAGCAE PRC: Generate Cost Accounting Events (Doc ID 1556378.1)

Last updated on DECEMBER 19, 2016

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked for relevance 01-Jan-2015 ***

Symptoms

The PAGCAE PRC: Generate Cost Accounting Events process encounters slow performance and does not complete.  The most expensive query is:


SELECT Expenditure_Item_Id,system_linkage_function
FROM  
  (SELECT /*+ use_nl(cdl, item) */ CDL.Expenditure_Item_Id,
  ITEM.SYSTEM_LINKAGE_FUNCTION , ROW_NUMBER() over (partition by
  ITEM.expenditure_item_id order by CDL.LINE_NUM) AS ORDER_LINE_NUM
  FROM PA_Expenditure_Items ITEM
  ,PA_Cost_Distribution_Lines CDL
  WHERE ITEM.Expenditure_Item_Id = CDL.Expenditure_Item_Id
  AND CDL.Transfer_Status_Code IN ('P', 'R')
  AND ITEM.System_Linkage_Function IN ('ST', 'OT')
  AND CDL.Line_Type = 'R'
  AND ITEM.Cost_Distributed_Flag = 'Y'
  ORDER BY ITEM.SYSTEM_LINKAGE_FUNCTION )
  WHERE ORDER_LINE_NUM = 1

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