PAXPREPR Performance Issue When Adding Tasks on Project After Applying ADK/TX Delta 14
(Doc ID 2992729.1)
Last updated on DECEMBER 13, 2023
Applies to:
Oracle Project Costing - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
After applying ADK/TX Delta 14, updating task start and end dates is taking between 30-45 seconds. Previously, this took about 3 seconds, at most.
This is the problem query:
SELECT MAX (PE.EXPENDITURE_ITEM_DATE) EI_DATE
FROM
PA_EXPENDITURE_ITEMS_ALL PE WHERE PE.PROJECT_ID = :b1 AND EXISTS
(SELECT '1' FROM PA_TASKS P WHERE PE.TASK_ID = P.TASK_ID AND
P.PROJECT_ID = :b1 CONNECT BY PRIOR P.TASK_ID = P.PARENT_TASK_ID
START WITH P.TASK_ID = :b2 )
FROM
PA_EXPENDITURE_ITEMS_ALL PE WHERE PE.PROJECT_ID = :b1 AND EXISTS
(SELECT '1' FROM PA_TASKS P WHERE PE.TASK_ID = P.TASK_ID AND
P.PROJECT_ID = :b1 CONNECT BY PRIOR P.TASK_ID = P.PARENT_TASK_ID
START WITH P.TASK_ID = :b2 )
The issue can be reproduced at will with the following steps:
Using Projects forms responsibility:
1. Open a project
2. Click on Tasks
3. Select a task
4. Change the task Trans Finish Date and hit Tab or Save
5. On projects with a large number of tasks or transaction, the cursor spins for 30-45 seconds
Changes
Applied ADK/TX Delta 14
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 |