Import household and associate household with members using table EIM_GROUP (Doc ID 537760.1)

Last updated on JUNE 01, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 7.8.2.4 [19224] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.8.2.4 [19224]
Database: Oracle 9.2.0.8
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Sun Solaris 9

This document was previously published as Siebel SR 38-3371799611.
***Checked for relevance on 11-Jul-2014***

Symptoms

Hi,

I am loading Household information into the S_ORG_GROUP base table using EIM_GROUP.

When i run the EIM job for the first time the records gets inserted into the siebel base tables and it shows IF_ROW_STAT = 'IMPORTED" in EIM table. If I execute the EIM job for the second time then its updating the existing records instead of creating new records except the 'NAME' column in the S_ORG_GROUP siebel base table which is mapped to the Household Number at GUI level.

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