PRC: Process Project Structure Updates Performance Issue - For A Program
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 ***
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms