Oracle® Quantitative Management and Reporting for Solvency II Readme

Release 2.0.0

Release 2.0.0. 1

Purpose. 1

New Features. 1

Supported Format and Releases. 2

Supported Format 2

Supported Releases. 2

Supported Platforms. 2

HFM Registry Settings. 2

Consolidation logic 2

Sparse Data Entry Forms 3

File List 3

Installation Updates. 10

Known Issues. 10

Language support – Localization. 10

Data Entry Form display in HFM 11.1.2.2. 10

14401347 - "COVER" (A1A, A1Q) SCHEDULES SHOULD SUPPORT I/C ENTRY FOR GROUP REPORTING. 11

14594093 - API USED TO DISPLAY PDF REPORTS DOES NOT FUNCTION PROPERLY. 11

Defects Fixed and other Updates in This Release. 11

Documentation Updates. 11

More Information. 11

 

Purpose

This document includes important, late-breaking information about this release of Oracle Quantitative Management and Reporting for Solvency II (QMR) for Financial Close Suite 11.1.2.1 and for Financial Close Suite 11.1.2.2.

New Features

This is the second release of Oracle Quantitative Management and Reporting for Solvency II, designed to meet the QRT reporting requirements defined in the November 2011 EIOPA Consultation Pack.

Supported Format and Releases

Supported Format

The current version of QMR is built using the “Classic” files and not using EPMA or Calc Manager.

Supported Releases

The application has been developed and tested on Financial Close Suite 11.1.2.1 and Financial Close Suite 11.1.2.2. Other versions of the Close Suite are not supported.

The following FCM Patch Set Update must be applied:

-      FCM 11.1.2.1: PSU: 11.1.2.1.103

The following Financial Reporting Patch Set Update must be applied:

-      FR 11.1.2.1: PSU: 11.1.2.1.124

-      FR 11.1.2.2: PSU: 11.1.2.2.300

The following HFM Patch Set Update must be applied:

-      HFM 11.1.2.1: PSU: 11.1.2.1.104

-      HFM 11.1.2.2: PSU: 11.1.2.2.301 plus PSE 14593265

Supported Platforms

This release applies to all supported platforms.

To ensure that data entry forms display correctly in 11.1.2.2, please ensure that Internet Explorer 8 compatibility settings are turned off.

HFM Registry Settings

Consolidation logic

Based on the requirement to copy data from base entity to base entity during the consolidation process, it may be necessary to run a consolidation more than once in order to obtain an OK status at the top entity member. A registry change can reduce the number of consolidations required.

The revised logic will allow the recalculation of a base entity multiple times within a single consolidation process should the calculation status not be OK after each iteration of calculation. This will resolve a situation in which an Impact Status rule running from one entity impacts another entity that had already been calculated.

A default registry setting must be changed to enable the alternative consolidation logic. To check / edit the registry setting:

·         Use RegEdit to modify the registry key: MaxNumRetriesOfBaseLevelCalculation in path:

HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Financial Management\Server \

·         If this key exists, change the value to a positive integer (e.g. 1, 2, 3 etc.). The integer indicates the maximum number of additional calculations permitted. A zero or negative number will retain the existing default behaviour. A larger number will be more likely to result in an OK status but may cause performance degradation. A setting of 1 should be sufficient for the QMR application. The registry change must be performed on every Application Server. If this registry key does not exist, use RegEdit to add the key as a new DWORD.

Sparse Data Entry Forms

A formatting issue in HFM 11.1.2.1 has been noted as a result of the design of some Data Entry Forms.

A default registry setting must be changed to correct the formatting. To check / edit the registry setting:

·         Use RegEdit to modify the registry key: WDEFSparseRetrieval in path:

HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Financial Management\Server \

·         If this key exists, change the value to zero (0). The registry change must be performed on every Application Server. If this registry key does not exist, use RegEdit to add the key as a new DWORD.

File List

All files required to build the Oracle Quantitative Management and Reporting for Solvency II application are included in this release. Note that the HFM Profile/Calendar, Metadata and Data Entry Form files plus the FDM XML file are different for FCS 11.1.2.1 and FCS 11.1.2.2. All other files are identical. Please ensure that the files for the correct FCS version are used.

01 HFM CALENDAR PROFILE

-      QMR_Profile_2.0.0_EN.per

-      QMR_Profile_2.0.0_EN_DE_ES_FR_NL.per

02 HFM METADATA

-      QMR_Metadata_2.0.0_EN.xml

-      QMR_Metadata_2.0.0_EN_DE_ES_FR_NL.xml

03 HFM MEMBER LISTS

