Skip duplicate reverse exceptions
This is a database configuration and is applicable for Process Insights and Configuration Insights.
When an analysis is performed using a duplicate rule, reverse combinations of exceptions are displayed on the Exceptions Browser page and in reports as shown in this example:
Vendor Master
| Vendor ID | Vendor Name | |
|---|---|---|
| 1 | 4250 | ABC Corporation |
| 2 | 100173 | ABC Corporation |
Here, an analysis is performed using the rule Duplicate Vendor – Exact Match and the same combination of exception 4250 and 100173 is repeated twice.
- 4250 matches with 100173.
- 100173 matches with 4250.
To avoid such repetition of exception writing, you must turn the
skipReverseDuplicatePairs flag of the
BizRightsSettings Table ON. For this execute this query on the IRC
database:
UPDATE BizRightsSettings SET SettingValue = '1' WHERE SettingName = 'SkipReverseDuplicatePairs'Note: The default value for the flag is 0, which means the
skipReverseDuplicatePairs flag is turned OFF.