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_ORACLE_USERID

Object Details

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

FND_ORACLE_USERID stores information about ORACLE accounts that
contain application data. Each row includes the ORACLE username
and description, the logical database this ORACLE ID belongs to
(for concurrent processing), whether this ORACLE ID is enabled, and
whether this ORACLE ID is restricted from changing Oracle
Application Object Library data such as menus (READ_ONLY_FLAG).
Oracle Application Object Library does not use ORACLE_PASSWORD,
CONCURRENT_BATCH_QUEUE_ID or READ_ONLY_ORACLE_ID. You need one
row for each ORACLE ID you register. Oracle Application Object
Library uses this information to allow users access to application
data on the basis of responsibility.
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_ORACLE_USERID_U1	NORMAL	UNIQUE	APPS_TS_SEED	ORACLE_ID
FND_ORACLE_USERID_U2	NORMAL	UNIQUE	APPS_TS_SEED	ORACLE_USERNAME

Columns

Name	Datatype	Length	Mandatory	Comments
ORACLE_ID	NUMBER		Yes	Identifier for ORACLE account
ORACLE_USERNAME	VARCHAR2	(30)	Yes	Username for the ORACLE account
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
DESCRIPTION	VARCHAR2	(240)		Description
ENABLED_FLAG	VARCHAR2	(1)		Flag to indicate if the ORACLE account is active
READ_ONLY_FLAG	VARCHAR2	(1)		Flag to indicate if the ORACLE account can update Oracle Application Object Library data
ENCRYPTED_ORACLE_PASSWORD	VARCHAR2	(100)		Password for the ORACLE account in a encrypted format
CONCURRENT_BATCH_QUEUE_ID	NUMBER	(15)		Not currently used
INSTALL_GROUP_NUM	NUMBER			Indicates set of books

Query Text

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


SELECT ORACLE_ID
,      ORACLE_USERNAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      ENABLED_FLAG
,      READ_ONLY_FLAG
,      ENCRYPTED_ORACLE_PASSWORD
,      CONCURRENT_BATCH_QUEUE_ID
,      INSTALL_GROUP_NUM
FROM APPLSYS.FND_ORACLE_USERID;

Dependencies

[top of page]

APPLSYS.FND_ORACLE_USERID does not reference any database object

APPLSYS.FND_ORACLE_USERID is referenced by following:

APPLSYS: FND_ORACLE_USERID#
SYSTEM: FND_ORACLE_USERID