5.11.3 Configurations to Automatically Release Transactions

To configure a transaction for the Auto Release status, run the following query:

select * from fsi_rt_auto_release;

By default, the configuration is empty, which means that no transactions can be auto released. You can set the following values in the fsi_rt_auto_release table:

• Message category in the V_MSG_CATEGORY column. For example, a message category of 1 is mapped to the SWIFT message type by default. To see all default values, run the following query:

select * from dim_message_category;

• Message type in the N_SWIFT_MSG_ID column. For example, a message type of 1 is mapped to the MT101 message type by default. To see all default values, run the following query:

select * from dim_sanctions_swift;

• Jurisdiction in the V_JURISDICTION column.
• Business Domain in the V_BUSINESS_DOMAIN column.
• To see the default values for jurisdiction and business domain, run the following query:

select v_attribute_value1 from setup_rt_params where V_PARAM_NAME in ('MESSAGE_JURISDICTION','MESSAGE_BUSINESS_DOMAIN')

• To enable the configuration, set the F_ENABLED column to Y.