FND_SESSION_USER_ACTIVITY
This table tracks UI activity for the given user.
Details
-
Schema: SESSIONS
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| USER_GUID | VARCHAR2 | 64 | Yes | USER_GUID |
| USER_NAME | VARCHAR2 | 100 | Yes | USER_NAME |
| IMPERSONATOR_GUID | VARCHAR2 | 64 | IMPERSONATOR_GUID | |
| IMPERSONATOR_NAME | VARCHAR2 | 100 | IMPERSONATOR_NAME | |
| CHANNEL | VARCHAR2 | 30 | CHANNEL | |
| ACTIVITY_DATE | DATE | Yes | ACTIVITY_DATE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_SESSION_USER_ACTIVITY_N1 | Non Unique | Default | USER_GUID |
| FND_SESSION_USER_ACTIVITY_N2 | Non Unique | Default | IMPERSONATOR_GUID |
| FND_SESSION_USER_ACTIVITY_N3 | Non Unique | Default | ACTIVITY_DATE |