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

Last updated on MARCH 08, 2017

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.

EXPECTED BEHAVIOR
Expect ...personalize mass update progress apply and view results is fast

STEPS
The issue can be reproduced at will with the following steps:

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.

Here are expensive queries :

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'

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 24 0.00 0.00 0 0 0 0
Fetch 48 0.61 0.61 4 51840 0 336
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 73 0.61 0.62 4 51840 0 336


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;

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 66 11.22 11.03 505 17998 62618 66
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 67 11.22 11.03 505 17998 62618 66


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

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 611 0.25 0.17 0 0 0 0
Fetch 611 0.03 0.03 0 1833 0 611
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1222 0.28 0.21 0 1833 0 611



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;

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 6.22 6.07 63 46491 2886 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 6.22 6.08 63 46491 2886 1



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;

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 25 0.47 0.48 5 2605 0 25
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 25 0.47 0.48 5 2605 0 25

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