FND_SESSIONS
This table contains the sessions that are created when users sign into the applications. It is meant for internal use only.
Details
-
Schema: SESSIONS
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FND_SESSIONS_PK |
SESSION_ID, ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| SESSION_ID | VARCHAR2 | 32 | Yes | SESSION_ID | |
| SESSION_COOKIE | VARCHAR2 | 64 | SESSION_COOKIE | ||
| USER_GUID | VARCHAR2 | 64 | Yes | USER_GUID | |
| USER_NAME | VARCHAR2 | 2000 | Yes | USER_NAME | |
| PRODUCT_FAMILY | VARCHAR2 | 30 | PRODUCT_FAMILY | ||
| PRODUCT | VARCHAR2 | 30 | PRODUCT | ||
| INDUSTRY | VARCHAR2 | 30 | INDUSTRY | ||
| TERRITORY | VARCHAR2 | 30 | TERRITORY | ||
| LANGUAGE_TAG | VARCHAR2 | 30 | LANGUAGE_TAG | ||
| NLS_LANGUAGE | VARCHAR2 | 30 | NLS_LANGUAGE | ||
| NLS_SORT | VARCHAR2 | 30 | NLS_SORT | ||
| SECURITY_ATTR_SET_KEY | VARCHAR2 | 64 | SECURITY_ATTR_SET_KEY | ||
| SESSION_ATTR_SET_KEY | VARCHAR2 | 64 | SESSION_ATTR_SET_KEY | ||
| DISABLED_FLAG | VARCHAR2 | 1 | DISABLED_FLAG | ||
| PURGE_IMMEDIATE | VARCHAR2 | 1 | PURGE_IMMEDIATE | ||
| COUNTER | NUMBER | COUNTER | |||
| FIRST_CONNECT | DATE | FIRST_CONNECT | |||
| LAST_CONNECT | DATE | LAST_CONNECT | |||
| LIMIT_TIME | NUMBER | LIMIT_TIME | |||
| LIMIT_CONNECTS | NUMBER | LIMIT_CONNECTS | |||
| TIMEOUT | NUMBER | TIMEOUT | |||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| SESSION_ROLE_SET_KEY | VARCHAR2 | 64 | Holds the Session Role Key. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_SESSIONS_N1 | Non Unique | Default | SESSION_ROLE_SET_KEY |
| FND_SESSIONS_N2 | Non Unique | Default | FIRST_CONNECT, ENTERPRISE_ID |
| FND_SESSIONS_U1 | Unique | Default | SESSION_ID, ENTERPRISE_ID |
| FND_SESSIONS_U2 | Unique | Default | SESSION_COOKIE |