WIE_INT_ERRORS
This table stores the errors that were raised when an interface batch fails to process successfully by the system. These errors could represent problems due to incorrect data, business rule validation failures, and/or more critical issues related to environment or database problems.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
WIE_INT_ERRORS_PK |
INTERFACE_ERROR_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INTERFACE_ERROR_ID | NUMBER | 18 | Yes | The unique identifier of an interface batch errors record. Its value is an application generated unique id. | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
INTERFACE_ROW_ID | NUMBER | 18 | Yes | Represents the foreign key to the interface record that contains the error. This foreign key could be from any one of the interface tables that exist in Fusion Manufacturing. | |
INTERFACE_BATCH_ID | NUMBER | 18 | Represents the internal interface batch identifier. This is used to group a batch of interface records for processing. When interface records are brought in via services or the UI, the system will internally generate this value. | ||
ERROR_TEXT | VARCHAR2 | 2000 | Represents the translated error text for a given batch that failed to process successfully. | ||
ERROR_LANGUAGE | VARCHAR2 | 4 | Yes | Indicates the code of the language into which the contents of the translatable columns are translated. | |
TABLE_NAME | VARCHAR2 | 30 | Yes | Indicates the table from which the data and resulting error is being triggered. | |
COLUMN_NAME | VARCHAR2 | 30 | Indicates the table column from which the data and resulting error is being triggered. This value represents the column from the table that is identified in the TABLE_NAME column. | ||
MESSAGE_NAME | VARCHAR2 | 30 | Indicates the actual message name value from FND_MESSAGES if available. For example: FND_CMN_INVALID_ATTRB_API_SERV or WIE_WEWO_OP_WCENTER_REQD | ||
MESSAGE_TOKEN_NAMES | VARCHAR2 | 1000 | Concatenated string of token names for the error message. This can be populated when we have control of the message. | ||
MESSAGE_TOKEN_VALUES | VARCHAR2 | 1000 | Concatenated string of token values for the error message. This can be populated when we have control of the message. | ||
PROGRAM_NAME | VARCHAR2 | 100 | The PL/SQL program name or any other java class reference from where the error is being triggered. Primarily useful to development when debugging issues to identify where errors are being triggered. | ||
MESSAGE_SEVERITY | VARCHAR2 | 1 | Indicates the severity of the error. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
WIE_INT_ERRORS_N01 | Non Unique | Default | INTERFACE_BATCH_ID, INTERFACE_ROW_ID, TABLE_NAME |
WIE_INT_ERRORS_N02 | Non Unique | Default | INTERFACE_ROW_ID |
WIE_INT_ERRORS_N03 | Non Unique | Default | INTERFACE_BATCH_ID, TABLE_NAME |
WIE_INT_ERRORS_N04 | Non Unique | Default | TABLE_NAME |
WIE_INT_ERRORS_U01 | Unique | Default | INTERFACE_ERROR_ID |