Complete the following steps to find SAS Fraud Management rules that fired on a transaction.

1. Execute the SQL query in the SAS Fraud Management TDR database by the sastdrapp user.
   
   select r.* from TDRCORE.FCM_<transaction_acronym> t, table(TDRCORE.get_rule_slots(t.rrf_rule_data)) r where cmx_tran_id=<the txn id shared in the screenshot>;
   
   The SAS Fraud Management web application uses sastdrapp to access the transaction data repository credentials.
   
   Here is an example that shows the output of the SQL query above.
   
   
   
2. Execute the SQL query in the SOR database by the sassorapp user. 
   
   select * from fcm_rule where FCMCORE.rule_id in
            (select rule_id from FCMCORE.fcm_rule_slot where slot_id in ( <first SLOT_ID from the TDR query>, <second SLOT_ID from the TDR query>, ..., <nth SLOT_ID from the TDR query> ));
   
   The SAS Fraud Management web application uses sassorapp to access the system of record database credentials.
   
   Here is an example that shows the rules using the SLOT_IDs from the example screenshot in step one.
   

Note: The above method works only with IBM DB2 and Oracle databases.