This topic provides information on verify system configurations.

Following script helps in listing the Corporateloan 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
        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 = '{{determinant_value}}' where dccab.sequence != '-1' and
        dccab.module = 'corporateloan';