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

HZ_IMP_ENTITY_DETAILS

The HZ_IMP_ENTITY_DETAILS table stores detailed information about the entities in the interface tables to import. The table includes number of records for each entity, the definition and results from enrichment functions during import.

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

HZ_IMP_ENTITY_DETAILS_PK

ENTITY_DETAIL_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTITY_DETAIL_ID NUMBER 18 Yes Unique identifier of the row
NUM_WARNED NUMBER Number of records warned
ENTITY_CODE VARCHAR2 30 Yes Entity lookup code
BATCH_ID NUMBER 18 Yes Identifier of a batch
NUM_RECORDS NUMBER Number of records in an entity counted by import
SELECTION_FLAG VARCHAR2 1 Indicate if the entity is selected in import definition
BD_DUP_COUNT NUMBER Number of duplicate entity records identified by batch deduplication
BD_DUP_ACTION VARCHAR2 30 Action to take by duplicate identification within the batch. Validated against lookup HZ_IMP_BATCH_DEDUP_ACTIONS
RD_DUP_COUNT NUMBER Number of duplicate records identified by registry deduplication.
RD_DUP_SET_COUNT NUMBER Number of duplicate record sets identified by registry deduplication.
RD_DUP_ACTION VARCHAR2 30 Action to take by duplicate identification between the interface tables and the TCA Registry for duplicate entities that cross the automatic merge threshold. Validated against lookup HZ_IMP_REGISTRY_DEDUP_ACTIONS
RD_POS_DUP_COUNT NUMBER Number of possible duplicates for an entity identified by registry deduplication
RD_POS_DUP_ACTION VARCHAR2 30 Action to take by duplicate identification between the interface tables and the TCA Registry for duplicate entities that did not cross the automatic merge threshold. Validated against lookup HZ_IMP_REGISTRY_DEDUP_ACTIONS
NUM_INSERTED NUMBER Number of records inserted
NUM_UPDATED NUMBER Number of records updated
NUM_MERGE_REQUESTED NUMBER Number of records with merge requested
NUM_AUTO_MERGED NUMBER Number of records automatically merged
NUM_REMOVED NUMBER Number of records removed
NUM_IMPORTED NUMBER Number of records imported
NUM_ADDR_CLEANSED NUMBER Number of records cleansed by address validation
NUM_ERRORS NUMBER Number of records with error
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.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes 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.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
HZ_IMP_ENTITY_DETAILS hz_imp_batch_summary BATCH_ID

Indexes

Index Uniqueness Tablespace Columns
HZ_IMP_ENTITY_DETAILS_PK Unique Default ENTITY_DETAIL_ID
HZ_IMP_ENTITY_DETAILS_U1 Unique Default BATCH_ID, ENTITY_CODE