B.3 Post-installation Steps

After the installation of OFS PCD, follow these post-installation steps:

  1. Deploy war and test data execution:
    • Deploy the war file and restart the servers.
    • Create new user by logging in as sysadmn and authorize using sysauth user.
    • Map the FTP admin group to new user and authorize using sysauth user.

      Figure B-1 User Group Mapping


      User Group Mapping

    • Navigate to the deployed path /WEB-INF/classes folder and update the Infodom name and userId in ofsaaws.properties file.

      Path example: /scratch/pmuser/apache-tomcat-8.5.31/webapps/ofsaapcd/WEB-INF/classes

      Figure B-2 ofsaaws.properties File


      ofsaaws.properties File

    • After above configuration, restart the Tomcat server.
    • Execute the products and IRC files in FTP Atomic Schema.
    • If FTP OFSAA instance is present in different Host, you have to add the following entry in the web.xml present at $CATALINA_HOME/webapps/<FTP context>/web-inf/web.xml folder.
      <filter>
          <filter-name>FilterServlet</filter-name>
          <filter-class>com.iflex.fic.filters.FilterServlet</filter-class>
      	<init-param>
      	 <param-name>AllowOrigin</param-name>
      	 <param-value>http://<PCD_HOST_NAME>:<PORT></param-value>
      	 </init-param>
        </filter>
       Example
      <filter>
          <filter-name>FilterServlet</filter-name>
          <filter-class>com.iflex.fic.filters.FilterServlet</filter-class>
      	<init-param>
      	 <param-name>AllowOrigin</param-name>
      	 <param-value>http://whf00crk:8080</param-value>
      	 </init-param>
        </filter>
  2. Product hierarchy creation:
    • Login with New User (like FTPUSER).
    • Navigate to Common Object Maintainance, select Dimension Management, and then select Hierarchies.
      1. Select the Product under Dimension drop-down.

        Figure B-3 Hierarchies


        Hierarchies

      2. Click Add.
      3. Enter the Name like PCD Hierarchy, enter the description,0 and then select folder.

        Figure B-4 Hierarchy Definition


        Hierarchy Definition

      4. Right-click below the Show Hierarchy section and click Create and add child.

        Figure B-5 Hierarchy Definition


        Hierarchy Definition

      5. Fill the mandatory fields like numeric code and Name like Default Parent. Click Generate Numeric Code icon for Numeric code to generate and click Save.

        Figure B-6 Member Definition


        Member Definition

      6. The Parent Hierarchy will be displayed like Default Parent. Right-click on that and select Add leaf.

        Figure B-7 Member Definition


        Member Definition

      7. Move the products from LHS to RHS and click on Ok.

        Figure B-8 Add Member


        Add Member

      8. The mapped products will be listed under the newly created hierarchy. Then click Save.

        Figure B-9 Member Definition


        Member Definition

  3. Default Hierarchy: Navigate to Fund Tranfer Pricing and select Application Preferences.
    1. Select the newly created hierarchy as default hierarchy and click Apply. In this example, PCD Hierarchy is the default Hierarchy.
    2. Select debugging Output level drop-down as show All SQL and select Legal entity as default member and click Apply.

      Figure B-10 Application Preferences


      Application Preferences

      Figure B-11 Application Preferences


      Application Preferences

  4. Create Transfer Pricing Rules (TP Rule): Navigate to Fund Transfer Pricing, FTP Assumption Specification, Transfer Pricing Rules, and then click Add.

    Figure B-12 Transfer Pricing Rules


    Transfer Pricing Rules

    1. Enter the Mandatory fields, select PCD Hierarchy as Product Hierarchy.

      Figure B-13 Transfer Pricing Rule: Definition Mode


      Transfer Pricing Rule: Definition Mode

    2. Expand the product parent and select any product to which you want to add Transfer Pricing Rule.

      Figure B-14 Product Hierarchy Selection


      Product Hierarchy Selection

    3. Add the Transfer Pricing Rule as follows. Select any Transfer Pricing method. For example: Cash: Average Life and select the IRC code.

      Figure B-15 Transfer Pricing Rules


      Transfer Pricing Rules

    4. The selected Transfer Pricing Method will be displayed for that product as follows. Save the Transfer Pricing Rule.

      Figure B-16 Transfer Pricing Rules


      Transfer Pricing Rules

  5. Create Adjustment Rules: Navigate to Funds Transfer Pricing, select FTP Assumption Specification, and then select Adjustment Rules. Click Add.

    Figure B-17 Adjustment Rules


    Adjustment Rules

    1. Enter all the Mandatory fields.
    2. Click Adjustment Type Hierarchy and select the below Adjustment Types by moving from LHS to RHS, and then click Ok.

      Figure B-18 Adjustment Type Hierarchy Browser


      Adjustment Type Hierarchy Browser

    3. Adjustment types will be displayed as follows. Select Transfer Pricing Rule for each Adjustment types.

      Figure B-19 Adjustment Rule (Edit Mode)


      Adjustment Rule (Edit Mode)

    4. Adjustment Method has to be added for each Adjustment Types:
      • Select any one Adjustment Type say Liquidity Adjustment. Below the Assumption Browser expand Product Hierarchy and then select the same product for which TP Rule was created.

        Figure B-20 Adjustment Type Selection


        Adjustment Type Selection

      • Click Add to select the Adjustment Method.
      • Select any Adjustment method from drop-down like Formula Based rate.
      • Fill the mandatory fields. Under Parameters grid, define Formula by selecting the row as follows. Then click the Delete icon which is displayed next to delete icon on right side of the Parameters grid.
      • Formula window is displayed as follows. Fill all the fields and click Apply.

        Figure B-21 Formula Based Rate Definition


        Formula Based Rate Definition

      • If the Adjustment method is Fixed Rate then refer to the following screenshot.

        Figure B-22 Adjustment Rule Details


        Adjustment Rule Details

    5. Now the defined Adjustment Method will be displayed for the product as follows.

      Figure B-23 Adjustment Method


      Adjustment Method

    6. Repeat adding Adjustment Method for each of the Adjustment Types namely Basic Risk Costs, Pricing Incentives, and Other Adjustments. Then click Save.
  6. Create the Standard Process: Navigate to Funds Transfer Pricing, FTP Processing, Standard Process, and then click Add.
    1. Enter Process details and click Apply.

      Figure B-24 Standard Process (Edit Mode)


      Standard Process (Edit Mode)

    2. Under Product Selection section, click Source and select the Source Hierarchy as PricingManagementGeneratedInstruments as shown below.

      Note:

      If Source Hierarchy has no data then for Source Hierarchy to load data in Standard Process screen execute the following update query in Atomic Schema.
      update REV_TABLE_CLASS_ASSIGNMENT set validated_flag = 'Y' ;
      commit;
    3. Click Apply to navigate to Calculation Section. Fill the details as follows:

      Figure B-25 Calculation Selection


      Calculation Selection

    4. Select All-In Transfer Rate Hierarchy. Then select a product and click Define.

      Figure B-26 All-In Transfer Rate Hierarchy


      All-In Transfer Rate Hierarchy

    5. All in Transfer Rate mapping window will be displayed as follows. Select Plus for each Adjustment Types and click Apply.

      Figure B-27 All-In Transfer Pricing Rate Mapping


      All-In Transfer Pricing Rate Mapping

    6. Click Apply to navigate to Transfer Pricing Rule list. Select TP rule and then select Adjustment Rule.

      Figure B-28 Calculation Selection


      Calculation Selection

    7. In the last section select Freeze and then Confirm. The created Standard Process and displayed in the summary as shown in screenshot.

      Figure B-29 Standard Pricing Process Summary


      Standard Pricing Process Summary

  7. Execute the Standard Process to test the status:
    1. Select the Process and click the Run icon.
    2. Select As of Date as Todays date and click OK.

      Figure B-30 Run Execution Parameters


      Run Execution Parameters

    3. Refresh the summary screen and verify the status of the process. It should show success. If it is failed verify the logs.

      Log path: ../ftpshare/logs