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

MCT_IMP_CONN

Bulk import interface/staging table for MCT_CFG_CONN_B/TL.

Details

  • Schema: FUSION

  • Object owner: MCT

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

MCT_IMP_CONN_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
CONN_GUID VARCHAR2 64 CONN_GUID
CONN_TYP_GUID VARCHAR2 64 CONN_TYP_GUID
CONN_INPUT_PAR_STR VARCHAR2 512 CONN_INPUT_PAR_STR
USE_TRANSPORT_LIB VARCHAR2 32 USE_TRANSPORT_LIB
CONN_NAME VARCHAR2 64 CONN_NAME
CONN_DESC_TXT VARCHAR2 128 CONN_DESC_TXT
CONN_STATUS VARCHAR2 32 CONN_STATUS
INTERFACE_ROW_ID NUMBER 18 Yes INTERFACE_ROW_ID
BATCH_ID NUMBER 18 Yes BATCH_ID
IMPORT_STATUS_CODE VARCHAR2 1 IMPORT_STATUS_CODE
ACTION_CODE VARCHAR2 30 ACTION_CODE
INTERNAL_ACTION_CODE VARCHAR2 30 INTERNAL_ACTION_CODE
FILE_RECORD_NUM NUMBER 18 FILE_RECORD_NUM
ERROR_MESSAGE VARCHAR2 3000 ERROR_MESSAGE
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP 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.
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.

Indexes

Index Uniqueness Tablespace Columns
MCT_IMP_CONN_PK Unique FUSION_TS_INTERFACE BATCH_ID, INTERFACE_ROW_ID