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

ZCA_IMPEXP_EXTN_GEN_DTLS

It is to store the import export extensibility generation status of the each objects.

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ZCA_IMPEXP_EXTN_GEN_DTLS_PK

IMPEXP_EXTN_GEN_DTLS_ID

Columns

Name Datatype Length Precision Not-null Comments
IMPEXP_EXTN_GEN_DTLS_ID NUMBER 18 Yes Primary Key
IMPEXP_EXTN_GEN_ID NUMBER 18 Yes Foreign Key
OBJECT_NAME VARCHAR2 255 Object Name
OBJECT_TYPE VARCHAR2 255 Object Type
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of 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.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.
IMPORT_ODI_STATUS VARCHAR2 128 Import ODI Status
IMPORT_ADF_STATUS VARCHAR2 128 Import ADF Status
IMPORT_STATUS VARCHAR2 128 Import Status
EXPORT_STATUS VARCHAR2 128 Export Status
AUTOMAP_STATUS VARCHAR2 128 The column provides the status of auto mapping for the corresponding Extensible object.
OVERALL_STATUS VARCHAR2 128 Overall Status
IMPORT_ODI_START_TIME TIMESTAMP Import ODI Start Time
IMPORT_ODI_END_TIME TIMESTAMP Import ODI End Time
IMPORT_ADF_START_TIME TIMESTAMP Import ADF Start Time
IMPORT_ADF_END_TIME TIMESTAMP Import ADF End Time
EXPORT_START_TIME TIMESTAMP Export Start Time
EXPORT_END_TIME TIMESTAMP Export End Time
OVERALL_START_TIME TIMESTAMP Overall Start Time
OVERALL_END_TIME TIMESTAMP Overall End Time
ERROR_MESSAGE VARCHAR2 2048 Error Message
MDS_LAST_UPDATE_TIME TIMESTAMP MDS Last Update Time
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
IMPORT_MANAGEMENT_STATUS VARCHAR2 128 Holds the staus of individual object registration during the process of Standard Object Registration, e.g. Success, Error, Not Supported.
OBJECT_VO VARCHAR2 600 Holds the Rest VO of the object, registered in Standard Object Registration. This is value is referring to the value of OBJECT_VO column of ZCA_OBJECTS table. If the object doesn't have a REST VO then, the value will be null.
LANG_INDEPENDENT_CODE VARCHAR2 128 This value is used to uniquely identify object. This is same as the LANG_INDEPENDENT_CODE of ZCA_OBJECTS table.

Foreign Keys

Table Foreign Table Foreign Key Column
ZCA_IMPEXP_EXTN_GEN_DTLS zca_impexp_extn_gen IMPEXP_EXTN_GEN_ID

Indexes

Index Uniqueness Tablespace Columns
ZCA_IMPEXP_EXTN_GEN_DTLS_U1 Unique Default IMPEXP_EXTN_GEN_DTLS_ID