4.1 Loading the Client-Specific Data

A client-specific data is data such as jurisdictions, filing institution information, business domains, transmitter Information, and so on. This section explains the steps to load the client specific data into the OFSCRR application.

To load the client-specific data, follow these steps:

  1. Navigate to <ftpsharepath>/STAGE/Excelupload/Templates.
  2. The <ftpshare path> is the same path given in the variable OFSAAI FTP in OFSAAI_InstallConfig.xml while installing OFSAAI. For more information, see Configuring OFSAAI_InstallConfig.xmlFile section in the Oracle Financial Services Compliance Regulatory Reporting Installation Guide
  3. Download the following Excel sheets in the Template folder to the Windows machine from the path given in step 1.

Table 4-1 describes the table name and reference to the data model.

Table 4-1 Excel Sheets

Group Code Group Name Group Description
DIM_DOMAIN1.xlsx Provide the list of all jurisdictions that are available in OFSECM. SecurityAttribute1 Static Information section.
DIM_DOMAIN2.xlsx Provide the list of all business domains which are available in OFSECM. SecurityAttribute2 Static Information section.
DIM_DOMAIN3.xlsx Provide the list of all case types and case sub types which are available in OFSECM. SecurityAttribute3 Static Information section.
DIM_DOMAIN4.xlsx Provide the list of all organizations that are available in OFSECM. SecurityAttribute4 Static Information section.
DIM_DOMAIN5.xlsx Provide the list of all scenario classes which are available in OFSECM. SecurityAttribute5 Static Information section.
DIM_COUNTRY.xlsx Provide the list of all countries that need to be made available to the application Country Information section
DIM_STATES.xlsx Provide the list of all states for the countries that need to be made available to the application. State Information section

FCT_TRANSMITTER_INFO.xlsx

 Provide the list of all transmitter Information. Transmitter Information section

DIM_FILING_INST.xlsx

 Provide the list of all filing institution information. Filing Institution Information section

FCT_BRANCH_INFO.xlsx

 Provide the list of all branch information. Branch Information section

FCT_FININST_INFO.xlsx

 Provide the list of all financial institutions. Financial Institution section
DIM_DOMAIN1_TL.xlsx Provide the list of all jurisdictions that are available in OFSECM for language pack. SecurityAttribute1 Static Information section.
DIM_DOMAIN2_TL.xlsx Provide the list of all business domains which are available in OFSECM for language pack. SecurityAttribute2 Static Information section.
DIM_DOMAIN3_TL.xlsx Provide the list of all case types and case sub types which are available in OFSECM for language pack. SecurityAttribute3 Static Information section.
DIM_DOMAIN4_TL.xlsx Provide the list of all organizations that are available in OFSECM for language pack. SecurityAttribute4 Static Information section.
DIM_DOMAIN5_TL.xlsx Provide the list of all scenario classes which are available in OFSECM for language pack. SecurityAttribute5 Static Information section.

FCT_BRANCH_INFO_TL.xlsx

 Provide the list of all branch information for language pack. Branch Information section

DIM_FILING_INST_TL.xlsx

 Provide the list of all filing institution information for language pack. Filing Institution Information section

FCT_TRANSMITTER_INFO_TL.xlsx

 Provide the list of all transmitter Information for language pack. Transmitter Information section

FCT_FININST_INFO_TL.xlsx

 Provide the list of all financial institutions for language pack. Financial Institution section

DIM_EXTRNL_USERS_LIST.xlsx

 Provide the list of all the external users

External User section

NOTE:SYSTEM User must be created with the User ID as 1.

DIM_CRR_REF_DETAIL.xlsx

 Provide the list of all the Source code to CRR reference details.

Source Code to CRR Reference Details. NOTE:

  • For Form of Identification (FOI),the CODE_SET_ID must be DocType
  • For Tin Type, the CODE_SET_ID must be Tin Type.

Add data to each Excel sheet as per your report requirement. For more information, see the Oracle Financial Services Data Model Reference Guide