My Oracle Support Banner

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

Last updated on SEPTEMBER 04, 2020

Applies to:

Oracle Project Planning and Control - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

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

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
Symptoms
Cause
Solution
References

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