-      QMR_MemberLists_2.0.0.lst

04 HFM RULES

-      QMR_Rules_2.0.0.rle

05 HFM DATA ENTRY FORMS

-      QMR200Forms.zip

01_Configuration_Global

MCR_SetupUndertakingTypeGlobal.wdf

SCR_SetupAuthorizedModel.wdf

SCR_SetupPartialAndInternalModel.wdf

02_Configuration_Local

MCR_SetupUndertakingType.wdf

SCR_Simplification.wdf

03_Admin_Global

ExchangeRatesEntry.wdf

SCRCorr_BasicSCRGlobal.wdf

SCRCorr_CtrPtyRiskGlobal.wdf

SCRCorr_CtrPtyType1RiskGlobal.wdf

SCRCorr_EquityRiskGlobal.wdf

SCRCorr_GeoDiversificationPreset.wdf

SCRCorr_HealthCatastropheRiskGlobal.wdf

SCRCorr_HealthNSLTPremResRiskGlobal.wdf

SCRCorr_HealthNSLTUWriteRiskGlobal.wdf

SCRCorr_HealthSLTUWriteRiskGlobal.wdf

SCRCorr_HealthUWriteRiskGlobal.wdf

SCRCorr_InternalModelGlobal.wdf

SCRCorr_LifeUWriteRiskGlobal.wdf

SCRCorr_MarketRiskDownGlobal.wdf

SCRCorr_MarketRiskGlobal.wdf

SCRCorr_MarketRiskUpGlobal.wdf

SCRCorr_NonLifeCatCreditRiskGlobal.wdf

SCRCorr_NonLifeCatEarthquakeRiskGlobal.wdf

SCRCorr_NonLifeCatFloodRiskGlobal.wdf

SCRCorr_NonLifeCatHailRiskGlobal.wdf

SCRCorr_NonLifeCatLiabilityRiskGlobal.wdf

SCRCorr_NonLifeCatManMadeRiskGlobal.wdf

SCRCorr_NonLifeCatMarineRiskGlobal.wdf

SCRCorr_NonLifeCatNaturalRiskGlobal.wdf

SCRCorr_NonLifeCatOtherRiskGlobal.wdf

SCRCorr_NonLifeCatRiskGlobal.wdf

SCRCorr_NonLifeCatWindstormRiskGlobal.wdf

SCRCorr_NonLifePremResRiskGlobal.wdf

SCRCorr_NonLifeUWriteRiskGlobal.wdf

SCRCorr_PartIntModelGlobal.wdf

SCRCorr_StdAndPartIntModelGlobal.wdf

04_Admin_Local

SCRCorr_BasicSCR.wdf

SCRCorr_CtrPtyRisk.wdf

SCRCorr_CtrPtyType1Risk.wdf

SCRCorr_EquityRisk.wdf

SCRCorr_HealthCatastropheRisk.wdf

SCRCorr_HealthNSLTPremResRisk.wdf

SCRCorr_HealthNSLTUWriteRisk.wdf

SCRCorr_HealthSLTUWriteRisk.wdf

SCRCorr_HealthUWriteRisk.wdf

SCRCorr_LifeUWriteRisk.wdf

SCRCorr_MarketRisk.wdf

SCRCorr_MarketRiskDown.wdf

SCRCorr_MarketRiskUp.wdf

SCRCorr_NonLifeCatCreditRisk.wdf

SCRCorr_NonLifeCatEarthquakeRisk.wdf

SCRCorr_NonLifeCatFloodRisk.wdf

SCRCorr_NonLifeCatHailRisk.wdf

SCRCorr_NonLifeCatLiabilityRisk.wdf

SCRCorr_NonLifeCatManMadeRisk.wdf

SCRCorr_NonLifeCatMarineRisk.wdf

SCRCorr_NonLifeCatNaturalRisk.wdf

SCRCorr_NonLifeCatOtherRisk.wdf

SCRCorr_NonLifeCatRisk.wdf

SCRCorr_NonLifeCatWindstormRisk.wdf

SCRCorr_NonLifePremResRisk.wdf

SCRCorr_NonLifeUWriteRisk.wdf

10_FS

01_FS_1.wdf

02_Non_Insurance.wdf

11_BS

00_Assets_Summary.wdf

01_BS_C1.wdf

02_BS_C1B.wdf

03_BS_C1D.wdf

12_Cover

01_Country_K1.wdf

02_Cover_A1A_NonLife.wdf

03_Cover_A1A_Life.wdf

04_Cover_A1Q_NonLife.wdf

05_Cover_A1Q_Life.wdf

13_OF

01_OF_B1_SQ.wdf

