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_CC_INTERFACE_ERRORS

Object Details

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

The MTL_CC_INTERFACE_ERRORS table is populated with errors encountered while processing interface rows. This table allows reporting multiple errors per interface record. The CC_ENTRY_INTERFACE_ID is a foreign key to this table so that users may query up interface errors by record. Users can view all error information, including error code and text via the Cycle Count Entries Interface Inquiry/Update form. This errors table includes only all the errors from the last processing run of the cycle count interface entry. Before each interface record processing, the errors of this record are deleted.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_CC_INTERFACE_ERRORS_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CC_ENTRY_INTERFACE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_ERROR_ID	NUMBER	(38)	Yes	Unique identifier for this error
CC_ENTRY_INTERFACE_ID	NUMBER	(38)	Yes	Cycle Count Entries Open Interface identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(38)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(38)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(38)		Standard Who column
REQUEST_ID	NUMBER	(38)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(38)		Standard Who column
PROGRAM_ID	NUMBER	(38)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
ERROR_MESSAGE	VARCHAR2	(240)		Error message
ERROR_COLUMN_NAME	VARCHAR2	(32)		Error Column name
ERROR_TABLE_NAME	VARCHAR2	(30)		Error Table name
MESSAGE_NAME	VARCHAR2	(30)		Message name

Query Text

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


SELECT INTERFACE_ERROR_ID
,      CC_ENTRY_INTERFACE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ERROR_MESSAGE
,      ERROR_COLUMN_NAME
,      ERROR_TABLE_NAME
,      MESSAGE_NAME
FROM INV.MTL_CC_INTERFACE_ERRORS;

Dependencies

[top of page]

INV.MTL_CC_INTERFACE_ERRORS does not reference any database object

INV.MTL_CC_INTERFACE_ERRORS is referenced by following:

APPS: MTL_CC_INTERFACE_ERRORS