My Oracle Support Banner

How Does the CheckNoMatch Property of a Multi-Value Link Affect How and When Foreign Key Values are Changed? (Doc ID 475731.1)

Last updated on JUNE 07, 2018

Applies to:

Siebel Tools - Version 7.5.2 [16007] to 8.1.1 [21112] [Release V7 to V8]
Information in this document applies to any platform.
Area(s):Configuration - General
Release(s):V7 (Enterprise), V6 (Siebel 2000-Enterprise), V5 (Siebel 99-Enterprise), Version 4
Database(s):All Supported Databases
App Server OS(s):All Supported Platforms
Latest release tested against:V7 (Enterprise)
Keywords:MVL, Foreign Key, CheckNoMatch, No Match Row Id, Check No Match

This document was previously published as Siebel FAQ 1232.

""Checked for relevance on 25-Nov-2013""
""Checked for relevance on 30-Jun-2015""

Goal

How Does the Check No Match Property of a Multi-Value Link Affect How and When Foreign Key Values are Changed?

Solution

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
Goal
Solution
 What occurs when the Check No Match property on a multi-value link is set to TRUE?
 What occurs when the Check No Match property on a multi-value link is set to FALSE?
 What if a user has Check No Match = TRUE and the Auto Primary = Default? If the Siebel application encounters a 'No Match Row Id', will it try to update the Primary Foreign Key?
 What if Check No Match = TRUE and the Auto Primary = None? If the Siebel application encounters a 'No Match Row Id', will it try to update the Primary Foreign Key?
 In the case of the above (Check No Match = TRUE and Auto Primary = None), how is the user able to set a Primary for the multi-value group?
 Will the Siebel application ever set any other type foreign key to NULL or No Match Row Id? For example, if remote users are given an 'All' type of view, will unknown foreign key references on their mobile database set foreign keys to NULL on the Server when they synchronize at a later time?
 If the above is TRUE, why should mobile users not be given access to 'All' type of views?
 Does "No Match Row Id" affect EIM?
 For more information, please refer to the following Siebel Bookshelf references: 

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