02_OF_B1_SA.wdf

03_OF_B1_GQ.wdf

04_OF_B1_GA.wdf

05_OF_B1_NonAvail.wdf

06_OF_B1_NonAvail_Solo_DataEntry.wdf

15_SCR

01_SCR_B2A.wdf

02_SCR_B2B.wdf

03_SCR_B2C.wdf

11_SCR_B3A.wdf

12_SCR_B3B.wdf

13_SCR_B3C.wdf

14_SCR_B3D.wdf

15_SCR_B3E.wdf

16_SCR_B3F.wdf

17_SCR_B3G.wdf

16_MCR

01_MCR_B4.wdf

17_TP

01_TP_F1Q_Life.wdf

02_TP_F1Q_Health.wdf

03_TP_F1_Life.wdf

04_TP_F1_Health.wdf

05_TP_F2.wdf

06_TP_F4.wdf

11_TP_E1Q.wdf

12_TP_E1.wdf

13_TP_E1_Additional.wdf

14_TP_E2.wdf

15_TP_E3.wdf

16_TP_E4.wdf

17_TP_E6.wdf

18_TP_E7A.wdf

19_TP_E7B.wdf

18_Re

01_Re_J1_NonLife.wdf

01_Re_J1_NonLife_DataEntry.wdf

02_Re_J1_Life.wdf

02_Re_J1_Life_DataEntry.wdf

03_Re_J2.wdf

03_Re_J2_DataEntry.wdf

04_Re_J3.wdf

04_Re_J3_DataEntry.wdf

05_Re_SPV.wdf

05_Re_SPV_DataEntry.wdf

21_Group

01_Group_G01.wdf

02_Group_G03.wdf

02_Group_G03_DataEntry.wdf

03_Group_G04.wdf

03_Group_G04_DataEntry.wdf

04_Group_G14.wdf

05_Group_G20.wdf

97_Validation_Global

SCRCorr_ValidateGlobal.wdf

SCRCorr_ValidateTableGlobal.wdf

98_Validation_Local

01_Validations.wdf

02_Validations_DataEntry.wdf

03_Validations_BS.wdf

04_Validations_OF.wdf

SCRCorr_Validate.wdf

SCRCorr_ValidateTable.wdf

99_System

BS_C1B_Collateral.wdf

BS_C1B_Contingencies.wdf

BS_C1B_Details_Contingencies.wdf

BS_C1B_Details_Guarantees.wdf

BS_C1B_Guarantees.wdf

BS_C1D_Currency.wdf

BS_C1D_ICDetails.wdf

BS_C1_ICDetails.wdf

BS_C1_ICParticipations.wdf

Country_K1_Countries.wdf

Cover_A1A_Life_Countries.wdf

Cover_A1A_NonLife_Countries.wdf

Group_G01_Details.wdf

Group_G14_Details.wdf

Group_G20_Details.wdf

MCR_ICDetails_CapAtRisk.wdf

MCR_ICDetails_Prov.wdf

MCR_ICDetails_ProvPrem.wdf

OF_B1_Details_Ancillary.wdf

OF_B1_Details_Ancillary_Group.wdf

OF_B1_Details_PrefShares.wdf

OF_B1_Details_PrefShares_Group.wdf

OF_B1_Details_RFF.wdf

OF_B1_Details_SubLiabilities.wdf

OF_B1_Details_SubLiabilities_Group.wdf

OF_B1_Details_SubMutual.wdf

OF_B1_Details_SubMutual_Group.wdf

OF_B1_Flows_Ancillary.wdf

OF_B1_Flows_Ancillary_Group.wdf

OF_B1_Flows_InitialFunds.wdf

OF_B1_Flows_OrdShares.wdf

OF_B1_Flows_OtherItems.wdf

OF_B1_Flows_OtherItems_Group.wdf

OF_B1_Flows_PrefShares.wdf

OF_B1_Flows_PrefShares_Group.wdf

OF_B1_Flows_SubLiabilities.wdf

OF_B1_Flows_SubLiabilities_Group.wdf

OF_B1_Flows_Tiers.wdf

OF_B1_Trans_Ancillary.wdf

OF_B1_Trans_Ancillary_Group.wdf

OF_B1_Trans_OtherItems.wdf

OF_B1_Trans_OtherItems_Group.wdf

OF_B1_Trans_PrefShares.wdf

OF_B1_Trans_PrefShares_Group.wdf

OF_B1_Trans_SubLiabilities.wdf

OF_B1_Trans_SubLiabilities_Group.wdf

OF_B1_Trans_SubMutual.wdf

OF_B1_Trans_SubMutual_Group.wdf

