My Oracle Support Banner

EIM setting of primaries (Doc ID 542613.1)

Last updated on JULY 21, 2020

Applies to:

Siebel Enterprise Integration Manager - Version SIA [16183] to [23016] [Release V7 to V8]
IBM AIX on POWER Systems (32-bit)
Product Release: V7 (Enterprise)
Version: [16183] Com/Med
Database: Oracle
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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.