My Oracle Support Banner

On deleting parent record child is not getting deleted from Intersection Table (Doc ID 499529.1)

Last updated on FEBRUARY 14, 2022

Applies to:

Siebel Tools - Version SIA [16183] and later
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle
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.



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.




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

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