eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: BNE.BNE_USER_SETTINGS

Object Details

Object Name:	BNE_USER_SETTINGS
Object Type:	TABLE
Owner:	BNE
FND Design Data:	BNE.BNE_USER_SETTINGS
Subobject Name:
Status:	VALID

BNE_USER_SETTINGS stores user specific data values used by the run-time application. These data values are used to remember previous decisions the user has made in Web ADI, across multiple sessions. For example, the document creation settings are stored so that the next time the user creates a document, their previous selections are defaulted for them.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BNE_USER_SETTINGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	USER_ID SETTING_GROUP SETTING_NAME
SYS_IL0000239830C00010$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
USER_ID	NUMBER	(15)	Yes	User Id (foreign key to FND_USER.USER_ID).
SETTING_GROUP	VARCHAR2	(255)	Yes	Grouping of settings. Can be used to create levels of settings.
SETTING_NAME	VARCHAR2	(255)	Yes	Name of setting.
SETTING_VALUE	VARCHAR2	(2000)		Value of setting. This column is deprecated in favour of SETTING_VALUE_CLOB.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
SETTING_VALUE_CLOB	CLOB	(4000)		A replacement for SETTING_VALUE for settings greater then 2000 characters.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USER_ID
,      SETTING_GROUP
,      SETTING_NAME
,      SETTING_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      SETTING_VALUE_CLOB
FROM BNE.BNE_USER_SETTINGS;

Dependencies

[top of page]

BNE.BNE_USER_SETTINGS does not reference any database object

BNE.BNE_USER_SETTINGS is referenced by following:

APPS: BNE_USER_SETTINGS