Siebel Business Process & Functionality (MOSC)

MOSC Banner

Check No Match FALSE on Mvl when auto primary is default

edited Jul 9, 2013 5:03AM in Siebel Business Process & Functionality (MOSC) 13 commentsAnswered
 Hi,
As per oracle documentation, if the check no match property is set to FALSE then 

1. If there is a NULL or invalid value in the foreign key field siebel performs a secondary query and if it founds no matching records set the foreign key as 'nomatchrowid'

Now i have following questions.

1.What does an incalid value inforeign key column mean? How does siebel know in advance if value is invalid?
2. What does 'matching record' mean here
3. Finally what if the auto primary is set to default and siebel performs a secondary query, in that case will it update the foreign key as the default record if the alredy key value is NULL or INVALUD

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center