The following steps enlist the process to upload Solvency Capital Requirements (SCR) data from QMR external flat (HFM Extracted File with calculated SCR and Minimum Capital Requirements (MCR) values) files to respective OIDF tables:
|
NOTE |
The data extracted from HFM must include calculated data. |
1. Verify the SCR (calculated values) Extract Data File from HFM under the defined Oracle Directory DIR_QMR_UPLOAD_FILES
2. Login to the OFSAAI Home page.
3. Select the appropriate Infodom.
4. Navigate to Batch Maintenance in the Operations menu in the left hand side panel.
5. The tasks for OIDF to QMR App Data Extract are bundled under the batch [Infodom_Name]_QMR_OIDF_SCR_Upload.
6. Select the batch checkbox and its corresponding tasks checkbox to edit the parameters for the task.
7. Click the Edit button for Task 1 (QMR_OIDW_ExtFile_Details) and edit its parameter list. Leaving the primary parameters ($RUNID, $PHID, $EXEID, $RUNSK) unchanged, set values for the following parameters.
|
Parameter |
Set Value |
|
$EXT_DIR_NAME=DIR_QMR_UPLOAD_FILES |
Set Oracle Directory where the HFM SCR Extract Data is placed. |
|
$EXT_FILE_NAME=QMR_SCR_Data_2011-QA_LE 01_Extract.dat |
Set the 'HFM SCR Extract Filename' to be processed present under the Oracle Directory. |
8. Replace the parameter list (preceded with the parameter names) in the Task Definition and re-save the Task.
9. Click Edit for Task 2 (QMR_OIDW_SCR_Update) and edit its parameter list.
Leaving the primary parameters ($RUNID, $PHID, $EXEID, $RUNSK) unchanged, set values for the following parameters.
|
Parameter |
Set Value |
|
$QMRDATE=20120101 |
Set the MIS Date for which the QMR data needs to be updated in OIDF in YYYYMMDD Format. |
|
$QMRRUNSK=1 |
Set Run SKey for which the QMR data needs to be updated in OIDF. |
|
$QMRGAAP=IFRS |
Set the GAAP ID for which the QMR data needs to be updated in OIDF. |
10. Replace the parameter list (preceded with the parameter names) in Task Definition and re-save the task.
11. Map the batch or batches to be executed to the user group in UserGroup-Batch Execution Map screen in the Administration menu.
12. Navigate to Batch Execution in the Operations menu in the left hand side panel and select the batch ([Infodom_name]_QMR_OIDF_SCR_Upload) for execution and provide the Information Date from the Calendar dialog box.
13. Execute the Batch.
14. Verify whether the batch is executed successfully by confirming presence of calculated SCR and MCR data in all the relevant tables in OIDF.
