My Oracle Support Banner

R12: Workplan - Task - Change Date - Gives Slow Performance (Doc ID 1917042.1)

Last updated on JULY 26, 2019

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In Project Management Workplan when customers open the worklan and enter the project date of a certain date, the performance is very slow.

The most expensive query is:

SELECT START_DATE, COMPLETION_DATE
FROM
 PA_TASKS WHERE TASK_ID IN (SELECT PROJ_ELEMENT_ID FROM
  PA_PROJ_ELEMENT_VERSIONS WHERE ELEMENT_VERSION_ID IN (SELECT OBJECT_ID_TO1
  FROM PA_OBJECT_RELATIONSHIPS POR, PA_PROJ_ELEMENT_VERSIONS PPEV WHERE
  PPEV.PROJECT_ID = :B3 AND POR.RELATIONSHIP_TYPE = 'S' AND
  POR.OBJECT_TYPE_TO = 'PA_TASKS' AND PPEV.PARENT_STRUCTURE_VERSION_ID = :B2
  START WITH PPEV.PROJ_ELEMENT_ID = :B1 AND POR.OBJECT_ID_FROM1 =
  PPEV.ELEMENT_VERSION_ID AND POR.OBJECT_TYPE_FROM = 'PA_TASKS' AND
  PPEV.TASK_UNPUB_VER_STATUS_CODE <> 'TO_BE_DELETED' CONNECT BY PRIOR
  POR.OBJECT_ID_TO1 = POR.OBJECT_ID_FROM1 AND PRIOR POR.OBJECT_TYPE_TO =
  POR.OBJECT_TYPE_FROM AND PRIOR POR.RELATIONSHIP_TYPE =
  POR.RELATIONSHIP_TYPE))


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.