FND_SESSION_TEMPLATES
This table contains templates for 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_SESSION_TEMPLATES_PK |
TEMPLATE_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| TEMPLATE_ID | VARCHAR2 | 32 | Yes | TEMPLATE_ID |
| USER_GUID | VARCHAR2 | 64 | Yes | USER_GUID |
| USER_NAME | VARCHAR2 | 2000 | Yes | USER_NAME |
| LANGUAGE_TAG | VARCHAR2 | 30 | LANGUAGE_TAG | |
| APP_STRIPES | VARCHAR2 | 2000 | APP_STRIPES | |
| PRODUCT_FAMILY | VARCHAR2 | 30 | PRODUCT_FAMILY | |
| PRODUCT | VARCHAR2 | 30 | PRODUCT | |
| INDUSTRY | VARCHAR2 | 30 | INDUSTRY | |
| TERRITORY | VARCHAR2 | 30 | TERRITORY | |
| 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 | |
| SESSION_ROLE_SET_KEY | VARCHAR2 | 64 | Holds the Session Role Key. | |
| LAST_REFRESH_DATE | TIMESTAMP | LAST_REFRESH_DATE | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_SESSION_TEMPLATES_N1 | Non Unique | Default | USER_GUID, LANGUAGE_TAG, APP_STRIPES |
| FND_SESSION_TEMPLATES_U1 | Unique | Default | TEMPLATE_ID |