1. Tables and Views for Sales, Fusion Service, and Field Service
  2. HZ_IMP_ERRORS

HZ_IMP_ERRORS

The import process uses HZ_IMP_ERRORS table to record all errors that occur during import.

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

HZ_IMP_ERRORS_PK

ERROR_SEQ_ID

Columns

Name Datatype Length Precision Not-null Comments
ERROR_SEQ_ID NUMBER 18 Yes Unique id of error record
ERROR_ID NUMBER 18 Yes Indicates that an error has occurred for the record. Also used to join to the appropriate row in the errors table.
BATCH_ID NUMBER 18 Yes Unique identifier for the batch
MESSAGE_NAME VARCHAR2 30 Yes Message name
TOKEN1_NAME VARCHAR2 80 Token name for the error message
TOKEN1_VALUE VARCHAR2 80 Token value for the error message
TOKEN2_NAME VARCHAR2 80 Token name for the error message
TOKEN2_VALUE VARCHAR2 80 Token value for the error message
TOKEN3_NAME VARCHAR2 80 Token name for the error message
TOKEN3_VALUE VARCHAR2 80 Token value for the error message
TOKEN4_NAME VARCHAR2 80 Token name for the error message
TOKEN4_VALUE VARCHAR2 80 Token value for the error message
TOKEN5_NAME VARCHAR2 80 Token name for the error message
TOKEN5_VALUE VARCHAR2 80 Token value for the error message
INTERFACE_TABLE_NAME VARCHAR2 30 Associated interface table.
ERROR_MSG_TEXT VARCHAR2 4000 This contains stack trace or error message text of the error that occurred while processing the interface record.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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.
ERROR_TYPE_CODE VARCHAR2 30 Column value distinguishes error versus warning.
FILE_NAME_SYSTASK_ID NUMBER 18 Stores systask id for each import csv file.

Foreign Keys

Table Foreign Table Foreign Key Column
HZ_IMP_ERRORS hz_imp_batch_summary BATCH_ID

Indexes

Index Uniqueness Tablespace Columns
HZ_IMP_ERRORS_N1 Non Unique Default BATCH_ID, INTERFACE_TABLE_NAME, ERROR_ID
HZ_IMP_ERRORS_U1 Unique Default ERROR_SEQ_ID