NIR Link And UI Navigation Is Taking Longer Time To Open Including Search On Change Simple Search Page
Last updated on MAY 17, 2017
Applies to:Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.
First time opening NIR / ECO takes about 60 seconds and about 50 seconds there after.
Performance should be consistent and perhaps lower. Sometimes it takes over 3-4 mins.
The issue can be reproduced at will with the following steps:
1. Navigate to Development Manager Responsibility
2. Change Simple Search -> Query for any Change Order
Results like the following may be seen in the trace log as the high cost query:
SELECT * FROM ((SELECT DISTINCT m.menu_name as name,
m.user_menu_name as display_name
FROM fnd_menus_vl m, fnd_grants g
WHERE m.menu_id = g.menu_id
AND m.menu_name LIKE 'SESG%'
AND g.start_date <= SYSDATE
AND NVL(g.end_date, SYSDATE) >= SYSDATE
AND (g.grantee_type='GLOBAL' OR
FROM WF_USER_ROLES WUR
WHERE WUR.user_name = :1
AND WUR.user_orig_system = :2
AND WUR.user_orig_system_id= :3) OR
from jtf_rs_groups_vl jrgv,
and jrrev.user_name = :4)))) QRSLT ORDER BY display_name
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