FND_SESSION_USERS
This table contains the user name and user ID of every user that has signed into the applications. It is meant for internal use only.
Details
-
Schema: SESSIONS
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FND_SESSION_USERS_PK |
USER_GUID, ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| USER_GUID | VARCHAR2 | 64 | Yes | USER_GUID | |
| USER_NAME | VARCHAR2 | 100 | Yes | USER_NAME | |
| LAST_ACTIVITY_DATE | DATE | LAST_ACTIVITY_DATE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_SESSION_USERS_N1 | Non Unique | Default | ENTERPRISE_ID, UPPER("USER_NAME") |
| FND_SESSION_USERS_U1 | Unique | Default | USER_GUID, ENTERPRISE_ID |
| FND_SESSION_USERS_U2 | Unique | Default | USER_NAME, ENTERPRISE_ID |