EIM setting of primaries (Doc ID 542613.1)

Last updated on MARCH 21, 2016

Applies to:

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


Symptoms

Hi,

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 explict primary.

Thank You.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms