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

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