My Oracle Support Banner

EIM delete leaving dangling foreign keys (Doc ID 533665.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Siebel Enterprise Integration Manager - Version 7.7.2 SIA [18325] and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.7.2 [18325] Com/Med
Database: Oracle
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 9

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


During technical (performance) testing of EIM delete exact interfaces, I have found some alarming discrepancies. Basically, EIM is not processing some dependant tables properly.

We run all our EIM Delete and Merge jobs with NUM_IFTABLE_LOAD_CUTOFF=0 and so EIM should process ALL dependent tables. In fact, it would appear as though I can successfully reproduce the list of tables that EIM is processing. I have so far detected this issue in EIM_ADDR_PER, EIM_ASSET and EIM_ACCOUNT and am rather concerned.

I will use EIM_ADDR_PER for example in this SR.




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
 Message 1
 Message 2
 Message 3

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