EIM setting of primaries
Last updated on DECEMBER 27, 2017
Applies to:Siebel Enterprise Integration Manager - Version 188.8.131.52 SIA  to 184.108.40.206  [Release V7 to V8]
IBM AIX on POWER Systems (32-bit)
Product Release: V7 (Enterprise)
Version: 220.127.116.11  Com/Med
Database: Oracle 18.104.22.168
Application Server OS: IBM AIX 4.2
Database Server OS: IBM AIX 4.2
This document was previously published as Siebel SR 38-1854657481.
***Check for relevance on 10-oct-2014***
We used the Siebel EIM Table Mapping Wizard to create an explicit primary setting.
The EIM table is EIM_CONTACT_XM. The Explicit Primary Mapping that was tested and failed was to set a Primary Identification Profile (driven off the CONTACT_XM table). So under the explicit primary mapping for S_CONTACT_XM, the Inf Tbl Exp Primary Flag Col Name is CON_X_PR_IDFCN. the Base Table Primary ID Column Name is X_PR_IDFCN_ID. (Name heading) table/column is S_CONTACT.X_PR_IDFCN_ID. When EIM was used to import into this table, the primary ID field had "No Match Row Id" in every value. Please advise how to correctly set this explicit primary.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms