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 | |||||
A fix for this issue for SAS Compliance Solutions 7.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A5T.html#69275| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2022-06-24 08:18:55 |
| Date Created: | 2022-06-07 13:08:34 |