SCR_B2A_CapAddOns.wdf

SCR_B3D_StdDev.wdf

SCR_B3D_Vol.wdf

SCR_B3E_StdDev.wdf

SCR_B3E_Vol.wdf

SCR_B3F_CatHealth.wdf

SCR_B3F_CatHealthAccidentConc.wdf

SCR_B3F_CatHealthMassAccident.wdf

SCR_B3F_CatHealthPandemic.wdf

SCR_B3F_CatManMade.wdf

SCR_B3F_CatManMadeCredit.wdf

SCR_B3F_CatManMadeLiability.wdf

SCR_B3F_CatManMadeMarine.wdf

SCR_B3F_CatNat.wdf

SCR_B3F_CatNatReins.wdf

SCR_B3F_CatNonLife.wdf

SCR_B3F_CatOther.wdf

SCR_B3x_VolGeoDiv.wdf

SCR_CapChg_ICDetails.wdf

TP_E1_Geo.wdf

TP_E6_Details.wdf

TP_E7A_Details.wdf

TP_E7B_Details.wdf

TP_F1_Health_Geo.wdf

TP_F1_Life_Geo.wdf

 

06 FINANCIAL REPORTS

-      QMR200FinancialReports.zip

Containing

11_BS

BS-C1.des

BS-C1B.des

BS-C1D.des

12_Cover

Country-K1.des

Cover-A1A-Life.des

Cover-A1A-NonLife.des

Cover-A1Q-Life.des

Cover-A1Q-NonLife.des

13_OF

OF-B1-Group-Detail-01.des

OF-B1-Group-Detail-02.des

OF-B1-Group-Detail-03.des

OF-B1-Group-Detail-04.des

OF-B1-Group-Detail-05.des

OF-B1-Group-Detail-06.des

OF-B1-Group-Detail-07.des

OF-B1-Group-Detail-08.des

OF-B1-Group-Detail-09.des

OF-B1-Group-Detail-10.des

OF-B1-Group-Detail-11.des

OF-B1-Group-Summary.des

OF-B1-Solo-Detail-01.des

OF-B1-Solo-Detail-02.des

OF-B1-Solo-Detail-03.des

OF-B1-Solo-Detail-04.des

OF-B1-Solo-Detail-05.des

OF-B1-Solo-Detail-06.des

OF-B1-Solo-Detail-07.des

OF-B1-Solo-Detail-08.des

OF-B1-Solo-Detail-09.des

OF-B1-Solo-Detail-10.des

OF-B1-Solo-Summary.des

15_SCR

SCR-B2A.des

SCR-B2B.des

SCR-B2C.des

SCR-B3A.des

SCR-B3B.des

SCR-B3C.des

SCR-B3D.des

SCR-B3E.des

SCR-B3F-1.des

SCR-B3F-2.des

SCR-B3F-3.des

SCR-B3F-4.des

SCR-B3G.des

16_MCR

MCR-B4.des

17_TP

TP-E1.des

TP-E1Q.des

TP-E2.des

TP-E3.des

TP-E4.des

TP-E6.des

TP-E7A.des

TP-E7B.des

TP-F1-Health.des

TP-F1-Life.des

TP-F1Q-Health.des

TP-F1Q-Life.des

TP-F2.des

TP-F4.des

18_Re

Re-J1-Life.des

Re-J1-NonLife.des

Re-J2.des

Re-J3.des

Re-SPV.des

21_Group

G01.des

G03.des

G04.des

G14.des

G20.des

07 FCM

-      QMR_2.0.0_FCM_DE.csv

-      QMR_2.0.0_FCM_EN.csv

-      QMR_2.0.0_FCM_ES.csv

-      QMR_2.0.0_FCM_FR.csv

-      QMR_2.0.0_FCM_NL.csv

08 FDM

-      QMR_FDM_2.0.0.xml

09 TEST DATA

FDM

QMR_200_TestData_Group_IGT1.txt

QMR_200_TestData_Group_IGT2.txt

QMR_200_TestData_Group_IGT3.txt

QMR_200_TestData_Group_IGT4.txt

QMR_200_TestData_Group_RC.txt

QMR_200_TestData_LE01_Assets_D1.txt

QMR_200_TestData_LE01_Assets_D1S.txt

QMR_200_TestData_LE01_Assets_D2O.txt

QMR_200_TestData_LE01_Assets_D2T.txt

QMR_200_TestData_LE01_Assets_D3.txt

QMR_200_TestData_LE01_Assets_D4.txt

QMR_200_TestData_LE01_Assets_D5.txt

QMR_200_TestData_LE01_Assets_D6.txt

