5. Data Replication
5.1 Introduction
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:
- Centralized FCUBS deployment - In ‘Centralized’ deployment, replication is a seamless process. During authorization process of any host function id whose data has to be replicated, that data is immediately moved to corresponding branch tables. There is no need for manual or automated process to initiate such replication.
- De-Centralized FCUBS deployment – In a ‘De-centralized’ deployment, all the branches will be deployed in de-centralized mode.Data can be replicated by using materialized views.
- Hybrid FCUBS deployment – In ‘Hybrid’ deployment, certain branches may have a centralized deployment while some others may have a decentralized deployment. In this mode, you can replicate data using materialized views.
This chapter contains the following sections:
5.2 Maintain Replication Parameters
This section contains the following topics:
- Section 5.2.1, "Maintaining Replication Parameters"
- Section 5.2.2, "Replicate Common Data Button"
- Section 5.2.3, "List of Materialized Views"
5.2.1 Maintaining Replication Parameters
You have to maintain CSTB_PARAMtable You have to maintain the following values for centralized set-up:
- BRANCH_INSTALLED - Y
- DEPLOYMENT_MODE - C (Here, C indicates Centralized, H indicates Hybrid and D indicates Decentralized)
You need to maintain the following values for de-centralized and hybrid set-up:
- BRANCH_INSTALLED - Y
- DEPLOYMENT_MODE - D or H (Here, C indicates Centralized, H indicates Hybrid and D indicates Decentralized)
5.2.2 Replicate Common Data Button
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 |
5.2.3 List of Materialized Views
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 |
5.2.4 Replicating data from Branch - Ad-hoc basis
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:
- Data Group
- Account and Balance Information
- Check Information
- Customer Image Information
- Exchange Rates Information
- Others
- Static
- User and TILL Information
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 |
5.3 Steps to follow during Setup
Centralized Branch Setup
For centralized branch setup, you need to follow the steps given below:
- During setup, you need to select the Branch plug-in in the Installer. Select the mode of deployment as ‘Centralized’.
- For further details on this point, refer to the installation manuals ‘Setting up Database’ and ‘Setting up Property File’.
- Once the set up is complete, for common static data replication, you get an option in ‘STDBRREF’ screen, by clicking the button ‘Replicate Common Data’. When you subsequently click this button, only the incremental common static data is replicated. This specific step is not required when new centralized branches are created using ‘STDBRANC’.
Decentralized Branch Setup
For decentralized branch setup, you need to follow the steps given below:
- During setup, you need to select the Branch plug-in in the Installer. Select the mode of deployment as ‘De-centralized’.
For further details on this point, refer to the installation manuals ‘Setting up Database’ and ‘Setting up Property File’.