Monday, October 5, 2009
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';