My Oracle Support Banner

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

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
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.