Overview

Oracle Insurance Data Foundation (OIDF) stores insurance specific data of an Insurance Company covering wide range of functions such as underwriting, policy, premium, claim, risk numbers, valuations, and risk reporting.

QMR is a Quantitative Management Reporting application from Oracle. QMR is a Hyperion Financial Management (HFM) based application and is used for Solvency II regulatory reporting. QMR produces highly formatted Quantitative Reporting Template (QRT) based reports as specified by European Insurance and Occupational Pensions Authority (EIOPA).

QMR integration refers to data flow between System Source (SS) of OIDF and QMR application. OIDF consists of staging and reporting area tables. This integration is between result data model and QMR.

The base data from source systems resides in OIDF staging area. From there, it moves to the OIDF processing area. The data is then processed and moved into the OIDF results area.

Data flow between QMR and OIDF is a two way process:

1.      Data is extracted from OIDF using this interface and uploaded into the QRM 2.0.0.0.0 application. The application QMR 2.0.0.0.0 is then used to generate QRT based reports.

2.      SCR numbers calculated in QMR will then be ported back into OIDF.