Oracle EBS – TABLES USED BY FNDSCSGN – TOP TEN LIST feature


By default, the Top Ten List appears on the right half side of the FNDSCSGN form.  You can access this list by first clicking on the toolbar ‘Special’ button and then clicking on the Top Ten List on the popup.
You may want to access the table and perhaps update the columns for the Top Ten List.
You can obtain information using the Oracle user name:

SQL>
select fnd_RESPONSIBILITY.RESPONSIBILITY_NAME,function1,        function2,function3,function4,function5,        function6,function7,function8,function9,function10        from fnd_user_RESPONSIBILITY,fnd_RESPONSIBILITY,fnd_user        where fnd_user.user_name ='SPUROHIT'        and fnd_user_RESPONSIBILITY.responsibility_id =        fnd_RESPONSIBILITY.responsibility_id        and fnd_RESPONSIBILITY.application_id =        fnd_user_RESPONSIBILITY.application_id        and fnd_user_RESPONSIBILITY.user_id = fnd_user.user_id;

One thought on “Oracle EBS – TABLES USED BY FNDSCSGN – TOP TEN LIST feature

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