Savings is an interface provider for processing teller transactions. Business logic is partially built in branch and hence, some of the crucial maintenances have to be replicated from the host (Oracle FLEXCUBE) at regular intervals. The ‘Pull’ based replication methodology is used for reproducing host data in branch. This ensures that only necessary and critical information is available in the branch. This is achieved by creating materialized views in the branch schema. The materialized views can be created with desired frequency of refresh. This ensures that all branches have the most up to date data at all times. Note that not all data in host is replicated. Certain tables like static masters, user information and customer/accounts information are replicated.
The method of replication depends upon the mode of Oracle FLEXCUBE deployment. There are three modes of deployment viz:
This chapter contains the following sections:
This section contains the following topics:
You have to maintain CSTB_PARAMtable You have to maintain the following values for centralized set-up:
You need to maintain the following values for de-centralized and hybrid set-up:
You can replicate records from branch manually on an ad-hoc basis using the 'Manual Refresh' screen. You can invoke this screen by typing ‘STDBRREF’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Click ‘Replicate Common Data’ button to replicate the common data such as workflow, role definition, static data. This button is applicable only to centralized set branches. The branch tables are as follows.
Host Table |
Branch Table |
STTM_BRANCH_WF_DEF_MASTER |
FBTB_WF_DEF_MASTER |
STTM_BRANCH_WF_DEF_DETAIL |
FBTB_WF_DEF_DETAIL |
STTB_BRANCH_WF_MASTER |
FBTB_WF_MASTER |
STTB_BRANCH_WF_DETAIL |
FBTB_WF_DETAIL |
CSTM_BRANCH_FUNC_DEFN |
FBTB_FUNC_DEFN |
CSTM_BRN_STAT_FUNC_DEFN |
FBTB_STAT_FUNC_DEFN |
CSTB_LOV_INFO |
FBTB_LOV_INFO |
SMTB_FUNC_GROUP |
FBTB_FUNC_GROUP |
SMTB_FUNCTION_DESCRIPTION |
FBTB_FUNCTION_DESCRIPTION |
SMTB_MENU |
FBTB_MENU |
CSTM_BRANCH_LOC_PARAMS |
FBTB_PARAMS |
The table below lists the materialized views in branch schema:
CATM_CHECK_BOOK |
CATM_CHECK_DETAILS_MV |
CATM_STOP_PAYMENTS |
CGTM_BRANCH_PARAMETERS |
CGTM_LATE_CLEARING |
CSTB_CLG_REJ_REASON |
CSTB_DEBUG_USERS |
CSTB_FEATURES |
CSTM_DENM_DETAILS |
CSTM_DEV_PROJECT_DETAILS |
CSTM_DEVELOPER_PROJECTS |
CSTM_INST_DETAIL |
CSTM_INST_MASTER |
CSTM_PROD_BRN_DISALLOW |
CSTM_PRODUCT |
CSTM_PRODUCT_CCY_DISALLOW |
CSTM_PRODUCT_UDF_FIELDS_MAP |
CSTM_PRODUCT_USERDEF_FIELDS |
CYTB_CCY_PAIR_MASTER |
CYTB_RATES_HISTORY |
CYTM_CCY_DEFN_MASTER |
CYTM_CCY_PAIR_DEFN_MASTER |
CYTM_FWDRATE_DETAILS |
CYTM_FWDRATE_MASTER |
CYTM_RATE_TYPE |
CYTM_RATES |
CYTM_RATES_MASTER |
DETM_CLG_BANK_CODE |
DETM_CLG_BRN_CODE |
DETM_MCK_ISSUER_CODES |
DETM_MCK_ISSUER_CODES_DTL |
DETM_RT_PREFERENCES |
ERTB_MSGS |
FBTB_BRANCH_MULTIAUTH_AMT |
FBTB_BRANCH_MULTIAUTH_CCY |
FBTB_BRANCH_MULTIAUTH_MAP |
FBTB_BRANCH_PARAM |
FBTB_BRANCH_PARAM_MASTER |
FBTB_BRNLOC_MAP |
FBTB_CLG_BRN_CODE |
FBTB_CUST_ACC_BAL |
FBTB_CUST_ACCOUNT |
FBTB_FUNC_DEFN |
FBTB_FUNC_GROUP |
FBTB_FUNCTION_DESCRIPTION |
FBTB_ITEM_DESC |
FBTB_JOINT_ACC_HOLDER |
FBTB_LABELS |
FBTB_LOV_INFO |
FBTB_MODULES |
FBTB_RATES |
FBTB_ROLE_LIMIT |
FBTB_STAT_FUNC_DEFN |
FBTB_TCDENM |
FBTB_TILL_MASTER_MV |
FBTB_TILL_VLT_CCY_PARAMS |
FBTB_USER_AUTHORISER |
FBTB_USER_TILLS |
FBTB_UTILITY_PROVIDER |
FBTB_WF_DEF_MASTER |
FBTB_WF_TXN_LIMIT |
FBTM_BRANCH_INFO_MV |
FBTM_END_POINT |
FBTM_LCL_HOLIDAY |
GLTM_GLMASTER |
GLTM_MIS_CLASS |
GLTM_MIS_CODE |
GWTM_FCJ_FUNCTIONS |
IFTM_ARC_MAINT |
ISTM_INSTR_DAO_ACCOUNTS |
ISTM_INSTR_MASTER |
ISTM_INSTR_PROD |
MITM_ACCLS_DEFAULT |
MITM_COST_CODE |
MITM_CUSTOMER_DEFAULT |
MITM_MIS_GROUP |
MITM_MIS_HEAD |
MITM_POOL_CODE |
MITM_PRODUCT_DEFAULT |
SLAB_CODE_MAINT |
SMTB_LANGUAGE |
SMTB_MENU |
SMTB_PARAMETERS |
SMTB_ROLE_ACCCLASS |
SMTB_ROLE_DETAIL |
SMTB_ROLE_MASTER |
SMTB_USER |
SMTB_USER_ACCCLASS |
SMTB_USER_ACCESS_PRODUCTS |
SMTB_USER_BRANCHES |
SMTB_USER_CENTRAL_ROLES |
SMTB_USER_GLEXCEPT |
SMTB_USER_GLREST |
SMTB_USER_PRODUCTS |
SMTB_USER_ROLE |
STTB_CUST_LIMIT_TRACKING |
STTB_TRANSFERRED_ACCOUNT |
STTM_ACC_CLASS_GRP_DTL |
STTM_ACC_CLASS_GRP_MASTER |
STTM_ACCLS_BRN_RESTR |
STTM_ACCLS_CCY_BALANCES |
STTM_ACCOUNT_CLASS |
STTM_BANK |
STTM_BRANCH |
STTM_BRANCH_ARCGRP_MASTER |
STTM_BRN_ENT_MNT |
STTM_BRN_ENT_MNT_PARAMS |
STTM_BRN_FUNC_GRP_DTL |
STTM_BRN_FUNC_GRP_MASTER |
STTM_CCY_HOL_MASTER |
STTM_CCY_HOLIDAY |
STTM_CHARGE_CD_DETAIL |
STTM_CHARGE_CD_MASTER |
STTM_CLG_HOL_MASTER |
STTM_CLG_HOLIDAY |
STTM_COUNTRY |
STTM_CUST_IMAGE |
STTM_CUST_PERSONAL |
STTM_CUST_RESTR |
STTM_CUST_RESTR_CODES |
STTM_CUST_RESTR_LINK |
STTM_CUSTOMER |
STTM_DATES |
STTM_END_POINT |
STTM_FLOAT_DAYS_DETAIL |
STTM_FLOAT_DAYS_MASTER |
STTM_LATE_CLG_MTN |
STTM_LCL_HOL_MASTER |
STTM_LCL_HOLIDAY |
STTM_RESTR_CODE_PRDGRP |
STTM_SECTORS |
STTM_TRN_CODE |
STTM_VIRTUAL_ACCOUNTS |
SVTM_ACC_SIG_DET |
SVTM_ACC_SIG_MASTER |
SVTM_CIF_SIG_DET |
SVTM_CIF_SIG_MASTER |
SVTM_SLAB_CONDITIONS |
SVTM_SLAB_GROUP_DET |
UDTM_FIELDS |
UDTM_LOV |
You can replicate records from Host to Branch manually on an ad-hoc basis using the 'MV Refresh' screen. You can invoke this screen by typing 'MREF’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
External Reference Number
The system displays the external reference number.
Data Group
Select the data group from the drop-down list. The list displays the following options:
You can choose any one of the below mentioned option from the drop down list and click Refresh button to refresh all materialized views.
The MV Refresh screen will not support authorization.
The list of Materialized views along with the grouping are mentioned below:
Materialized View Name |
Data Group |
STTM_VIRTUAL_ACCOUNTS |
Account and Balance Information |
FBTB_CUST_ACC_BAL |
Account and Balance Information |
GLTM_GLMASTER |
Account and Balance Information |
STTB_TRANSFERRED_ACCOUNT |
Account and Balance Information |
STTM_ACCLS_CCY_BALANCES |
Account and Balance Information |
FBTB_JOINT_ACC_HOLDER |
Account and Balance Information |
FBTB_CUST_ACCOUNT |
Account and Balance Information |
CATM_CHECK_BOOK |
Check Information |
CATM_CHECK_DETAILS_MV |
Check Information |
CATM_STOP_PAYMENTS |
Check Information |
STTM_CUST_PERSONAL |
Customer Image Information |
MITM_CUSTOMER_DEFAULT |
Customer Image Information |
SVTM_ACC_SIG_MASTER |
Customer Image Information |
SVTM_CIF_SIG_MASTER |
Customer Image Information |
SVTM_ACC_SIG_DET |
Customer Image Information |
STTM_CUSTOMER |
Customer Image Information |
STTM_CUST_IMAGE |
Customer Image Information |
SVTM_CIF_SIG_DET |
Customer Image Information |
CYTM_CCY_DEFN_MASTER |
Exchange Rates Information |
CYTB_RATES_HISTORY |
Exchange Rates Information |
CYTB_CCY_PAIR_MASTER |
Exchange Rates Information |
CYTM_CCY_PAIR_DEFN_MASTER |
Exchange Rates Information |
CYTM_RATES |
Exchange Rates Information |
CYTM_RATES_MASTER |
Exchange Rates Information |
FBTB_RATES |
Exchange Rates Information |
CYTM_FWDRATE_DETAILS |
Exchange Rates Information |
CYTM_FWDRATE_MASTER |
Exchange Rates Information |
CYTM_RATE_TYPE |
Exchange Rates Information |
CSTM_DEV_PROJECT_DETAILS |
Others |
CSTM_DEVELOPER_PROJECTS |
Others |
CGTM_LATE_CLEARING |
Others |
STTM_LATE_CLG_MTN |
Others |
FBTB_BRANCH_MULTIAUTH_MAP |
Others |
FBTB_BRANCH_MULTIAUTH_CCY |
Others |
FBTB_BRANCH_MULTIAUTH_AMT |
Others |
STTM_SECTORS |
Others |
CGTM_BRANCH_PARAMETERS |
Others |
STTM_FLOAT_DAYS_MASTER |
Others |
STTM_FLOAT_DAYS_DETAIL |
Others |
STTM_LCL_HOLIDAY |
Others |
STTM_CLG_HOL_MASTER |
Others |
STTM_CLG_HOLIDAY |
Others |
STTM_LCL_HOL_MASTER |
Others |
FBTB_BRANCH_PARAM |
Others |
FBTM_BRANCH_INFO_MV |
Others |
FBTB_WF_TXN_LIMIT |
Others |
FBTB_WF_DEF_MASTER |
Others |
FBTM_END_POINT |
Others |
SVTM_SLAB_GROUP_DET |
Others |
SVTM_SLAB_CONDITIONS |
Others |
FBTM_LCL_HOLIDAY |
Others |
FBTB_UTILITY_PROVIDER |
Others |
FBTB_FUNC_GROUP |
Others |
FBTB_FUNC_DEFN |
Others |
FBTB_CLG_BRN_CODE |
Others |
FBTB_MODULES |
Others |
FBTB_TCDENM_DETAIL |
Others |
FBTB_TCDENM |
Others |
FBTB_ROLE_LIMIT |
Others |
STTM_CCY_HOL_MASTER |
Others |
ISTM_INSTR_DAO_ACCOUNTS |
Others |
ISTM_INSTR_MASTER |
Others |
ISTM_INSTR_PROD |
Others |
IFTM_ARC_MAINT |
Others |
DETM_RT_PREFERENCES |
Others |
GLTM_MIS_CLASS |
Others |
GLTM_MIS_CODE |
Others |
MITM_POOL_CODE |
Others |
MITM_PRODUCT_DEFAULT |
Others |
SLAB_CODE_MAINT |
Others |
MITM_MIS_HEAD |
Others |
MITM_ACCLS_DEFAULT |
Others |
MITM_COST_CODE |
Others |
MITM_MIS_GROUP |
Others |
DETM_MCK_ISSUER_CODES_DTL |
Others |
CSTM_INST_DETAIL |
Others |
CSTM_INST_MASTER |
Others |
CSTM_PROD_BRN_DISALLOW |
Others |
CSTM_DENM_DETAILS |
Others |
CSTB_CLG_REJ_REASON |
Others |
CSTB_FEATURES |
Others |
GWTM_FCJ_FUNCTIONS |
Others |
DETM_CLG_BRN_CODE |
Others |
DETM_CLG_BANK_CODE |
Others |
DETM_MCK_ISSUER_CODES |
Others |
CSTM_PRODUCT_USERDEF_FIELDS |
Others |
CSTM_PRODUCT |
Others |
CSTM_PRODUCT_CCY_DISALLOW |
Others |
CSTM_PRODUCT_UDF_FIELDS_MAP |
Others |
SMTB_LANGUAGE |
Others |
STTM_CUST_RESTR_LINK |
Others |
UDTM_FIELDS |
Others |
STTM_TRN_CODE |
Others |
STTM_DATES |
Others |
STTM_BRN_ENT_MNT_PARAMS |
Others |
STTM_BRN_FUNC_GRP_DTL |
Others |
STTM_RESTR_CODE_PRDGRP |
Others |
UDTM_LOV |
Others |
STTM_BRN_FUNC_GRP_MASTER |
Others |
STTM_CHARGE_CD_DETAIL |
Others |
STTM_COUNTRY |
Others |
STTM_CUST_RESTR_CODES |
Others |
STTM_END_POINT |
Others |
STTM_CUST_RESTR |
Others |
STTM_CHARGE_CD_MASTER |
Others |
STTM_CCY_HOLIDAY |
Others |
STTB_CUST_LIMIT_TRACKING |
Others |
STTM_ACC_CLASS_GRP_DTL |
Others |
SMTB_ROLE_MASTER |
Others |
SMTB_PARAMETERS |
Others |
SMTB_ROLE_ACCCLASS |
Others |
SMTB_ROLE_DETAIL |
Others |
STTM_BRANCH |
Others |
STTM_BRANCH_ARCGRP_MASTER |
Others |
STTM_BRN_ENT_MNT |
Others |
STTM_BANK |
Others |
STTM_ACC_CLASS_GRP_MASTER |
Others |
STTM_ACCLS_BRN_RESTR |
Others |
STTM_ACCOUNT_CLASS |
Others |
FBTB_BRNLOC_MAP |
Static |
FBTB_ITEM_DESC |
Static |
SMTB_MENU |
Static |
ERTB_MSGS |
Static |
FBTB_FUNCTION_DESCRIPTION |
Static |
FBTB_LABELS |
Static |
FBTB_LOV_INFO |
Static |
FBTB_STAT_FUNC_DEFN |
Static |
FBTB_USER_AUTHORISER |
User and TILL Information |
FBTB_USER_TILLS |
User and TILL Information |
FBTB_TILL_MASTER_MV |
User and TILL Information |
FBTB_TILL_VLT_CCY_PARAMS |
User and TILL Information |
SMTB_USER_ACCESS_PRODUCTS |
User and TILL Information |
SMTB_USER_BRANCHES |
User and TILL Information |
SMTB_USER_ACCCLASS |
User and TILL Information |
CSTB_DEBUG_USERS |
User and TILL Information |
SMTB_USER |
User and TILL Information |
SMTB_USER_PRODUCTS |
User and TILL Information |
SMTB_USER_ROLE |
User and TILL Information |
SMTB_USER_GLREST |
User and TILL Information |
SMTB_USER_CENTRAL_ROLES |
User and TILL Information |
SMTB_USER_GLEXCEPT |
User and TILL Information |
Centralized Branch Setup
For centralized branch setup, you need to follow the steps given below:
Decentralized Branch Setup
For decentralized branch setup, you need to follow the steps given below:
For further details on this point, refer to the installation manuals ‘Setting up Database’ and ‘Setting up Property File’.