Problem Note 69297: You receive a B18 filing type error message when validating Suspicious Activity Reports (SARX) in SAS® Anti-Money Laundering
 |  |  |  |  |
The error shown below might occur when you validate the SAS Anti-Money Laundering SARX after you change the Type of Filing in the report:
For example, you encounter the issue if you change the Type of Filing from Initial Report to Correct/Amend Prior Report and back to Initial Report in SARX. When the Type of Filing value is changed, the application initializes the underlying vm.report.priorAgencyRefId field to blank (''), which Microsoft SQL Server treats differently from null and causes the validation error.
This issue is encountered only when you use the Microsoft SQL Server database.
The workaround is to override the underlying SQL query. Note the use of NULLIF() function in prior_agency_ref_id:
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#69297| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2022-06-24 08:41:09 |
| Date Created: | 2022-06-13 12:04:51 |