PRC: Process Project Structure Updates Performance Issue - For A Program (Doc ID 1389347.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Sep-2015 ***

Symptoms

PRC: Process Project Structure Updates is taking 9 minutes for a Program that has only 16 Projects linked to it. That is also a huge performance concern.

Following SQL is performing poor.
SELECT A.PROJECT_ID, A.ELEMENT_VERSION_ID, A.PRG_LEVEL
FROM
PA_PROJ_ELEMENT_VERSIONS A, PA_PROJ_ELEM_VER_STRUCTURE B,
PA_PROJ_WORKPLAN_ATTR PPWA,
..
AND A.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID =1 ORDER BY 3 DESC

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