EIM Issue: Unable to update "Primary Address" flag (Doc ID 492060.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 7.8.2 SIA [19213] to 8.1.1.9 [23016] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.8.2 [19213] Life Sci
Database: Oracle 10g
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: IBM AIX 5100-03

This document was previously published as Siebel SR 38-3076161241.
***Check on currency on 14-Sept-2016***


Symptoms

Issue: Unable to update "Primary Address" flag.

As we were advised, we currently use EIM_ACCNT_CUT to insert and update accounts and EIM_ADDR_PER to insert and update addresses.

Inserting new records works fine, the problem is when we try to update the existing records.

Example:

Insert: If we have 2 address records(A and B) and one of them is the primary address and we insert a new record (C) and we want C to be the primary address it works fine.

Update: If we have 2 address records (A and B) and A is the primary address and we want to make B the primary address, it does not work. We get an error message stating that duplicate records exists.

We raised the error levels and attached are a log file and the IFB file.

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