Why Is The Primary ID Not Populated During An EIM Task Even Though The Corresponding EIM Mapping Columns Are Appropriately Populated In The Interface Table

9 February 2025

When encountering  the Primary ID not populated during an EIM task even though the corresponding EIM mapping columns are appropriately populated in the Interface table issue modify the IFB file to include the PRIMARY KEYS ONLY = TRUE parameter. This will force EIM to update only the primary key values like PR_POSTN_ID, PR_EMP_ID etc.

For example: When using the EIM_POSITION Interface Table and updating the S_POSTN.PR_POSTN_ID primary child column. EIM verifies that the primary child table, S_POSTN, is mapped to the interface table, EIM_POSITION. It then use the ONLY BASE TABLES parameter in the IFB file to determine if this table meet the criteria and gets processed.

Example of an ifb section:

[Import POSITION_PERSON]

TYPE = IMPORT

BATCH = 100

TABLE = EIM_POSITION

ONLY BASE TABLES = S_PARTY, S_POSTN, S_PARTY_PER

PRIMARY KEYS ONLY = TRUE

Refer to the 'Siebel Enterprise Integration Manager Administration Guide  >

Chapter 'EIM Configuration File' > Section 'EIM Configuration File Parameters' > Table 'EIM Configuration File Parameters' for more information on this topic.

Tags