Rel 12 PARGDR - Running Much Longer After in Release 12.2.7 (Doc ID 2530886.1)

Last updated on SEPTEMBER 30, 2022

Applies to:

Symptoms

After upgrading to R12.2.7 from R12.2.6,

PRC : Generate Draft Revenues (Single and Range) are running much longer for certain projects.

from less than 3 minutes to more then 200 minutes

SQL performing poor is:
SQL ID: 4ks0m2up3k73w Plan Hash: 1216417349

SELECT SUM(BURDENED_COST)
FROM
(SELECT SUM(CDL.BURDENED_COST) BURDENED_COST FROM
PA_COST_DISTRIBUTION_LINES_ALL CDL WHERE EXISTS (SELECT 1 FROM PA_TASKS T
WHERE CDL.PROJECT_ID = T.PROJECT_ID AND CDL.TASK_ID = T.TASK_ID AND
T.PROJECT_ID = :B1 AND T.TOP_TASK_ID = :B2 AND EXISTS (SELECT 1 FROM
PA_TASKS T1 WHERE T1.TASK_ID = T.TOP_TASK_ID AND DECODE(:B3 ,'Revenue',
T1.READY_TO_DISTRIBUTE_FLAG, 'Invoice',T1.READY_TO_BILL_FLAG,0) = 'Y' ) )
AND CDL.LINE_TYPE IN ( 'R' , 'I') AND CDL.PROJECT_ID = :B1 AND EXISTS
(SELECT 1 FROM PA_PERIODS PP WHERE NVL(:B4 ,SYSDATE) >= TRUNC(PP.START_DATE)
 AND CDL.PA_DATE BETWEEN PP.START_DATE AND PP.END_DATE ) )

Changes

Cause

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