R12 PACOCRSR - Compile Burden Schedule Revision Process has Performance Issue (Doc ID 1484955.1)

Last updated on AUGUST 25, 2016

Applies to:

Oracle Project Costing - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
*** Checked for relevance

Symptoms

Process PACOCRSR - 'Compile Burden Schedule Revision' has performance issue.  The most expensive query is:

UPDATE PA_EXPENDITURE_ITEMS_ALL EI SET REVENUE_DISTRIBUTED_FLAG = 'N',
  LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = :B9 , LAST_UPDATE_LOGIN = :B8
   , REQUEST_ID = :B7 , PROGRAM_APPLICATION_ID = :B6 , PROGRAM_ID = :B5 ,
   PROGRAM_UPDATE_DATE = SYSDATE
  WHERE
  REV_IND_COMPILED_SET_ID = :B4 AND EXPENDITURE_ITEM_DATE BETWEEN :B3 AND
   NVL(:B2 , EXPENDITURE_ITEM_DATE) AND NVL(EI.NET_ZERO_ADJUSTMENT_FLAG, 'N')
   <>'Y' AND PA_PROJECT_STUS_UTILS.IS_PROJECT_CLOSED(EI.PROJECT_ID) <> 'Y' AND
   (:B1 = 'N' OR
  GMS_PA_API2.IS_AWARD_CLOSED(EI.EXPENDITURE_ITEM_ID,EI.TASK_ID)
    = 'N' )

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