20091005 checking fnd_user_preferences - plembo/onemoretech GitHub Wiki

title: Checking fnd_user_preferences link: https://onemoretech.wordpress.com/2009/10/05/checking-fnd_user_preferences/ author: lembobro description: post_id: 233 created: 2009/10/05 13:37:13 created_gmt: 2009/10/05 13:37:13 comment_status: open post_name: checking-fnd_user_preferences status: publish post_type: post

Checking fnd_user_preferences

In Oracle’s Enterprise Business Suite (EBS), the fnd_user_preferences table contains some important parameters related to identity management. These are mostly set when you register an EBS instance with a 10g AS (Application Server) identity infrastructure (i.e. using the txkrun.pl script).

Some of the parameters you’ll see are OIDhost, OIDport, SSLOnly, appname.

This information can be helpful in validating that things are properly configured.

To display the values set, run the following SQL against the EBS database as the APPS user:

select USER_NAME,MODULE_NAME, PREFERENCE_NAME,PREFERENCE_VALUE from fnd_user_preferences where USER_NAME = '#INTERNAL';