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: ECX.ECX_OXTA_LOGMSG

Object Details

Object Name:	ECX_OXTA_LOGMSG
Object Type:	TABLE
Owner:	ECX
FND Design Data:	ECX.ECX_OXTA_LOGMSG
Subobject Name:
Status:	VALID

This table contains the Oracle Transport Agent message logs

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECX_OXTA_LOGMSG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DIRECTION STATUS RESULT_CODE
ECX_OXTA_LOGMSG_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SENDER_MESSAGE_ID
ECX_OXTA_LOGMSG_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIPT_MESSAGE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SENDER_MESSAGE_ID	VARCHAR2	(50)	Yes	Sender Message Identifier
DIRECTION	VARCHAR2	(3)	Yes	Message Direction
STATUS	VARCHAR2	(15)	Yes	Message Status
BEGIN_DATE	DATE		Yes	Message Start Date
REQUEST_TYPE	VARCHAR2	(15)	Yes	Request Type
CONTENT_LENGTH	NUMBER			Message length
TRANSACTION_TYPE	VARCHAR2	(30)		Transaction Type
USERNAME	VARCHAR2	(500)		UserName
IP_ADDRESS	VARCHAR2	(15)		IP Address
PROTOCOL_TYPE	VARCHAR2	(80)		Protocol Type
PROTOCOL_ADDRESS	VARCHAR2	(500)		Protocol Address
RESULT_CODE	VARCHAR2	(4)		Result Status Code
RESULT_TEXT	VARCHAR2	(2000)		Result Message
RECEIPT_MESSAGE_ID	VARCHAR2	(50)		Receipt Message Identifier
COMPLETED_DATE	DATE			Message Processing Date
EXCEPTION_TEXT	VARCHAR2	(2000)		Exception Message

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SENDER_MESSAGE_ID
,      DIRECTION
,      STATUS
,      BEGIN_DATE
,      REQUEST_TYPE
,      CONTENT_LENGTH
,      TRANSACTION_TYPE
,      USERNAME
,      IP_ADDRESS
,      PROTOCOL_TYPE
,      PROTOCOL_ADDRESS
,      RESULT_CODE
,      RESULT_TEXT
,      RECEIPT_MESSAGE_ID
,      COMPLETED_DATE
,      EXCEPTION_TEXT
FROM ECX.ECX_OXTA_LOGMSG;

Dependencies

[top of page]

ECX.ECX_OXTA_LOGMSG does not reference any database object

ECX.ECX_OXTA_LOGMSG is referenced by following:

APPS: ECX_OXTA_LOGMSG