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

9.1 Recommended Method

This topic describes the recommended 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.
Case 1

Follow the below steps if the pre-requisite is true, i.e., if only one product code is mapped to only one branch.

  1. Update the below server argument parameter as Y in the managed server where obscf-core-service is deployed.
    -Dflyway.domain.placeHolders.obscf.core.productMigrationReqd='Y'
  2. Deploy both obscf-core-service and obscf-report-service serices.

Case 2

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-1 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 Y in the managed server where obscf-core-service is deployed.
    -Dflyway.domain.placeHolders.obscf.core.productMigrationReqd='Y'
  3. Deploy both obscf-core-service and obscf-report-service serices.
  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