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

TABLE: APPLSYS.FND_LOGINS

Object Details
Object Name: FND_LOGINS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_LOGINS
Subobject Name:
Status: VALID


FND_LOGINS stores Sign-On Audit information about who signs on to
an application and when. Each row includes values that identify
the user, the ORACLE process (PID), the operating system process
(SPID), the operating system terminal, and the operating system
login name. SESSION_NUMBER contains the number of times the user
has signed on to an application since you have upgraded to Release
7 of the Oracle Applications. If the sign-on was performed by a
concurrent process, SUBMITTED_LOGIN_ID identifies who submitted the
concurrent request. If Sign-On Audit has been enabled at the User
level or higher, you get one row for each time a person signs on
to an application (using the sign-on screen) during the time
Sign-On Audit is active. Oracle Application Object Library uses
this information to track users for Sign-On Audit and Help User.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_LOGINS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnLOGIN_ID
FND_LOGINS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSPID
FND_LOGINS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnUSER_ID
Columns
Name Datatype Length Mandatory Comments
LOGIN_ID NUMBER
Yes Identifier of login session
USER_ID NUMBER
Yes User identifier
START_TIME DATE
Yes The starting time of this login session
END_TIME DATE

Time when this login session ends
PID NUMBER

Oracle process identifier
SPID VARCHAR2 (30)
Operating system process identifier
TERMINAL_ID VARCHAR2 (30)
Terminal identifier from which user starts this session
LOGIN_NAME VARCHAR2 (30)
The username used to sign on to Oracle Applications
SESSION_NUMBER NUMBER

The number of times the user has signed on to an application since you upgraded Oracle Applications to Release 7
SUBMITTED_LOGIN_ID NUMBER

The user who submitted the concurrent request that starts this sign-on session
SERIAL# NUMBER

Serial number
PROCESS_SPID VARCHAR2 (30)
SPID of process
LOGIN_TYPE VARCHAR2 (8)
Type of session
Query Text

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


SELECT LOGIN_ID
,      USER_ID
,      START_TIME
,      END_TIME
,      PID
,      SPID
,      TERMINAL_ID
,      LOGIN_NAME
,      SESSION_NUMBER
,      SUBMITTED_LOGIN_ID
,      SERIAL#
,      PROCESS_SPID
,      LOGIN_TYPE
FROM APPLSYS.FND_LOGINS;

Dependencies

[top of page]

APPLSYS.FND_LOGINS does not reference any database object

APPLSYS.FND_LOGINS is referenced by following:

SchemaAPPS
SynonymFND_LOGINS