PRC: Process Project Structure Updates Performance Issue - For A Program
(Doc ID 1389347.1)
Last updated on FEBRUARY 21, 2019
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 05-Nov-2018 ***
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
PA_PROJ_ELEMENT_VERSIONS A, PA_PROJ_ELEM_VER_STRUCTURE B,
AND A.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
AND PPST.STRUCTURE_TYPE_ID =1 ORDER BY 3 DESC
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document