Problem Note 69275: The Customer Risk Ranking Scoring History data grid contains scores and reviews that do not belong to the customer in SAS® Anti-Money Laundering
 |  |  |  |  |
The Overall Scores and Reviews information displayed in Customer Risk Ranking Scoring History in SAS Anti-Money Laundering contains reviews and scores that are unrelated to and inconsistent with the risk value specified in Customer Summary section on the Customer Details page.
The underlying middle-tier query, sasaml.cdd.overallscoresandreview.sql, that populates the Customer Risk Ranking Scoring History has an incorrect WHERE clause, which causes unrelated reviews to be associated with the customer.
A workaround is to replace the WHERE condition that is used in sasaml.cdd.overallscoresandreview.sql by adding parentheses to the OR operator statement.
Here is the original:
r.INITIAL_SCORING_EVENT_KEY IS NULL
OR r.INITIAL_SCORING_EVENT_KEY = 0
AND r.primary_entity_level_code = ?
AND r.primary_entity_number = ?) RES
Here is the correction:
(r.INITIAL_SCORING_EVENT_KEY IS NULL
OR r.INITIAL_SCORING_EVENT_KEY = 0 )
AND r.primary_entity_level_code = ?
AND r.primary_entity_number = ?) RES
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Microsoft® Windows® for x64 | 7.1 | |||
| 64-bit Enabled AIX | 7.1 | |||||
| 64-bit Enabled Solaris | 7.1 | |||||
| Linux for x64 | 7.1 | |||||