4.1 Loading Client-Specific Data

This section explains the steps to load client-specific data into the OFSCRR application.

To load 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 the Configuring OFSAAI_InstallConfig.xml File section in the Oracle Financial Services Analytical Applications Infrastructure User Guide.
  3. Download the following Excel sheets to the Windows machine from the path given in the previous step
    Excel Sheets table describes the table name and reference to the data model.

    Table 4-1

    Excel Sheet Description Reference to the Data Model Reference Guide
    DIM_DOMAIN1.xlsx Providethe list of all Jurisdictions that are available in OFSECM. SecurityAttribute1 Static Information section.
    DIM_DOMAIN2.xlsx Provide the list of all Business Domainsthat are available in OFSECM. SecurityAttribute2 Static Information section.
    DIM_DOMAIN3.xlsx Providethe list of all Case Types and Case SubType available in OFSECM. SecurityAttribute3 Static Information section.
    DIM_DOMAIN4.xlsx Providethe list of all Organizations that are available in OFSECM. SecurityAttribute4 Static Information section.
    DIM_DOMAIN5.xlsx Providethe list of all Scenario Classes that are available in OFSECM. SecurityAttribute5 Static Information section.
    DIM_COUNTRY.xlsx Providethe list of all Countries that need to be made available to the application CountryInformation section
    DIM_STATES.xlsx Providethe list of all states for the countries that need to be made available to the application. StateInformation section

    DIM_REPORTING_ENTI-

    TY_LOC.xlsx

    		 Providethe list of all reporting entity location. ReportingEntity Location section

    DIM_REPORTING_ENTI-

    TY_DTLS.xlsx

    		 Providethe list of all reporting entities. ReportingEntity Details section
    DIM_REPORTING_PERSON.xlsx Providethe list of all reporting per- sons. ReportingPerson Information section
    DIM_TRXN_LOC_INFO.xlsx Providethe list of all branches. BranchInformation section

    MAP_REPENTITYDTLS_REP-

    TYPE.xlsx

    		 Provide the list of all mapping for reportingentity and CA-STR report type. ReportingEntity Details section

    MAP_REPENTITYLOC_REP-

    TYPE.xlsx

    		 Provide the list of all mapping for branches/reportingentity location and CA-STR report type. Reporttype Information section

    MAP_TRXNLOC_ENTITY-

    DTLS.xlsx

    		 Providethe list of all mapping for reporting entity and branches/ reporting entity location. Reportentity Information section.

    MAP_REPPERSON_REPTYPE.xls

    x

    		 Provide the list of all mapping for reportingperson and CA-STR report type. Reportperson type Information section.
    MAP_ENTITY_DTLS_LOC.xlsx Provide the list of all mapping for reportingentity, entity location and CA-STR report type. Reportentity location Information section.
    MAP_REP_NTITY_REP_PERSON Provide the listof all mappings for reporting entity and reporting per- son with priority. Reportentity Information section.
    DIM_CRR_REF_DETAIL.xlsx Providethe list of all the Source code to CRR reference details.

    SourceCode to CRR Reference Details

    This allows you to map the ECM Code to CRR based on the code set ID.

    For Ministerial Directive, a label or tag configured in ECM has to be provided in the source code.

    Note:

    • The column N_PRNT_REPENTY_SKEY in DIM_REPORTING_ENTI- TY_DTLS table is used to capture the parent reporting entity skey value.
    • If your reporting entity does not have parent reporting entity, then do not enter any value in this column.
    • In case, an incorrect value is provided, the reporting entity information will not be populated in the E-File batch header, which may lead to the rejection of report by regulator.
    • The column F_DEFAULT_FL in MAP_REP_NTITY_REP_PERSON table is used to capture the default mapping of the reporting person to the reporting entity. The value =Y indicates the default value.
    • To populate data in the Reporting Entity's Identifier Number, provide value in V_FIA_ID in the dim_reporting_entity_dtls table and N_REPTYPE_SKEY in MAP_REPENTITYDTLS_REPTYPE.
  4. Add data in each Excel sheet as per your report requirement. For more information, see the Oracle Financial Services Data Model Reference Guide