My Oracle Support Banner

Multiple Rows in EIM Table (Doc ID 481447.1)

Last updated on NOVEMBER 08, 2019

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.3.4 SIA [16180] and later
z*OBSOLETE: Microsoft Windows 2000
Version: 7.5.3.4 [16180] Cons Sec

Database: Oracle 9i

Application Server OS: Microsoft Windows 2000 Advanced Server

Database Server OS: Microsoft Windows 2000 Advanced Server



This document was previously published as Siebel SR 38-2896617711.

Symptoms

Dear support,
in the Siebel Enterprise Integration Manager Administration Guide, page 70, point 9, it says:
"If multiple interface table rows use the same user primary key for a base
table, EIM uses only the first interface table row to update the base table, and
ignores the data in other rows."

Is there a way to change this Vanilla behaviour?
We are getting rows in the eim tables in near-real time from SAP and when we process the ifb, we could have multiple rows with the same user keys but we would like to have the last inserted processed instead of the first one and ignored the other rows.
Is it feasible?
Please provide any suggestion.
Thanks

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Message 1
 Message 2

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