1. Services Installation Guide
  2. Migration Support
  3. Alternate Method

9.2 Alternate Method

This topic describes the alternate method to install the multi-branch support feature for existing implementations.

Pre-requisite: One product code is mapped to only one Branch i.e., there should not be a same product code mapped to different branches.
Follow the below steps if the pre-requisite is not true, i.e., if a product code is mapped to multiple branches.
  1. Retain the product records for only one branch and delete it in the other branches in the following tables.

    Table 9-2 Schema Table

    Schema Name Table Name ID/Foreign Key
    OBSCF_CORE SCF_TM_PRODUCT_MASTER ID
    OBSCF_CORE SCF_TW_PRODUCT_MASTER ID
    OBSCF_CORE SCF_TM_PROD_LIMIT_DECN PRODUCT_MASTER_ID
    OBSCF_CORE SCF_TW_PROD_LIMIT_DECN PRODUCT_MASTER_ID
    OBSCF_CORE SCF_TM_PROD_LIMITS_EXP_HANDL LIMIT_DECN_MASTER_ID
    OBSCF_CORE SCF_TW_PROD_LIMITS_EXP_HANDL LIMIT_DECN_MASTER_ID
    OBSCF_REPORT SCF_TM_PRODUCT_MASTER ID
    OBSCF_REPORT SCF_TW_PRODUCT_MASTER ID
    OBSCF_REPORT SCF_TM_PROD_LIMIT_DECN PRODUCT_MASTER_ID
    OBSCF_REPORT SCF_TW_PROD_LIMIT_DECN PRODUCT_MASTER_ID
    OBSCF_REPORT SCF_TM_PROD_LIMITS_EXP_HANDL LIMIT_DECN_MASTER_ID
    OBSCF_REPORT SCF_TW_PROD_LIMITS_EXP_HANDL LIMIT_DECN_MASTER_ID

    Note:

    The user must maintain only one record per branch if the products are maintained for multiple branches. For example: If product VENF is maintained for both 004 and 006 branches, then the user should retain the product record for only one branch and delete the record in the other branches from the below mentioned tables.
  2. Update the below server argument parameter as N in the managed server where obscf-core-service is deployed.
    -Dflyway.domain.placeHolders.obscf.core.productMigrationReqd='N'
  3. Run the following scripts present in the obscf-core-services war file.
    Path: obscf-core-services.war\WEB-INF\classes\db\migration\domain\
    1. Run the drop constraint scripts:
      V506_002_8.8.1_7_50600215_14_0__SCF_TW_PRODUCT_MASTER.sql
V506_002_8.8.1_8_50600215_14_0__SCF_TM_PRODUCT_MASTER.sql
    2. Run the migration DML scripts:
      V506_002_8.8.1_9_50600215_1_1__SCF_TW_PRODUCT_MASTER.sql
V506_002_8.8.1_10_50600215_1_1__SCF_TM_PRODUCT_MASTER.sql
    3. Run the create constraint scripts:
      V506_002_8.8.1_15_50600215_15_0__SCF_TW_PRODUCT_MASTER.sql
V506_002_8.8.1_16_50600215_15_0__SCF_TM_PRODUCT_MASTER.sql
  4. Perform the following steps to add the product records deleted for other branches:
    1. Login to the application.
    2. Navigate to View Product Parameters screen.
    3. Click Options for the respective product and then click Unlock to modify the record details.
    4. Add the deleted branches in the Allowed/Restricted Branches field accordingly. Refer to Create Product Parameters section in the Supply Chain Finance User Guide.

Parent topic: Migration Support