Oracle EBS – Top Ten List on Navigator form


Some Information on Top Ten List feature on Navigator form

image

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>’=

Advertisements

4 thoughts on “Oracle EBS – Top Ten List on Navigator form

    • — 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;

      Like

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s