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

TABLE: MSC.MSC_ERRORS

Object Details
Object Name: MSC_ERRORS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ERRORS
Subobject Name:
Status: VALID


Stores the Errors that have occured during the pre-processing. ERROR_ID is a unique identifier for each record. TABLE_NAME stores the staging table name in which the error occured. TRANSACTION_ID maps to ST_TRANSACTION_ID of the staging table. ERROR_TEXT stores the error description. If SEVERITY is 1 then the message is an error message and if SEVERITY is 2 then it is a warning message. RROW stores the concatenated row in the staging table for this error.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_ERRORS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnERROR_ID
ColumnINSTANCE_CODE
ColumnSEVERITY
SYS_IL0000169784C00020$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
ERROR_ID NUMBER

Error Identifier to uniquely identify the error
TRANSACTION_ID NUMBER

Transaction Id from the staging table for this record
MESSAGE_ID NUMBER

Message Id
INSTANCE_CODE VARCHAR2 (3)
Instance Code
TABLE_NAME VARCHAR2 (30)
Table name in which error has occured
PROPAGATED VARCHAR2 (1)
Flag to indicate whether the error occured for this record or was propagated to this by some related record
SOURCE VARCHAR2 (15)
Source
ERROR_TEXT VARCHAR2 (2000)
If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
SEVERITY NUMBER

Severity
MESSAGE_SENT NUMBER

Message Sent
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
CREATION_DATE DATE

Standard WHO column
CREATED_BY NUMBER

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
REQUEST_ID NUMBER

Concurrent WHO column
PROGRAM_APPLICATION_ID NUMBER

Concurrent WHO column
PROGRAM_ID NUMBER

Concurrent WHO column
PROGRAM_UPDATE_DATE DATE

Concurrent WHO column
RROW CLOB (4000)
Concatenated data for the errored record
Query Text

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


SELECT ERROR_ID
,      TRANSACTION_ID
,      MESSAGE_ID
,      INSTANCE_CODE
,      TABLE_NAME
,      PROPAGATED
,      SOURCE
,      ERROR_TEXT
,      SEVERITY
,      MESSAGE_SENT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RROW
FROM MSC.MSC_ERRORS;

Dependencies

[top of page]

MSC.MSC_ERRORS does not reference any database object

MSC.MSC_ERRORS is referenced by following:

SchemaMSC
ViewMSC_ERRORS#