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_OPTIONS

Object Details

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

FND_PROFILE_OPTIONS stores information about user profile options.
Each row includes names (the actual profile option name and the
more descriptive end-user name) and a description of the profile
option. Each row also includes the LOV definition, if any,
that this profile option uses to ensure that users enter a valid
value for the option, as well as flags that indicate whether users
can see or change its value and flags that indicate whether certain
Oracle Application Object Library routines can manipulate this
option. Each row also includes start and end dates, if any, for
this option. You need one row for each profile option (other than
internally generated profile options). Oracle Application Object
Library uses this information to generate user profiles.
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_PROFILE_OPTIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	APPLICATION_ID PROFILE_OPTION_ID
FND_PROFILE_OPTIONS_U2	NORMAL	UNIQUE	APPS_TS_SEED	PROFILE_OPTION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER		Yes	Application identifier
PROFILE_OPTION_ID	NUMBER		Yes	Profile option identifier
PROFILE_OPTION_NAME	VARCHAR2	(80)	Yes	Name of the profile option
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
WRITE_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if user exits or forms can update the profile option
READ_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if user exits or forms can read the profile option
USER_CHANGEABLE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if users can update the value for the profile option
USER_VISIBLE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if users can see the value for the profile option
SITE_ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the profile option is enabled at the site level
SITE_UPDATE_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the profile option should be updatable at the site level
APP_ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the profile option is enabled at the application level
APP_UPDATE_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the profile option should be updatable at the application level
RESP_ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the profile option is enabled at the responsibility level
RESP_UPDATE_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the profile option should be updatable at the responsibility level
USER_ENABLED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the profile option is enabled at the user level
USER_UPDATE_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the profile option should be updatable at the user level
START_DATE_ACTIVE	DATE		Yes	The date the profile option becomes active
SQL_VALIDATION	VARCHAR2	(2000)		The validation criteria for LOV definition of profile option values
END_DATE_ACTIVE	DATE			The date the profile option expires
HIERARCHY_TYPE	VARCHAR2	(8)		HIERARCHY_TYPE
SERVER_ENABLED_FLAG	VARCHAR2	(1)		SERVER_ENABLED_FLAG
ORG_ENABLED_FLAG	VARCHAR2	(1)		ORG_ENABLED_FLAG
SERVER_UPDATE_ALLOWED_FLAG	VARCHAR2	(1)		SERVER_UPDATE_ALLOWED_FLAG
ORG_UPDATE_ALLOWED_FLAG	VARCHAR2	(1)		ORG_UPDATE_ALLOWED_FLAG
SERVERRESP_ENABLED_FLAG	VARCHAR2	(1)	Yes	Whether the profile is enabled at the server/responsibility level
SERVERRESP_UPDATE_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Whether the profile can be updated at the server/responsibility level

Query Text

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


SELECT APPLICATION_ID
,      PROFILE_OPTION_ID
,      PROFILE_OPTION_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WRITE_ALLOWED_FLAG
,      READ_ALLOWED_FLAG
,      USER_CHANGEABLE_FLAG
,      USER_VISIBLE_FLAG
,      SITE_ENABLED_FLAG
,      SITE_UPDATE_ALLOWED_FLAG
,      APP_ENABLED_FLAG
,      APP_UPDATE_ALLOWED_FLAG
,      RESP_ENABLED_FLAG
,      RESP_UPDATE_ALLOWED_FLAG
,      USER_ENABLED_FLAG
,      USER_UPDATE_ALLOWED_FLAG
,      START_DATE_ACTIVE
,      SQL_VALIDATION
,      END_DATE_ACTIVE
,      HIERARCHY_TYPE
,      SERVER_ENABLED_FLAG
,      ORG_ENABLED_FLAG
,      SERVER_UPDATE_ALLOWED_FLAG
,      ORG_UPDATE_ALLOWED_FLAG
,      SERVERRESP_ENABLED_FLAG
,      SERVERRESP_UPDATE_ALLOWED_FLAG
FROM APPLSYS.FND_PROFILE_OPTIONS;

Dependencies

[top of page]

APPLSYS.FND_PROFILE_OPTIONS does not reference any database object

APPLSYS.FND_PROFILE_OPTIONS is referenced by following:

APPS: AS_FORECAST_MV; FND_PROFILE_OPTIONS