SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 48631: Erroneous messages appear in the SAS® Anti-Money Laundering Related Entities window when the FSC_PARTY_DIM table has missing address information

DetailsHotfixAboutRate It

Missing or blank values in the address columns of the FSC_PARTY_DIM table might cause erroneous messages, such as the following, in the Related Entities window:

"0 of 454 total rows displayed" "No matchs for this value"

You might also see partial or missing address information under the Mailing Address and Street Address sections.

This problem has been linked to the SQL queries that perform the matching of the address match codes. The queries do not ignore blank address match codes.

The queries have been rewritten to address this problem.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Anti-Money LaunderingMicrosoft® Windows® for x644.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition4.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition4.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 Standard Edition4.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 2003 for x644.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 20084.25.19.2 TS2M39.3 TS1M0
Microsoft Windows Server 2008 for x644.25.19.2 TS2M39.3 TS1M0
Microsoft Windows XP Professional4.25.19.2 TS2M39.3 TS1M0
Windows 7 Enterprise 32 bit4.25.19.2 TS2M39.3 TS1M0
Windows 7 Enterprise x644.25.19.2 TS2M39.3 TS1M0
Windows 7 Home Premium 32 bit4.25.19.2 TS2M39.3 TS1M0
Windows 7 Home Premium x644.25.19.2 TS2M39.3 TS1M0
Windows 7 Professional 32 bit4.25.19.2 TS2M39.3 TS1M0
Windows 7 Professional x644.25.19.2 TS2M39.3 TS1M0
Windows 7 Ultimate 32 bit4.25.19.2 TS2M39.3 TS1M0
Windows 7 Ultimate x644.25.19.2 TS2M39.3 TS1M0
Windows Vista4.25.19.2 TS2M39.3 TS1M0
Windows Vista for x644.25.19.2 TS2M39.3 TS1M0
64-bit Enabled AIX4.25.19.2 TS2M39.3 TS1M0
64-bit Enabled HP-UX4.25.19.2 TS2M39.3 TS1M0
64-bit Enabled Solaris4.25.19.2 TS2M39.3 TS1M0
HP-UX IPF4.25.19.2 TS2M39.3 TS1M0
Linux4.25.19.2 TS2M39.3 TS1M0
Linux for x644.25.19.2 TS2M39.3 TS1M0
Solaris for x644.25.19.2 TS2M39.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.