[Home] [Help] [Dependency Information]
Object Name: | FND_LOG_TRANSACTION_CONTEXT |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_LOG_TRANSACTION_CONTEXT |
Subobject Name: | |
Status: | VALID |
This table stores the context information for a transaction. A
transaction is an instance or an invocation of a component. (e.g. A
concurrent request,an open form, an ICX transaction, etc.)
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_LOG_TRANSACTION_CONTEXT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRANSACTION_CONTEXT_ID |
FND_LOG_TRANSACTION_CONTEXT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CREATION_DATE |
FND_LOG_TRANSACTION_CONTEXT_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TRANSACTION_TYPE
TRANSACTION_ID |
FND_LOG_TRANSACTION_CONTEXT_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
COMPONENT_TYPE
COMPONENT_APPL_ID COMPONENT_ID |
FND_LOG_TRANSACTION_CONTEXT_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SESSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_CONTEXT_ID | NUMBER | Yes | Unique identifier, primary key | |
SESSION_ID | NUMBER | ICX session ID of the session | ||
TRANSACTION_TYPE | VARCHAR2 | (30) | Identifies the type of transaction. Combined with the transaction_id, this is necessary for drilling down to other tables for information on the transaction. | |
TRANSACTION_ID | NUMBER | For requests, the request_id. For services, the concurrent_process_id. Not applicable for Forms | ||
USER_ID | NUMBER | Current user | ||
RESP_APPL_ID | NUMBER | Application ID of current user responsibility | ||
RESPONSIBILITY_ID | NUMBER | ID of current user responsibility | ||
SECURITY_GROUP_ID | NUMBER | Current Security Group ID of user | ||
COMPONENT_TYPE | VARCHAR2 | (30) | Type of application component that posted the exception | |
COMPONENT_APPL_ID | NUMBER | Application ID of component that posted the exception | ||
COMPONENT_ID | NUMBER | ID of component that posted the exception | ||
CREATION_DATE | DATE | Yes | Date when row was created | |
PARENT_CONTEXT_ID | NUMBER | Transaction context ID for the parent context that is raising a proxy alert. |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_CONTEXT_ID
, SESSION_ID
, TRANSACTION_TYPE
, TRANSACTION_ID
, USER_ID
, RESP_APPL_ID
, RESPONSIBILITY_ID
, SECURITY_GROUP_ID
, COMPONENT_TYPE
, COMPONENT_APPL_ID
, COMPONENT_ID
, CREATION_DATE
, PARENT_CONTEXT_ID
FROM APPLSYS.FND_LOG_TRANSACTION_CONTEXT;
APPLSYS.FND_LOG_TRANSACTION_CONTEXT does not reference any database object
APPLSYS.FND_LOG_TRANSACTION_CONTEXT is referenced by following:
|
|
|