The Batch Alert Generation job 3004 fails when the alert type A is deleted in SAS® Fraud Management 6.1


In SAS Fraud Management 6.1, there are 12 valid alert types represented by these letters: A, B, C, D, H, M, O, P, R, T, W, X. By default, the following three values are loaded into the System of Record (SOR) database at installation time:

In addition to customizing the alert types at installation, you can also add alert types later by running the database table loader. If an existing alert type is not needed, you can logically delete it from the FCM_ALERT table in the SOR database by setting the LOGICAL_DEL_IND column value for the alert type to 1.

However, if you delete the alert type A by setting the LOGICAL_DEL_IND column value to 1, then the Batch Alert Generation job 3004 fails.   

The batch job log then reports the following errors:

ERROR: INSERT statement does not permit correlation with the table being inserted into.

ERROR: The reference to ACCOUNT appears to refer to a variable in the table being inserted into.

Workaround

To circumvent this issue, restore the deleted alert type A by running the following SQL statement, which sets the LOGICAL_DEL_IND column value back to 0:  

update fcm_alert_type set LOGICAL_DEL_IND=0 where alert_type='A';