Some Information on Top Ten List feature on Navigator form
The top ten is saved to the FND_USER_DESKTOP_OBJECTS table. The table is read from at sign on. It is updated from the API function FND_SIGNON.UPDATE_NAVIGATOR when the user logs out.
SQL> select user_id from fnd_user where user_name = ‘<USER>’;
select application_id, responsibility_id
from fnd_responsibility
where responsibility_key = ‘<<RESPNAME>>’;
Select function_name, object_name
from fnd_user_desktop_objects
where user_id = ‘<result from #1>’
and responsibility_id = ‘<result from #2>’
and application_id = ‘<result from #2>’=
Where are the “Favorites” stored when you use the Self-Service pages instead of the “Professional” user interface forms?
LikeLike
— R12 Navigator Favorites
SELECT fu.user_name
, fu.description
, iccme.display_sequence seq
, iccme.prompt
, frt.responsibility_name
FROM icx.icx_custom_menu_entries iccme
, applsys.fnd_user fu
, applsys.fnd_responsibility_tl frt
— , applsys.fnd_responsibility fr
, applsys.fnd_form_functions_tl ffft
WHERE iccme.user_id = fu.user_id
AND iccme.responsibility_id = frt.responsibility_id
AND iccme.function_id = ffft.function_id
AND fu.user_name = ‘ZZALSJR8’
ORDER BY 1,2,3;
— URLs
SELECT fu.user_name
, fu.description
, iccme.display_sequence seq
, iccme.prompt
, iccme.url
FROM icx.icx_custom_menu_entries iccme
, applsys.fnd_user fu
WHERE iccme.user_id = fu.user_id
AND iccme.url IS NOT NULL
ORDER BY 1,2,3;
LikeLike
nice
LikeLike