In Capital Projects Form, Opening Up Task Amounts Window Takes Too Long (Doc ID 734653.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Capitalization --> Capital Projects --> Enter Project information into
Find Projects window --> Capital Projects Window comes up with the project information.

To get the Task information Click on Task Amounts button.
It takes long time to open this window.

The following SQL shows-up as which takes long time:

INSERT INTO PA_CP_TASK_AMOUNTS_GTEMP ( PROJECT_ID,TASK_ID,TASK_NUMBER,
TASK_NAME,PARENT_TASK_ID,WBS_LEVEL,CAPITALIZED_COST,RETIRED_COST,
CAPITALIZABLE_COST,RETIRABLE_COST,TOTAL_CAP_COST,TOTAL_RET_COST ) SELECT
/*+ USE_NL(PAL, PAD, E) INDEX( PAL PA_PROJECT_ASSET_LINES_N2)
*/PAL.PROJECT_ID,E.TASK_ID,'X' TASK_NUMBER,'X' TASK_NAME,0 PARENT_TASK_ID,0
WBS_LEVEL,ROUND(DECODE(PAL.LINE_TYPE,'C',(PAD.CIP_COST *
(PAL.CURRENT_ASSET_COST / DECODE(PAL.ORIGINAL_ASSET_COST,0,1,
PAL.ORIGINAL_ASSET_COST) ) ),0),:b1) CAPITALIZED_COST,
ROUND(DECODE(PAL.LINE_TYPE,'R',(PAD.CIP_COST * (PAL.CURRENT_ASSET_COST /
DECODE(PAL.ORIGINAL_ASSET_COST,0,1,PAL.ORIGINAL_ASSET_COST) ) ),0),:b1)
RETIRED_COST,0 CAPITALIZABLE_COST,0 RETIRABLE_COST,0 TOTAL_CAP_COST,0
TOTAL_RET_COST FROM PA_PROJECT_ASSET_LINE_DETAILS PAD,
PA_PROJECT_ASSET_LINES_ALL PAL,PA_EXPENDITURE_ITEMS_ALL E WHERE
PAD.PROJECT_ASSET_LINE_DETAIL_ID = PAL.PROJECT_ASSET_LINE_DETAIL_ID AND PAL.TRANSFER_STATUS_CODE IN ( 'T','A' ) AND E.EXPENDITURE_ITEM_ID =
PAD.EXPENDITURE_ITEM_ID AND PAL.PROJECT_ID = :b3 UNION ALL SELECT
PROJECT_ID,TASK_ID,TASK_NUMBER,TASK_NAME,PARENT_TASK_ID,WBS_LEVEL, CAPITALIZED_COST,RETIRED_COST,CAPITALIZABLE_COST,RETIRABLE_COST,
TOTAL_CAP_COST,TOTAL_RET_COST FROM PA_CAPITAL_PROJECTS_WBS_V WHERE  PROJECT_ID = :b3

Cause

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