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: INV.MTL_INTERFACE_ERRORS

Object Details

Object Name:	MTL_INTERFACE_ERRORS
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_INTERFACE_ERRORS
Subobject Name:
Status:	VALID

MTL_INTERFACE_ERRORS stores errors that occur during the item
interface process reporting where the errors occurred along with
the error messages.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_INTERFACE_ERRORS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID TABLE_NAME
MTL_INTERFACE_ERRORS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
MTL_INTERFACE_ERRORS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER			Organization identifier
TRANSACTION_ID	NUMBER			Row identifier for row in MTL_SYSTEM_ITEMS_INTERFACE table
UNIQUE_ID	NUMBER			Unique identifier for the error corresponding to a transaction. For a given transaction there can be multiple errors that should be retrieved in ascending order of the UNIQUE_ID
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
TABLE_NAME	VARCHAR2	(30)		Name of the interface table the error occurred in
MESSAGE_NAME	VARCHAR2	(30)		Message dictionary message name (for future use)
COLUMN_NAME	VARCHAR2	(32)		Column name where the error occurred. This column belongs to the table specified in the TABLE_NAME
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
ERROR_MESSAGE	VARCHAR2	(2000)		Message text for the error that occurred when running the item interface program. It should be used in conjunction with the TABLE_NAME and COLUMN_NAME
ENTITY_IDENTIFIER	VARCHAR2	(30)		Column stores entity identifier during failure in User Attribute concurrent programs
BO_IDENTIFIER	VARCHAR2	(30)		Column stores identifier during failure in User Attribute concurrent programs
MESSAGE_TYPE	VARCHAR2	(1)		Message type to differentiate the message

Query Text

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


SELECT ORGANIZATION_ID
,      TRANSACTION_ID
,      UNIQUE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TABLE_NAME
,      MESSAGE_NAME
,      COLUMN_NAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ERROR_MESSAGE
,      ENTITY_IDENTIFIER
,      BO_IDENTIFIER
,      MESSAGE_TYPE
FROM INV.MTL_INTERFACE_ERRORS;

Dependencies

[top of page]

INV.MTL_INTERFACE_ERRORS does not reference any database object

INV.MTL_INTERFACE_ERRORS is referenced by following:

APPS: MTL_INTERFACE_ERRORS