On deleting parent record child is not getting deleted from Intersection Table
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 220.127.116.11 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 18.104.22.168
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""
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms