EIM, CASCADE DELETE ONLY functionality (Doc ID 508180.1)

Last updated on APRIL 06, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.3.2 [16168] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.2 [16168]
Database: Oracle 8.1.7.4
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***

Symptoms


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:

    [Delete Opty]
    TYPE = delete
    BATCH = 100000
    TABLE = EIM_OPTY
    DELETE EXACT = TRUE
    ONLY BASE TABLES = S_OPTY
    CASCADE DELETE ONLY = TRUE


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