Configuring Siebel eBusiness Applications > Configuring Links >

About the Cascade Delete Property

The Cascade Delete property determines whether a child record is deleted when the parent record is deleted. Take special precautions when determining this property. If set incorrectly, it may cause data integrity issues or orphaned records.

The Cascade Delete property can be set to the following values:

• Delete. The detail records are deleted along with the master. This is most appropriate for values stored on _XM tables where the only related record is the parent record.

  Do not use DELETE if the child business component in this link is also a detail business component in another link. In this case, use CLEAR instead.

• Clear. The foreign key reference is removed if the master record is deleted, but the detail records remain in place. However, the value in the foreign key column is cleared. This is most appropriate for child values that might be shared with other parent records.
• None. No records are deleted and the foreign key column is not cleared. This is the default setting.

Cascade Delete is not available for many-to-many links. With a many-to-many link, Siebel applications will automatically delete the intersection record but will leave the child record intact, as it may have other parents.

When you delete a record which is pointed to by foreign keys of other tables, the references to it may or may not be deleted. If those references are not deleted, the user is left with row IDs which point to nonexistent records. In the case of multi-value groups, sometimes these foreign keys will be converted to say "No Match Row Id."