R12: OKEDTSFM, Performance Issue
(Doc ID 2589734.1)
Last updated on OCTOBER 31, 2019
Applies to:Oracle Project Contracts - Version 12.2.7 and later
Information in this document applies to any platform.
OKEDTSFM, Performance Issue when clicking Project Number LOV.
pa_projects_all p where p.project_id in ( select to_number(sub_project_id)
project_id from pa_fin_structures_links_v start with parent_project_id=:1
and parent_task_id=nvl(:2,parent_task_id) connect by prior
parent_project_id=prior sub_project_id union select to_number(:3) from dual)
order by segment1
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