8.1 Configuring the ISO20022 Message Parameters

To configure the ISO20022 message parameters, follow these steps:

  1. On the Financial Services Analytical Applications Transactions Filtering landing page, click
    ISO20022/XML Configuration Admin. The Configuration window is displayed.

    Figure 8-1 Configuration Window - ISO20022


    Configuration Window - ISO20022

    The Message List displays the XSD files associated with each message provider /scheme/mes- sage type combination. Click the link in the Message Provider column to view the transaction XPaths for the message for every screening type. You can download the XSD for a message by

    Figure 8-2 Download Icon

    Download Icon
    clicking Download in the Download XSD column. The XSD is downloaded as a zip folder; unzip the folder to view the XSD files.
  2. To upload a new XSD file, click Add Message. An Attachment Details dialog box opens.

    Figure 8-3 Add Message Dialog Box


    Add Message Dialog Box

  3. Select the message provider and message type for the web service. If required, you can also select the message scheme. If you select a message scheme, then the message types change depending on the selected combination of the message provider and message scheme.

    Note:

    The message provider, message scheme, and message type values are mapped in the fcc_tf_xml_pro_sch_msg_map table.
  4. To upload the parent XSD file and one or more child XSD files, click Upload

    Figure 8-4 Upload Icon

    Upload Icon
    and select the XSD file from your local drive. After you select the file and click Open, the XSD file name appears next to the Upload button. Select the radio button next to the primary file name and click Upload. A confirmation message appears, “File uploaded successfully.” The basic elements related to the uploaded file appear in a tree view.

    Figure 8-5 Add Message Dialog Box


    Add Message Dialog Box

    If you want to see the XPath of an element, select the element from the drop-down field. In the example window, the XPath for the StrNm element is highlighted in red.

    To choose the Batch XPath or the Transaction XPath of the element, right-click any ele- ment node in the Tree view and click Batch or Transaction respectively. The values appear in the tree view. It is mandatory to select the Transaction XPath Configuration before you submit the uploaded files.

    Note:

    To view the child elements for a parent element, mouse over the parent element and click the parent element in the Tree view. If Zero

    Figure 8-6 Zero Icon

    Zero Icon
    is displayed beside the element name, it means that there are no more child elements you can drill down to.
  5. Click Submit. The ISO20022 parameter name appears in the Message List section with _Draft attached to the parameter name.

    Figure 8-7 Message List Window


    Message List Window

  6. Navigate to ISO20022/XML Configuration Admin in the Admin UI. To complete the configura- tion, click the message provider link. The XML Screening Configuration tab is displayed.

    Figure 8-8 XML Screening Configuration


    XML Screening Configuration

    In this tab, you can view the available element XPaths for the selected web service. The ISO20022/XML Configuration Admin screen enables the following XML screening configurations:
    • Name and Address
    • Identifier
    • Country and City
    • Narrative or Free Text Information
    • Port Screening
    • Goods Screening
    You can select a screening type from the Screening Type drop-down and configure the related screening XPath as required.

    You can also perform the following actions:

    Table 24:

    Table 8-1 Other Actions

    To... Do this...
    Add a web service configu- ration
    Click Add. The following fields appear:

    Figure 8-9 Add a web service configuration


    Add a web service configuration

    Select the message direction and enable or disable the web service and click Save. Clicking Clear clears any values selected. If you click Cancel, the fields disappear.

    In the Tree view, right-click any element node and click the element to view the element’s XPath. The fields appear in the Screening XPath Configuration List section.

    Figure 8-10 Add a web service configuration - tree view


    Add a web service configuration - tree view

    Update a web service con- figuration Select the configuration you want to update and click Update. The fields shown in the previous row appear. Make the required changes and click Save. The updated values are displayed in the Screening XPath Con- figuration List section.
    Remove a web service con- figuration Select the configuration you want to remove and click Remove. The selected configuration is removed from the Screening XPath Config- uration List section.
    Enable all web service con- figurations Click Enable All.
    Disable all web service con- figurations Click Disable All.
  7. Navigate to ISO20022/XML Configuration Admin in the Admin UI and click the message pro- vider link. To add the screening configuration of External Attribute, select the Attributes under the Screening External Attribute Configuration list. The Screening External Attribute Con- figuration list is displayed.

    Figure 8-11 External Attribute List Window


    The following illustration shows the External Attribute List window. This page provides the screen external attribute configuration list, which displays the details of the attribute name, enable status, and message direction details. You can also Add, Update, Remove, Disable and Enable attributes from this page.

In this tab, you can view the details of the attribute name, enable status, and message direction details. You can also perform the following actions:

Note:

The Add button will only appear when the user configures the FCC_TF_XML_EXTERNAL_ATTR and FCC_TF_XML_EXTERNAL_ATTR_MLS tables. Refer the following examples.

Example: 1

