FND_SESSION_ATTRIBUTES
This table contains information about the attributes of the sessions stored in the parent sessions table, for example the session language or the current timezone. It is a child table of FND_SESSIONS. 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_SESSION_ATTRIBUTES_PK |
SESSION_ID, NAMESPACE, ATTRIBUTE_NAME, ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| SESSION_ID | VARCHAR2 | 32 | Yes | SESSION_ID | |
| NAMESPACE | VARCHAR2 | 100 | Yes | NAMESPACE | |
| ATTRIBUTE_NAME | VARCHAR2 | 100 | Yes | ATTRIBUTE_NAME | |
| ATTRIBUTE_VALUE | VARCHAR2 | 4000 | ATTRIBUTE_VALUE | ||
| ATTRIBUTE_FLAGS | VARCHAR2 | 255 | ATTRIBUTE_FLAGS | ||
| LAST_CONNECT | DATE | LAST_CONNECT |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_SESSION_ATTRIBUTES_U1 | Unique | Default | SESSION_ID, NAMESPACE, ATTRIBUTE_NAME, ENTERPRISE_ID |