EIM, CASCADE DELETE ONLY functionality
(Doc ID 508180.1)
Last updated on OCTOBER 24, 2019
Applies to:Siebel Enterprise Integration Manager - Version 126.96.36.199  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 188.8.131.52 
Database: Oracle 184.108.40.206
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: IBM AIX 4.3.3
This document was previously published as Siebel SR 38-1192570341.
***Checked for relevance on 11-July-2014***
We want to build up an interface that deletes opportunities (s_opty) and all their child records from the following base tables:
s_opty, s_opty_xm, s_opty_bu, s_opty_postn, s_opty_att, s_opty_iss, s_revn, s_evt_act.
No problem for any s_opty* table, the doubt is on the impact property “CASCADE DELETE ONLY = true” will have on child records in s_revn and s_evt_act.
I would expect EIM to delete parent record and all child records in s_opty* tables. I would expect opty_id to be blanked in S_REVN and S_EVT_ACT.
After some testing it confirmed that records in s_revn and s_evt_act pointing to the opportunity are deleted when and only when CASCADE DELETE ONLY = TRUE?
This is also the desired behavior in our application.
Can you confirm that my statement is correct? We are planning to build complex interfaces and this would have a big impact on the design.
Process Section of the ifb file:
TYPE = delete
BATCH = 100000
TABLE = EIM_OPTY
DELETE EXACT = TRUE
ONLY BASE TABLES = S_OPTY
CASCADE DELETE ONLY = TRUE
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