To configure FCC_TF_XML_EXTERNAL_ATTR table, run the following query similar way in your atomic schema:
REM INSERTING into FCC_TF_XML_EXTERNAL_attr SET DEFINE OFF;
Insert into FCC_TF_XML_EXTERNAL_attr (N_ID,V_ATTRIBUTE_NAME) values (1,'AdditionalAttribute1');
Insert into FCC_TF_XML_EXTERNAL_attr (N_ID,V_ATTRIBUTE_NAME) values (2,'AdditionalAttribute2');
Insert into FCC_TF_XML_EXTERNAL_attr (N_ID,V_ATTRIBUTE_NAME) values (3,'AdditionalAttribute3');
Insert into FCC_TF_XML_EXTERNAL_attr (N_ID,V_ATTRIBUTE_NAME) values (4,'AdditionalAttribute4');
Insert into FCC_TF_XML_EXTERNAL_attr (N_ID,V_ATTRIBUTE_NAME) values (5,'AdditionalAttribute5');

Figure 8-12 Example 1


The following illustration shows the query provided in Example 1

Example: 2

To configure FCC_TF_XML_EXTERNAL_ATTR_MLS table, run the following query similar way in your atomic schema:
REM INSERTING into FCC_TF_XML_EXTERNAL_attr_MLS SET DEFINE OFF;
Insert into FCC_TF_XML_EXTERNAL_attr_MLS (N_ID,V_ATTRIBUTE_NAME,V_LOCALE_CODE) values
(1,'AdditionalAttribute1','en_US');
Insert into FCC_TF_XML_EXTERNAL_attr_MLS (N_ID,V_ATTRIBUTE_NAME,V_LOCALE_CODE) values
(2,'AdditionalAttribute2','en_US');
Insert into FCC_TF_XML_EXTERNAL_attr_MLS (N_ID,V_ATTRIBUTE_NAME,V_LOCALE_CODE) values
(3,'AdditionalAttribute3','en_US');
Insert into FCC_TF_XML_EXTERNAL_attr_MLS (N_ID,V_ATTRIBUTE_NAME,V_LOCALE_CODE) values
(4,'AdditionalAttribute4','en_US');
Insert into FCC_TF_XML_EXTERNAL_attr_MLS (N_ID,V_ATTRIBUTE_NAME,V_LOCALE_CODE) values
(5,'AdditionalAttribute5','en_US');

Figure 8-13 Example 2


The following illustration shows the query provided in Example 2

Table 25:

Table 8-2 Other Actions

To... Do this...
Add an external attribute configuration
Click Add. The following fields appear:

Figure 8-14 Add an External Attribute configuration


Add an External Attribute configuration

Select the message direction and enable or disable the web service and click Save. Clicking Clear clears any values selected. If you click Cancel, the fields disappear.

Update a web service con- figuration Select the configuration you want to update and click Update. The fields shown in the previous row appear. Make the required changes and click Save. The updated values are displayed in the Screening External Attribute Configuration List section.
Remove a web service con- figuration Select the configuration you want to remove and click Remove. The selected configuration is removed from the Screening External Attri- bute Configuration List section.
Enable all web service con- figurations Click Enable All.
Disable all web service con- figurations Click Disable All.
  1. After configuring the External Attributes, give the following attribute names (Same attribute names which are populated in the above tables) in message posting jsp.
    Example: SanctionsPost.jsp
    String AdditionalAttribute1 = request.getParameter("AdditionalAttribute1");
     String AdditionalAttribute2 = request.getParameter("AdditionalAttribute2");
     String AdditionalAttribute3 = request.getParameter("AdditionalAttribute3"); 
    String AdditionalAttribute4 = request.getParameter("AdditionalAttribute4"); 
    String AdditionalAttribute5 = request.getParameter("AdditionalAttribute5"); 
  2. To view the message tag configurations for a field, click the XML Message Configuration tab.

    Figure 8-15 XML Message Configuration Tab


    XML Message Configuration Tab

    You can also perform the following actions:

    Table 8-3 Other Actions

    To... Do this...
    Add a message configuration
    Click Add. The following fields appear:

    Figure 8-16 Add a message configuration


    Description of adding a message configuration follows This illustration shows the options to select the business data value, message direction, enable or disable the value when the message is screened, and choose the priority 1 XPath and priority 2 XPath.

    Select the business data value, message direction, enable or disable the value, choose the Priority 1 XPath and Priority 2 XPath, and click Save. Clicking Clear clears any values selected. If you click Cancel, the fields disappear.

    In the Tree view, right-click any element node and click the element to view it’s XPath. The fields appear in the Message Tag Configura- tion List section.

    Figure 8-17 Add a message configuration - tree view


    Description of the tree view when you add a message configuration follows This illustration shows the fields when you right-click any element node and click the element to view the element's XPath. The fields appear in the Message Tag Configuration List.

    Update a message configu- ration Select the configuration you want to update and click Update. The fields shown in the previous row appear. Make the required changes and click Save. The updated values are displayed in the Message Tag Configu- ration List section.
    Remove a message config- uration Select the configuration you want to remove and click Remove. The selected configuration is removed from the Message Tag Configura- tion List section.

    Note:

    The ready-to-use business data values are available in the DIM_TF_XML_MSG_TAG_FLD column. You can add a new value in this column.
  3. Click Submit. The ISO20022 parameter name is updated in the Message List without _Draft.

    Figure 8-18 Message List Window


    Message List Window

    Note:

    If an earlier configuration exists with the same message version, then this configuration is disabled, and the new configuration is enabled.