R12: PA: Performance Issue while Assign Asset in Oracle Project (Doc ID 2030891.1)

Last updated on AUGUST 25, 2016

Applies to:

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

Symptoms

Poor performance behaviour of assigning assets in Project Costing as it takes about 3 minutes in the manual additions through “Capital Project” screen and also it hanged many times in the API.

AWR report shows following SQL taking time:

SQL ID : 7vmxtpt35rqrx

select task_number, task_name, task_id from pa_tasks where project_id =
199570 and task_id = top_task_id and task_id not in (select task_id from
pa_project_asset_assignments where project_id = 199570 and project_asset_id = 0 )
and task_id not in (select top_task_id from pa_tasks a where a.task_id in
(select task_id from pa_project_asset_assignments where project_id = 199570
and task_id <> 0) and task_id <> top_task_id ) and task_id not in ( -9999 )
order by task_number

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms