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_LOGIN_RESPONSIBILITIES

Object Details

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

FND_LOGIN_RESPONSIBILITIES stores information about Sign-On Audit
information about who changes responsibilities in an application
and when. Each row includes values that identify the user's login
session, the user's current responsibility, and when the user is
in the responsibility. If Sign-On Audit has been enabled at the
responsibility level or higher, you get one row for each time a
person changes responsibilities in an application during the time
Sign-On Audit is active. Oracle Application Object Library uses
this information to track users for Sign-On Audit.
.
.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_LOGIN_RESPONSIBILITIES_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	LOGIN_ID LOGIN_RESP_ID
FND_LOGIN_RESPONSIBILITIES_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	AUDSID

Columns

Name	Datatype	Length	Mandatory	Comments
LOGIN_ID	NUMBER		Yes	Identifier of the user's login session
LOGIN_RESP_ID	NUMBER		Yes	The responsibility to which the user signed on
RESP_APPL_ID	NUMBER		Yes	The application identifier with which the responsibility is defined
RESPONSIBILITY_ID	NUMBER		Yes	Responsibility identifier
START_TIME	DATE		Yes	The time when the user is in the responsibility
END_TIME	DATE			The time when the user left the responsibility
AUDSID	NUMBER			db audsid (v$session.audsid)
RESOURCE_CONSUMER_GROUP	VARCHAR2	(32)		Resource consumer group

Query Text

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


SELECT LOGIN_ID
,      LOGIN_RESP_ID
,      RESP_APPL_ID
,      RESPONSIBILITY_ID
,      START_TIME
,      END_TIME
,      AUDSID
,      RESOURCE_CONSUMER_GROUP
FROM APPLSYS.FND_LOGIN_RESPONSIBILITIES;

Dependencies

[top of page]

APPLSYS.FND_LOGIN_RESPONSIBILITIES does not reference any database object

APPLSYS.FND_LOGIN_RESPONSIBILITIES is referenced by following:

APPS: FND_LOGIN_RESPONSIBILITIES