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: WIP.WIP_INTERFACE_ERRORS

Object Details

Object Name:	WIP_INTERFACE_ERRORS
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_INTERFACE_ERRORS
Subobject Name:
Status:	VALID

WIP_INTERFACE_ERRORS stores the text of errors or warnings issued when loading information through the WIP Scheduling and Open Job and
Schedule interfaces. It also stores information about the load
requests that generate the errors. When the WIP Mass Load program loads records from the WIP Scheduling Interface, you can print a report showing these errors.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_INTERFACE_ERRORS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_ID	NUMBER		Yes	Uniquely identifies the request that produced the error
ERROR_TYPE	NUMBER		Yes	Type of error
ERROR	VARCHAR2	(500)		Error text
LAST_UPDATE_DATE	DATE			Standard Who column
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column

Query Text

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


SELECT INTERFACE_ID
,      ERROR_TYPE
,      ERROR
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
FROM WIP.WIP_INTERFACE_ERRORS;

Dependencies

[top of page]

WIP.WIP_INTERFACE_ERRORS does not reference any database object

WIP.WIP_INTERFACE_ERRORS is referenced by following:

WIP: WIP_INTERFACE_ERRORS#