DBA Data[Home] [Help] [Dependency Information]

TABLE: IEM.IEM_OUTBOX_ERRORS

Object Details
Object Name: IEM_OUTBOX_ERRORS
Object Type: TABLE
Owner: IEM
Subobject Name:
Status: VALID


Contains current data on outbox-processing items that have encountered an error.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEM_OUTBOX_ERRORS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOUTBOX_ERROR_ID
IEM_OUTBOX_ERRORS_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRT_MEDIA_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
OUTBOX_ERROR_ID NUMBER (15) Yes Primary Key.
RT_MEDIA_ITEM_ID NUMBER (15) Yes Foreign key to outbox item in IEM_RT_MEDIA_ITEMS table.
ERROR_SUMMARY VARCHAR2 (500)
User-friendly error message
ERROR_MESSAGE VARCHAR2 (4000)
The complete error message including the stack trace of the problem that occurred.
CREATE_DATE DATE
Yes The time the error occurred.
EXPIRE VARCHAR2 (1)
When set to 'Y', this means the outbox item has been successfully processed and this row may be safely deleted.
Query Text

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


SELECT OUTBOX_ERROR_ID
,      RT_MEDIA_ITEM_ID
,      ERROR_SUMMARY
,      ERROR_MESSAGE
,      CREATE_DATE
,      EXPIRE
FROM IEM.IEM_OUTBOX_ERRORS;

Dependencies

[top of page]

IEM.IEM_OUTBOX_ERRORS does not reference any database object

IEM.IEM_OUTBOX_ERRORS is referenced by following:

SchemaIEM
ViewIEM_OUTBOX_ERRORS#