On deleting parent record child is not getting deleted from Intersection Table

(Doc ID 499529.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.5.3.5 SIA [16183] and later
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 9.2.0.4
Application Server OS: Microsoft Windows 2000 Advanced Server SP 3
Database Server OS: Microsoft Windows 2000 Advanced Server SP 2

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

""Checked For Relevance on 30-JUL-2013""
""CHECKED FOR RELEVANCE ON 04-DEC-2015""

Symptoms

When we create a New Account, before saving the record we undo it or Cancel it. The record doesn't gets inserted in S_ORG_EXT Table, but the child records exists in Intersection Tables (S_ORG_TERR & S_ACCNT_POSTN Tables).

The example can be -
The record exists in S_ORG_TERR (OU_ID Column) and S_ACCNT_POSTN (OU_EXT_ID Column) Tables, where as the record doesn't exist in the parent Table S_ORG_EXT (ROW_ID Column).

We tried solving this problem by setting the Cascade Delete Property of the Link to Delete / Clear, but it throws following error -

"We detected an Error which may have occurred for one or more of the following reasons:

Link 'Account/Assignment Group', referred to in multi valued link definition 'Territory', business component definition 'Account', does not exist.(SBL-DAT-00456)"

We checked for the above mentioned error but the Multi Valued Link "Territory" in Account BC exists with the Destination Link for "Account / Territory".

This Problem persists for generally all Intersection tables.

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