Self Service Update Progress Slow Performance Issue With Apply And View Results (Doc ID 412253.1)

Last updated on JUNE 01, 2024

Applies to:

Symptoms

While creating a personalized view for the update progress the performance of the Apply and View Results Button is poor.


Go to the Workplan Page.
Select Mass Update Progress in Actions and Click Go.
Click on the Personalize Button.
Create a New Personalized view and Click on
the Apply and View results button.
The performance at the time of clicking on this Apply and view results button is slow.

The expensive queries are:

SELECT DISTINCT(COMP_ID)
FROM
JDR_COMPONENTS, JDR_PATHS, JDR_ATTRIBUTES WHERE PATH_DOCID=COMP_DOCID AND
COMP_DOCID=ATT_COMP_DOCID AND PATH_NAME= 'TeamMemberUpdateProgressPG' AND
COMP_ID is not null AND ATT_COMP_SEQ=0 AND ATT_NAME='customizes' AND
ATT_VALUE='/oracle/apps/pa/progress/webui/TeamMemberUpdateProgressPG'


BEGIN PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(x_ret_code => :1,
x_return_status => :2, x_msg_count => :3, x_msg_data => :4,
p_privilege => :5, p_object_name => :6, p_object_key => :7);
END;


select prompt, description
from
fnd_menu_entries_tl where menu_id = :1 and entry_sequence = :2 and language =
:3


BEGIN PA_PROJ_STRUCTURE_PUB.POPULATE_STRUCTURES_TMP_TAB( p_project_id
=> :1, p_structure_version_id => :2, p_calling_page_name => :3,
x_return_status => :4, x_msg_count => :5, x_msg_data
=> :6, p_task_version_id => :7, p_populate_tmp_tab_flag
=> :8 ); END;



BEGIN PA_PERF_EXCP_UTILS.get_kpa_color_indicator_list(p_object_type => :1,
p_object_id => :2,p_kpa_codes => :3,x_indicators => :4,
x_return_status => :5,x_msg_count => :6,x_msg_data => :7,
x_ind_meaning => :8); END;

Cause

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