eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_LOG_TRANSACTION_CONTEXT

Object Details

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.)

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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.

Query Text

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;

Dependencies

[top of page]

APPLSYS.FND_LOG_TRANSACTION_CONTEXT does not reference any database object

APPLSYS.FND_LOG_TRANSACTION_CONTEXT is referenced by following:

APPLSYS: FND_LOG_TRANSACTION_CONTEXT#