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: XTR.XTR_INTERFACE_ERRORS

Object Details

Object Name:	XTR_INTERFACE_ERRORS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_INTERFACE_ERRORS
Subobject Name:
Status:	VALID

This table contains all the errors generated by the transfer from the Xtr_Deals_Interface to the Xtr_Deals table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_INTERFACE_ERRORS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEAL_TYPE EXTERNAL_DEAL_ID TRANSACTION_NO ERROR_CODE ERROR_COLUMN

Columns

Name	Datatype	Length	Mandatory	Comments
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER			Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
EXTERNAL_DEAL_ID	VARCHAR2	(240)	Yes	References the Xtr_Deals_Interface table.
DEAL_TYPE	VARCHAR2	(7)	Yes	Denotes the column in Xtr_Deals_Interface that contains the error. The column names are derived from View Object (XtrDealsInterfaceVO) Attributes generated by BC4J.
ERROR_COLUMN	VARCHAR2	(30)	Yes	Stores the message name of the error and references the message table for the description of the error.
ERROR_CODE	VARCHAR2	(30)	Yes	Stores the message name of the error and references the message table for the description of the error.
TRANSACTION_NO	NUMBER	(7)		Identifies to which transaction the error pertains. This valud is null if the error pertains to the deal information

Query Text

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


SELECT CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      EXTERNAL_DEAL_ID
,      DEAL_TYPE
,      ERROR_COLUMN
,      ERROR_CODE
,      TRANSACTION_NO
FROM XTR.XTR_INTERFACE_ERRORS;

Dependencies

[top of page]

XTR.XTR_INTERFACE_ERRORS does not reference any database object

XTR.XTR_INTERFACE_ERRORS is referenced by following:

XTR: XTR_INTERFACE_ERRORS#