9.2 Verify System Configurations
This topic provides information on Verify System Configurations.
Following script helps in listing the LM specific System Configurations:-
SELECT dfrbcn.resource_value as "Property Name on System
Configuration Screen", dfrbcd.resource_value as "Property Description on System
Configuration Screen",
substr(substr(dccab.prop_id,INSTR(dccab.prop_id,'.')+1),INSTR(substr(dccab.prop_id,INSTR(dccab.prop_id,'.')+1),'.')+1)
as "Property ID in the Database", dccab.prop_value as "Property Value in the
Database", dccao.prop_value as "Overidden Property Value in the Database" from
DIGX_CFG_CONFIG_ALL_B dccab left join DIGX_FW_RESOURCE_BUNDLE dfrbcn on
dccab.prop_id = dfrbcn.resource_name and dfrbcn.bundle_name = 'ConfigName' left
join DIGX_FW_RESOURCE_BUNDLE dfrbcd on dccab.prop_id = dfrbcd.resource_name and
dfrbcd.bundle_name = 'ConfigDiscription' left join DIGX_CFG_CONFIG_ALL_O dccao
on dccab.prop_id = dccao.prop_id and dccao.determinant_value =
'{{determinant_value}}' --Please enter correct determinant value where
dccab.sequence != '-1' and dccab.module = ‘liquiditymanagement';
Ensure correct values are maintained against the above properties.
This maintenance can be done from the “System Configuration” admin screen or directly in DB schema.
Parent topic: Liquidity Management