7.2 Verify System Configurations
This topic provides information on verify system configurations.
The following script helps in listing the CM specific System Configurations:
SELECT dfrbcn.resource_value as "Property Name on System Configuration Screen",
dfrbcd.resource_value as "Property Description on System Configuration Screen",
dccab.module,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 obdx_trunk_25ga.DIGX_CFG_CONFIG_ALL_B dccab left join
obdx_trunk_25ga.DIGX_FW_RESOURCE_BUNDLE dfrbcn on dccab.prop_id =
dfrbcn.resource_name and dfrbcn.bundle_name = 'ConfigName' left join
obdx_trunk_25ga.DIGX_FW_RESOURCE_BUNDLE dfrbcd on dccab.prop_id =
dfrbcd.resource_name and dfrbcd.bundle_name = 'ConfigDiscription' left join
obdx_trunk_25ga.DIGX_CFG_CONFIG_ALL_O dccao on dccab.prop_id =
dccao.prop_id and dccao.determinant_value = 'OBDX_BU' where dccab.sequence is null and dccab.module = 'cms';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: Cash Management System