Clicking "Test scenario" for the New Customer scenario (TM Daily Registration flow) can result in unexpected results if Oracle is the database


In SAS® Anti-Money Laundering, you can encounter unexpected results in the following scenario:

  1. Open the TM Daily Registration flow.
  2. Select the New Customer scenario.
  3. Click Test scenario.

The results are likely to be incorrect if the database is Oracle. 

For example, you might encounter this issue when you complete steps similar to the following:

  1. Select the New Customer scenario, as shown in the following image:

  1. Click the Test scenario  () icon:

If Oracle is the supporting database for your transactions, then the messages in the Records ► Selected rule grid would be incorrect. As a result, a message similar to the following occurs:

Customer transaction within -1956591408 days of opening.

Workaround

On the Rules tab of the New Customer scenario, the OOTB rule is as follows: 

In the above image, cust_since is a DATE data type. Oracle stores the DATE data type as a date and time, which skews the calculation. 

To circumvent this issue, update the calculation by adding DATEPART to cust_since, as shown in the following example: 

After you save the scenario and retest, the test result message in the Records ► Selected rule grid should be as expected.

For example, a message similar to the following should occur:

Customer transaction within 2 days of opening.