Problem Note 20073: FINTRAC SAR queries should include data from FSK_ACCOUNT_TRADE_ALERT table
 |  |  |  |  |
To comply with FINTRAC requirements, the FINTRAC Extension Component must be able to include trade transactions. In SAS® Anti-Money Laundering 1.2, because the replication of trades to the Knowledge Center was not supported, the ETL process was modified to copy the trade transactions from FSC_ACCOUNT_TRADE_FACT to FSC_ACCOUNT_CREDIT_FACT and FSC_ACCOUNT_DEBIT_FACT in order to replicate these transactions to the Knowledge Center. In SAS Anti-Money Laundering 2.1, trade replication is supported but the LSTR user interface SQL queries still were only using the FSK_CASH_FLOW_ALERT table.
The LSTR queries in the SASAML.DB2 and SASAML.ORACLE file needed to be modified to include data from the FSK_ACCOUNT_TRADE_ALERT table to include trade transactions:
sasaml.lstr.get.AVAILABLE_TRANSACTIONS_DEBITS
sasaml.lstr.add.SUSPICIOUS_TRANSACTION
Select 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 Alert Generation Server | Microsoft Windows NT Workstation | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP Professional | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Server | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Professional | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Advanced Server | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Datacenter Server | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Linux | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled Solaris | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Solaris | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled AIX | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| AIX | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
A fix for this issue for SAS Anti-Money Laundering 2.1 is available at:
http://www.sas.com/techsup/download/hotfix/aml21.html#020073| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2007-11-28 13:00:55 |
| Date Created: | 2007-04-27 16:48:32 |