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_APPL_SESSIONS

Object Details

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

FND_APPL_SESSIONS stores auditing information for non-Forms based applications sessions.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_APPL_SESSIONS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	AUDSID
FND_APPL_SESSIONS_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	LOGIN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LOGIN_TYPE	VARCHAR2	(8)	Yes	Type of session
LOGIN_ID	NUMBER		Yes	Identifier of login session (FK fnd_logins.login_id)
AUDSID	NUMBER		Yes	db audsid (v$session.audsid)
START_TIME	DATE		Yes	Session start time
END_TIME	DATE			Session end time
RESOURCE_CONSUMER_GROUP	VARCHAR2	(32)		Resource Consumer Group in which this session ran or was running
LOGIN_RESP_ID	NUMBER	(15)		Responsibility identifier (FK fnd_login_responsibilities.login_resp_id)

Query Text

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


SELECT LOGIN_TYPE
,      LOGIN_ID
,      AUDSID
,      START_TIME
,      END_TIME
,      RESOURCE_CONSUMER_GROUP
,      LOGIN_RESP_ID
FROM APPLSYS.FND_APPL_SESSIONS;

Dependencies

[top of page]

APPLSYS.FND_APPL_SESSIONS does not reference any database object

APPLSYS.FND_APPL_SESSIONS is referenced by following:

APPLSYS: FND_APPL_SESSIONS#