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: APPLSYS.FND_PROFILE_OPTION_VALUES

Object Details

Object Name:	FND_PROFILE_OPTION_VALUES
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_PROFILE_OPTION_VALUES
Subobject Name:
Status:	VALID

FND_PROFILE_OPTION_VALUES stores values for user profile options.
Each row includes values that identify the profile option, the
profile level, the user, responsibility, application or site for
whom the profile value is set (LEVEL_VALUE). Each row also include
the actual value for the option (always a CHAR string). If the
option is set for a responsibility, LEVEL_VALUE_APPLICATION_ID
identifies the application that has the responsibility. You need
one row for each profile option setting (at each level, for each
user, and so on). Oracle Application Object Library uses this
information to operate applications according to user profiles.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_PROFILE_OPTION_VALUES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID PROFILE_OPTION_ID LEVEL_ID LEVEL_VALUE LEVEL_VALUE_APPLICATION_ID LEVEL_VALUE2
FND_PROFILE_OPTION_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEVEL_ID LEVEL_VALUE LEVEL_VALUE_APPLICATION_ID LEVEL_VALUE2

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER		Yes	Application identifier
PROFILE_OPTION_ID	NUMBER		Yes	Profile option identifier
LEVEL_ID	NUMBER		Yes	Profile level identifier
LEVEL_VALUE	NUMBER		Yes	The value of the profile level
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
PROFILE_OPTION_VALUE	VARCHAR2	(240)		The value of the profile option
LEVEL_VALUE_APPLICATION_ID	NUMBER	(15)		Application identifier for the profile level "Application"
LEVEL_VALUE2	NUMBER			Used in the Server/Responsibility level of the SERVRESP hierarchy to store the server_id or a default value

Query Text

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


SELECT APPLICATION_ID
,      PROFILE_OPTION_ID
,      LEVEL_ID
,      LEVEL_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROFILE_OPTION_VALUE
,      LEVEL_VALUE_APPLICATION_ID
,      LEVEL_VALUE2
FROM APPLSYS.FND_PROFILE_OPTION_VALUES;

Dependencies

[top of page]

APPLSYS.FND_PROFILE_OPTION_VALUES does not reference any database object

APPLSYS.FND_PROFILE_OPTION_VALUES is referenced by following:

APPS: AS_FORECAST_MV; FND_PROFILE_OPTION_VALUES