3.1 Loading the Client-Specific Data

This section explains steps to load the client-specific data into the OFSCRR application. To load the client-specific data, follow these steps:

  1. Navigate to <ftpshare path>/STAGE/Excelupload/Templates.
  2. The <ftpshare path> is the same path given in variable OFSAAI FTP in OFSAAI_InstallConfig.xml while installing OFSAAI. For more information, see Configuring OFSAAI_InstallConfig.xml File section in the Oracle Financial Services Compliance Regulatory Reporting Installation Guide..
  3. Download the following Excel sheets to the Windows machine from the path given in the step 2.
    The following table lists Excel sheet details such as group code, description, and so on.

    Table 3-1 Excel Sheets

    Excel Name Table Description Area of Impact
    DIM_DOMAIN1.xlsx Provides the list of all Jurisdictions which are available in OFSECM. Security Attribute1 Static Information section.
    DIM_DOMAIN1_TL.xlsx Provides the list of all Jurisdictions which are available in OFSECM for language pack. Security Attribute1 Static Information section.
    DIM_DOMAIN2.xlsx Provides the list of all Business Domains which are available in OFSECM. Security Attribute2 Static Information section.
    DIM_DOMAIN2_TL.xlsx Provides the list of all Business Domains which are available in OFSECM for language pack. Security Attribute2 Static Information section.
    DIM_DOMAIN3.xlsx Provides the list of all Case Type and Case SubTypes which are available in OFSECM. Security Attribute3 Static Information section.
    DIM_DOMAIN3_TL.xlsx Provides the list of all Case Type and Case SubTypes which are available in OFSECM for language pack. Security Attribute3 Static Information section.
    DIM_DOMAIN4.xlsx Provides the list of all Organizations that are available in OFSECM. Security Attribute4 Static Information section.
    DIM_DOMAIN4_TL.xlsx Provides the list of all Organizations that are available in OFSECM for language pack. Security Attribute4 Static Information section.
    DIM_DOMAIN5.xlsx Provides the list of all Scenario Classes which are available in OFSECM. Security Attribute5 Static Information section.
    DIM_DOMAIN5_TL.xlsx Provides the list of all Scenario Classes which are available in OFSECM for language pack. Security Attribute5 Static Information section.
    DIM_COUNTRY.xlsx Provides the list of all Countries that need to be made available to the application Country Information section
    DIM_COUNTRY_TL.xlsx Provides the list of all Countries that need to be made available to the application for language pack. Country Information section
    DIM_STATES.xlsx Provides the list of all states for the countries that need to be made available to the application. State Information section
    DIM_STATES_TL.xlsx Provides the list of all states for the countries that need to be made available to the application for language pack. State Information section

    DIM_REPORT_INDICATO

    RS.xlsx

    		 Provides the list of all report indicators that need to be made available to the application. Report Indicators Information section

    DIM_REPORTING_ENTIT

    Y_DTLS.xlsx

    		 Provides the list of all reporting entity details that need to be made available to the application. Reporting Entity Information section

    DIM_REPORTING_ENTIT

    Y_DTLS_TL.xlsx

    		 Provides the list of all reporting entity details that need to be made available to the application for language pack. Reporting Entity Information section

    DIM_REPORTING_PERSO

    N.xlsx

    		 Provides the list of all reporting person details that need to be made available to the application. Reporting Person Information section

    DIM_REPORTING_PERSO

    N_TL.xlsx

    		 Provides the list of all reporting person details that need to be made available to the application for language pack. Reporting Person Information section
    DIM_ADDRESS.xlsx Provides the list of all address that need to be made available to the application. Address Information section

    DIM_CONTACT_TYPE.xl

    sx

    		 Provides the list of all contact type that need to be made available to the application. Contact Type Information section

    DIM_COMMUNICATION_T

    YPE.xlsx

    		 Provides the list of all communication types that need to be made available to the application. Communication Information section

    DIM_COMMUNICATION_T

    YPE_TL.xlsx

    		 Provides the list of all communication types that need to be made available to the application for language pack. Communication Information section
    DIM_PHONE Provides the list of all phones that need to be made available to the application. Phone Information section
    DIM_IDENTIFICATION Provides the list of all identifications that need to be made available to the application. Identification Information section
    DIM_FUNDS_TYPE.xslx Provides the list of funds type which is used for GOAML STR report type. Transaction's Involved party Details section

    DIM_ACCOUNT_TYPE.xs

    lx

    		 Provides the list of account type which is used for GOAML STR report type. Involved Account Details section

    DIM_SUSPECT_ID_TYPE

    .xslx

    		 Provides the list of Identification type which is used for GOAML STR report type. All types of Involved party identification's section

    DIM_IDENTIFICATION.

    xslx

    		 Provides the list of Identification type which is used for GOAML STR report type. Reporting Person Section
    DIM_CURRENCY.xslx Provides the list of Currency which is used for GOAML STR report type. All types of Involved party section for currency type

    DIM_TRANSACTION_TYP

    E.xslx

    		 Provides the list of Conduction and Transaction Type which is used for GOAML STR report type. Transaction section

    DIM_TRANS_ITEM_STAT

    US.xslx

    		 Provides the list of Status transacted items which is used for GOAML STR report type. Transaction's Goods and Services Details section
    DIM_GENDER.xsls Provides the list of Gender Type which is used for GOAML STR report type. All types of Involved party section for Gender type

    DIM_TRANSACTION_ITE

    M_TYPE.xsls

    		 Provides the list of Transacted Item type which is used for GOAML STR report type. Transaction's Goods and Services Details section

    DIM_CONTACT_TYPE.xs

    ls

    		 Provides the list of Contact type which is used for GOAML STR report type. All types of Involved party Phone's section

    DIM_COMMUNICATION_T

    YPE.xsls

    		 Provides the list of Communication Type which is used for GOAML STR report type. All types of Involved party Phone's section

    DIM_FINANCIAL_INST_

    TYPE.xsls

    		 Provides the list of Incorporation Legal Form type which is used for GOAML STR report type. Transaction's Involved Entity Party Details section
    DIM_ROLE.xslx Provides the list of Role Type which is used for GOAML STR report type. Involved party Details section

    ACCOUNT_STATUS_TYPE

    .xslx

    		 Provides the list of Account Status type which is used for GOAML STR report type. Involved Account Details section
    FCT_BRANCH_INFO Provides the list of all branches that need to be made available to the application. Branch Information section

    FCT_BRANCH_INFO_TL.

    xlsx

    		 Provides the list of all branches that need to be made available to the application for language pack. Branch Information section

    MAP_REPENTITYDTLS_R

    EPTYPE.xlsx

    		 Provides the list of all mapping for reporting entity and GOAML STR report type. Reporting Entity Details section

    Note:

    The data provided in the above tables must be updated into E-File XSD enumeration as well.
  4. Add data in each Excel sheet as per your report requirement. For more information, see the Oracle Financial Services Data Model Reference Guide. .