QMR_200_TestData_LE01_TP_F3.txt

QMR_200_TestData_LE01_TP_F3A.txt

QMR_200_TestData_LE01_TP_F3B.txt

HFM

QMR_200_EIOPAData2011QA.dat

QMR_200_GlobalData2011QA.dat

QMR_200_TestData2011QA_Group.dat

QMR_200_TestData2011QA_LE01.dat

QMR_200_TestData2011QA_LE01RFF1.dat

QMR_200_TestData2011QA_LE01RFF2.dat

QMR_200_TestData2011QA_LE02.dat

QMR_200_TestData2011QA_LE03.dat

QMR_200_TestData2011QA_LE05.dat

QMR_200_TestData2011QA_LE08.dat

QMR_200_TestData2011QA_LE09.dat

10 HFM LOCALIZATION

-      QMR_Metadata_Localization_2.0.0_DE.txt

-      QMR_Metadata_Localization_2.0.0_ES.txt

-      QMR_Metadata_Localization_2.0.0_FR.txt

-      QMR_Metadata_Localization_2.0.0_NL.txt

11 DOCUMENTATION

-      QMR_AdminUserGuide_2.0.0.pdf

-      QMR_ImplementationGuide_v2.0.0.pdf

Installation Updates

This release of Oracle Quantitative Management and Reporting for Solvency II is version 2.0.0. As new updates are released, only the most recent version will be supported. Any changes to the standard application files must be applied to client applications in order to remain supported.

To identify changes to the Member Lists or Rules file, search the file for the defect or enhancement number noted at the top of the file under “Change Control History”. Changes to Web Data Entry Forms are similarly annotated. Changes to Financial Reports are noted in a hidden grid at the bottom of the report (the change history can be viewed by editing the report in Financial Reporting Studio and viewing the contents of the hidden grid).

It is recommended that any client changes to these files be similarly annotated to facilitate the merging of Oracle Quantitative Management and Reporting for Solvency II file updates and client modifications.

Known Issues

The following issues are the noteworthy known issues of this release.

Language support – Localization

The HFM application metadata and rules messages, FCM Task Lists and FDM reports have been translated from English (EN) to German (DE), Spanish (ES), French (FR) and Dutch (NL). Last minute changes to some English description strings may not yet be translated. These descriptions will default to English.

A localization utility has been created for HFM that will update the HFM metadata descriptions based on the localization/translation files provided with the application. Corrections or additions to metadata descriptions can be made through these files and re-applied to the metadata file through the use of the utility. For further details, please refer to the QMR Implementation Guide and the Localization Utility User guide.

Due to the technical nature of the metadata descriptions, the translated descriptions may not be correct in the context in which they are used. Should any incorrect usage be noted, a Localization bug can be raised through Oracle Support for correction is a subsequent release. In the short term, the Localization Utility or direct changes to the metadata file can be applied to make immediate corrections.

Data Entry Form display in HFM 11.1.2.2

There are a number of data entry form display issues in HFM 11.1.2.2. Some issues are isolated to Internet Explorer 8 so Firefox or Internet Explorer 9 are preferred options. It is expected that all remaining data form display issues will be resolved in HFM 11.1.2.2.302 for all supported browsers. 

14401347 - "COVER" (A1A, A1Q) SCHEDULES SHOULD SUPPORT I/C ENTRY FOR GROUP REPORTING

Currently the A1A and A1Q schedules do not support intercompany data entry required for Group reporting.

14594093 - API USED TO DISPLAY PDF REPORTS DOES NOT FUNCTION PROPERLY

In FDM 11.1.2.2, the import Validation report that details any errors in the source data for the Assets, Technical Provisions, IGT or Risk Concentration schedules will not display automatically on completion of the import. The report can however be opened manually.

Defects Fixed and other Updates in This Release

No defects have been fixed in this release of Oracle Quantitative Management and Reporting for Solvency II.

Documentation Updates

For guidance on implementing and using Oracle Quantitative Management and Reporting for Solvency II, please refer to the Implementation Guide (QMR_ImplementationGuide_2.0.0.pdf) and the Admin / User Guide (QMR_AdminUserGuide_2.0.0.pdf).

Periodic updates to the documentation for Oracle Quantitative Management and Reporting for Solvency II will be available for downloading or viewing from the EPM System Documentation area of the OTN Web site (http://www.oracle.com/technology/documentation/epm.html).

More Information

For more information about Oracle® Financial Close Suite. please see the relevant product documentation.

 

 

Copyright © 2012, Oracle and / or its affiliates. All rights reserved.
http://www.oracle.com