PAXACRPT: PRC: Refresh Project Summary Amounts has Slow Performance After Upgrade to 12.1. (Doc ID 1400643.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Management - Version 12.1.3 and later
Information in this document applies to any platform.
Report:PAXACRPT.RDF - PRC: Refresh Project Summary Amounts


Symptoms

When running the PRC: Refresh Project Summary Amounts and the PRC: Update Project Summary Amounts processes, the following statement gives a performance issue:

UPDATE PA_TXN_ACCUM PTA SET PTA.TOT_CMT_RAW_COST = NULL,
PTA.TOT_CMT_BURDENED_COST = NULL, PTA.CMT_ROLLUP_FLAG = 'N',
PTA.LAST_UPDATED_BY = :B6 , PTA.LAST_UPDATE_DATE = SYSDATE, PTA.REQUEST_ID =
:B5 , PTA.PROGRAM_APPLICATION_ID = :B4 , PTA.PROGRAM_ID = :B3 ,
PTA.PROGRAM_UPDATE_DATE = SYSDATE
WHERE
PTA.PROJECT_ID = :B2 AND NVL(PTA.SYSTEM_LINKAGE_FUNCTION,'X') = NVL(NVL(:B1 ,
PTA.SYSTEM_LINKAGE_FUNCTION),'X') AND EXISTS ( SELECT 'Yes' FROM
PA_TXN_ACCUM_DETAILS PTAD WHERE PTA.TXN_ACCUM_ID = PTAD.TXN_ACCUM_ID AND
PTAD.LINE_TYPE = 'M' ) AND EXISTS ( SELECT 'Yes' FROM PA_PERIODS WHERE
PERIOD_NAME = PTA.PA_PERIOD AND START_DATE >= :B8 AND END_DATE <= :B7 )

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