UCM 'EnableExactMatch' Not Working With Null Or Empty 'ExactMatch' Field Values.
(Doc ID 1954990.1)
Last updated on NOVEMBER 22, 2019
Applies to:
Siebel CRM - Version 8.1.1.10 [23021] and laterInformation in this document applies to any platform.
Symptoms
When processing UCM SDH records with 'ExactMatch' enabled, the UCM Batch Process Workflow should be using the value of the Exact Match field for each record in the job. However, if you have record(s) within the batch that have either an empty or null value in the Exact Match field, the value from the previous record is being used when searching. This leads to totally unrelated records going to Exact Match.
For example, 3 records,
1)
First Name: <FIRSTNAME1>
Last Name: <LASTNAME1>
Exact Match field : Support Engineer
2)
First Name: <FIRSTNAME2>
Last Name: <LASTNAME1>
Exact Match field : Support Engineer
3)
First Name: <FIRSTNAME3>
Last Name: <LASTNAME3>
Exact Match field :
If the records are processed in the order 1,2,3, the first goes to 'Source-Insert' (Correct), the second goes to 'Source-Upsert' (Correct), the third one either goes to 'Source-Upsert' due to 'Support Engineer' value incorrectly being used for the Exact Match query in the 'CDM Match' step, or the job fails with a 'SBL-SRB-00061' error and SDH record is not properly processed.
Cause
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
Symptoms |
Cause |
Solution |
References |