[Home] [Help]
[Dependency Information]
Object Name: | MSC_ERRORS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | ![]() |
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.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_ERRORS_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() |
SYS_IL0000169784C00020$$ | LOB | UNIQUE |
![]() |
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 |
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;
MSC.MSC_ERRORS does not reference any database object
MSC.MSC_ERRORS is referenced by following:
|
|
|