The SAS Anti-Money Laundering Installation, Configuration, and Administration Guide tells you to run SQL scripts that create Oracle text indexes. If you choose not to create the Oracle text indexes, you might experience slow performance when you search for objects.

Oracle text indexes are required to run the installation Data Definition Language (DDL) programs without modification.

If you do not want to create the Oracle text indexes, you can modify some SQL queries in the sasaml.oracle file to improve search performance. The sasaml.oracle file exists inside the sas.financialservices.aml.jar file. Modify these query statements:

sasaml.createAlert.account.getNames=select distinct account_name 
  from fsc_account_dim 
  where contains(account_name, ?) >0 and change_current_ind = 'Y'   
  order by account_name

sasaml.createAlert.party.getNames=select distinct party_name 
  from fsc_party_dim 
  where contains(party_name, ?) >0 and change_current_ind = 'Y' 
  order by party_name

sasaml.createAlert.household.getNames=select distinct head_of_household_name 
  from fsc_household_dim 
  where contains(head_of_household_name, ?) >0 and change_current_ind = 'Y' 
  order by head_of_household_name

Change the query statements to look like this:

sasaml.createAlert.account.getNames=select distinct account_name 
  from fsc_account_dim 
  where account_name LIKE ? and change_current_ind = 'Y' 
  order by account_name

sasaml.createAlert.party.getNames=select distinct party_name 
  from fsc_party_dim 
  where party_name LIKE ? and change_current_ind = 'Y' 
  order by party_name

sasaml.createAlert.household.getNames=select distinct head_of_household_name 
  from fsc_household_dim 
  where head_of_household_name LIKE ? and change_current_ind = 'Y' 
  order by head_of_household_name

After changing the query statements in the sasaml.oracle file, the SAS Anti-Money Laundering web application must be redeployed and restarted on your web application server.

There are disadvantages to modifying the query statements.

• Performance might still be unsatisfactory because a new query is started for each character entered in the search box.
• When you install any future fix or maintenance that modifies the sas.financialservices.aml.jar file, the sas.financialservices.aml.jar file must be modified again to include the query statement changes.

The best performance and maintainability are obtained when the Oracle text indexes are defined, and the sas.financialservices.aml.jar file is not modified.

Operating System and Release Information