R12 PACOCRSR - Compile Burden Schedule Revision Process has Performance Issue
(Doc ID 1484955.1)
Last updated on DECEMBER 18, 2017
Applies to:Oracle Project Costing - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
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
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
= 'N' )
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!