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

MCT_IMP_DEV_PAR_VAL

Bulk import interface/staging table for MCT_CFG_DEV_PAR_VAL.

Details

  • Schema: FUSION

  • Object owner: MCT

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

MCT_IMP_DEV_PAR_VAL_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
DEV_PAR_VAL_GUID VARCHAR2 64 DEV_PAR_VAL_GUID
DEV_GUID VARCHAR2 64 DEV_GUID
DEV_TYP_PAR_GUID VARCHAR2 64 DEV_TYP_PAR_GUID
DEV_PAR_VAL VARCHAR2 512 DEV_PAR_VAL
PAR_NAME VARCHAR2 64 PAR_NAME
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_DEV_PAR_VAL_PK Unique FUSION_TS_INTERFACE BATCH_ID, INTERFACE_ROW_ID