Problem Note 60244: The alert generation process fails and an error is generated in SAS® Anti-Money Laundering when you execute the %FCF_CE_LOAD_DM_PROCESS macro
 |  |  |  |
In SAS Anti-Money Laundering, when you run the alert generation process and you execute the %FCF_CE_LOAD_DM_PROCESS macro, the process fails with an error similar to the following:
ORA-01438: value larger than specified precision allowed for this column.
This message occurs if you use the Oracle database management system (DBMS) with the SAS Anti-Money Laundering software. If you use another DBMS, you also receive a similar error message.
The error occurs because the length of the AGGREGATE_AMT field is too short. This field is defined in three tables (FBU_CUSTOMER_TX_AGG, FBU_ALERT_TX_AGG, and FBU_CUSTOMER_ALERT). These tables are called, respectively, from these three macros:
- %FCF_CE_LOAD_CUSTOMER_TX_AGG
- %FCF_CE_LOAD_ALERT_TX_AGG
- %FCF_CE_LOAD_CUSTOMER_ALERTS
The solution to this problem is to increase the length for AGGREGATE_AMT from NUMBER(10,2) to NUMBER(18,5) in the database.
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 Server 2012 R2 Datacenter | 6.3_M1 | 7.1 | 9.4 TS1M3 | 9.4 TS1M3 |
| Microsoft Windows Server 2012 Std | 6.3_M1 | 7.1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Std | 6.3_M1 | 7.1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 | 6.3_M1 | 7.1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 R2 | 6.3_M1 | 7.1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 for x64 | 6.3_M1 | 7.1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Datacenter | 6.3_M1 | 7.1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 6.3_M1 | 7.1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 6.3_M1 | 7.1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Linux for x64 | 6.3_M1 | 7.1 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2017-04-06 10:41:46 |
| Date Created: | 2017-04-04 05:48:41 |