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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms