While creating Simulation from OBDX, we need to send IC Group values to OBLM as per the below matrix:

The values of these IC Groups can be different in each environment based on the IC Groups created in the respective OBLM system.

Certain properties have been created in OBDX, from where the values of these IC Groups shall be dynamically picked and sent to OBLM during Simulation creation from OBDX.

Below are the sample scripts to update those property values:-

UPDATE DIGX_FW_CONFIG_ADAPTER_PROP_B SET PROP_VALUE='<SIM_SWEEP_INTEREST_ACCOUNT>'WHERE HOST_ID='OBLM'AND TRANSACTION_TYPE='INTEREST_CALCULATION_GROUP'AND PROP_ID='SIM_SWEEP_INTEREST_ACCOUNT';

UPDATE DIGX_FW_CONFIG_ADAPTER_PROP_B SET PROP_VALUE='<SIM_HYBRID_INTEREST_NOTIONAL>'WHERE HOST_ID='OBLM'AND TRANSACTION_TYPE='INTEREST_CALCULATION_GROUP'AND PROP_ID='SIM_HYBRID_INTEREST_NOTIONAL';

UPDATE DIGX_FW_CONFIG_ADAPTER_PROP_B SET PROP_VALUE='<SIM_POOL_INTEREST_NOTIONAL>'WHERE HOST_ID='OBLM'AND TRANSACTION_TYPE='INTEREST_CALCULATION_GROUP'AND PROP_ID='SIM_POOL_INTEREST_NOTIONAL';

UPDATE DIGX_FW_CONFIG_ADAPTER_PROP_B SET PROP_VALUE='<SIM_POOL_ADVANCE_NOTIONAL>'WHERE HOST_ID='OBLM'AND TRANSACTION_TYPE='INTEREST_CALCULATION_GROUP'AND PROP_ID='SIM_POOL_ADVANCE_NOTIONAL';

UPDATE DIGX_FW_CONFIG_ADAPTER_PROP_B SET PROP_VALUE='<SIM_POOL_ADVANCE_ACCOUNT>'WHERE HOST_ID='OBLM'AND TRANSACTION_TYPE='INTEREST_CALCULATION_GROUP'AND PROP_ID='SIM_POOL_ADVANCE_ACCOUNT';

UPDATE DIGX_FW_CONFIG_ADAPTER_PROP_B SET PROP_VALUE='<SIM_POOL_RATIO_ACCOUNT>'WHERE HOST_ID='OBLM'AND TRANSACTION_TYPE='INTEREST_CALCULATION_GROUP'AND PROP_ID='SIM_POOL_RATIO_ACCOUNT';