1. Tables and Views for Sales and Fusion Service
  2. MKT_IMP_ERRORS

MKT_IMP_ERRORS

Interface table for storing error messages received during import.

Details

  • Schema: FUSION

  • Object owner: MKT

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

MKT_IMP_ERRORS_PK

ERROR_ID

Columns

Name Datatype Length Precision Not-null Comments Status
ERROR_ID NUMBER 18 Yes Error id is a unique number to identify a row in the error table. It is also the primary key for the table. Active
ERROR_SUPPLEMENTARY CLOB Supplementary error details, which may contain stack-trace.
ERROR_DETAILS VARCHAR2 4000 Detailed error which will be appended to the TOKEN3_VALUE.
COLUMN_NAME_CONTEXT VARCHAR2 80 It will capture additional context information to identify the matching column header.
MESSAGE_PRODUCT_CODE VARCHAR2 30 Indicates the product code which logged the error or warning. It will be used in conjuction with column message_name.
ERROR_TYPE_CODE VARCHAR2 30 Indicates the type of error logged, for example 'ERROR' or 'WARNING'
COMMENTS VARCHAR2 4000 Attribute to capture error messages from ADF/HCM/WS
INTERFACE_TABLE_NAME VARCHAR2 30 Name of the interface table for which the error row is captured. Active
BATCH_ID NUMBER 18 Batch id links the error back to a batch. Active
INTERFACE_ROW_ID NUMBER 18 Interface row id links the error back to a row in the interface table. Interface table name, batch id, and interface row id combination will point to the exact row in the interface table that is linked to the error. Active
MESSAGE_NAME VARCHAR2 300 Message name as defined in FND. This will be used to get the translated message text in the error report. Active
TOKEN1_NAME VARCHAR2 80 Token name as needed by the message. Active
TOKEN1_VALUE VARCHAR2 300 Token value will be substituted for token name. These will be displayed on the error report. Active
TOKEN2_NAME VARCHAR2 80 Token name as needed by the message. Active
TOKEN2_VALUE VARCHAR2 300 Token value will be substituted for token name. These will be displayed on the error report. Active
TOKEN3_NAME VARCHAR2 80 Token name as needed by the message. Active
TOKEN3_VALUE VARCHAR2 300 Token value will be substituted for token name. These will be displayed on the error report. Active
TOKEN4_NAME VARCHAR2 80 Token name as needed by the message. Active
TOKEN4_VALUE VARCHAR2 300 Token value will be substituted for token name. These will be displayed on the error report. Active
TOKEN5_NAME VARCHAR2 80 Token name as needed by the message. Active
TOKEN5_VALUE VARCHAR2 300 Token value will be substituted for token name. These will be displayed on the error report. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 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. Active
SYSTEM_TASK_ID NUMBER 18 System task id of the import activity execution
FILE_RECORD_NUM NUMBER 10 Record number indicator in the file

Indexes

Index Uniqueness Tablespace Columns Status
MKT_IMP_ERRORS_FK1 Non Unique FUSION_TS_INTERFACE INTERFACE_TABLE_NAME, BATCH_ID, INTERFACE_ROW_ID Active
MKT_IMP_ERRORS_N2 Non Unique Default BATCH_ID, FILE_RECORD_NUM
MKT_IMP_ERRORS_PK Unique FUSION_TS_INTERFACE ERROR_ID Active