1. Tables and Views for Financials
  2. ZX_IMPORT_ERRORS

ZX_IMPORT_ERRORS

This table stores processing or validation errors. This would help the user to review the errors and take corrective action on imported transactions.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

ZX_IMPORT_ERRORS_PK

IMPORT_ERROR_ID

Columns

Name Datatype Length Precision Not-null Comments Status
IMPORT_ERROR_ID NUMBER 18 Yes Unique Import Error Identifier Active
APPLICATION_ID NUMBER 18 Yes Appliction Identifier Active
ENTITY_CODE VARCHAR2 30 Yes Entity code of the application event class for the transaction Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the transaction Active
TRX_ID NUMBER 18 Yes Primary transaction identifier Active
SUMMARY_TAX_LINE_NUMBER NUMBER Summary tax line identifier Active
TRX_LEVEL_TYPE VARCHAR2 30 Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT Active
TRX_LINE_ID NUMBER 18 Transaction line identifier Active
MESSAGE_NAME VARCHAR2 100 Yes Standard message name for the validation error Active
INT_TAX_LINE_ID NUMBER 18 Column to temporarily store identifier of the interface line corresponding to this tax line Active
INT_REC_NREC_TAX_DIST_ID NUMBER 18 Tax distribution record identfier Active
INT_REC_NREC_TAX_DIST_NUMBER NUMBER 18 Tax distribution record number Active
OTHER_DOC_APPLICATION_ID NUMBER 18 Application identifier for other documents like adjusted document if this error is specific to the other document Active
OTHER_DOC_ENTITY_CODE VARCHAR2 30 Entity code for other documents like adjusted document if this error is specific to the other document Active
OTHER_DOC_EVENT_CLASS_CODE VARCHAR2 30 Event class code for other documents like adjusted document if this error is specific to the other document Active
OTHER_DOC_TRX_ID NUMBER 18 Transaction identifier for other documents like adjusted document if this error is specific to the other document Active
TRX_LINE_DIST_ID NUMBER 18 Item distribution identifier Active
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
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. Active

Indexes

Index Uniqueness Tablespace Columns Status
ZX_IMPORT_ERRORS_N1 Non Unique FUSION_TS_TX_IDX APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, SUMMARY_TAX_LINE_NUMBER Active
ZX_IMPORT_ERRORS_U1 Unique FUSION_TS_TX_IDX IMPORT_ERROR_ID Active