6       Oracle Financial Services Insurance Accounting Analyzer Dashboard Reports

Oracle Financial Services Insurance Accounting Analyzer application includes pre-packaged reports, which cater to disclosure requirements under IFRS 17. It also includes reports, which are created to help management in strategic decisions. All the disclosure reports can be exported to different formats like PDF, CSV, Excel, and so on. All the reports are segregated in the following three Dashboards:

·        Dedicated Disclosure Reports

·        Projection of Contractual Service Margin

·        Analytical Reports and Trend Reports

Dedicated Disclosure Reports

The IFRS 17 guidelines lay specific emphasis on disclosure of key financial data while keeping the scope open on what constitutes an appropriate disclosure. The Application has a range of disclosure reports to track the Movement Analysis, Reconciliations, and Statement of Accounts.

Projection of Contractual Service Margin

The projection of Contractual Service Margin displays the projection as calculated based on the input variables and other parameters to extrapolate the output for the contract duration.

Analytical Reports and Trend Reports

The Analytical and Trend Reports help in identifying the Onerous or Non Onerous contracts for the different legal entities within an organization and other parameters that allow the Management in strategic decision making.

The Dashboards have a set of filters, which allow the users to access the specific information for the reports viewed and reported. The filters are Legal Entity, Reporting Date, Liability Calculation Run, and so on. In addition to the filters, users can view the reports in a specific reporting currency.

Figure 65: The Dashboard Filters

Title: Description of filters.png - Description: This image illustrates the Dashboards that have a set of filters, which allow the users to access the specific information for the reports viewed and reported. The filters are Legal Entity, Reporting Date, Liability Calculation Run, and so on. In addition to the filters, users can view the reports in a specific reporting currency.

List of Oracle Financial Services Insurance Accounting Analyzer Reports

The following are the reports available as part of the Oracle Insurance Accounting Analyzer Release version 8.1.0.0.0.

Disclosure Reports

This section details the disclosure reports that are a part of the Oracle Financial Insurance Accounting Analyzer application.

GMM Liability Analysis

This section details the GMM Liability Analysis reports. It includes Movement Analysis, Reconciliation – Remaining Coverage, Insurance Revenue Details, and Statement of Profit or Loss.

Movement Analysis

Depending on the run that you execute (Normal or Transition), this report provides a detailed analysis of changes or movements in insurance liabilities, during the coverage period of contracts under the General Measurement Model.

Figure 66: The Movement Analysis Report from a Normal Run

Title: Description of the movement analysis report follows - Description: This report provides a detailed analysis of changes/movements in insurance liabilities, during the coverage period of contracts under the General Measurement Model.

Figure 67: The Movement Analysis Report from a Transition Run

Title: Description of the movement analysis report follows - Description: This report provides a detailed analysis of changes/movements in insurance liabilities, during the coverage period of contracts under the General Measurement Model.

Figure 68: The Movement Analysis Report

Title: Description of GMM_MA1.png - Description: This image illustrates the GMM Movement Analysis report that provides a detailed analysis of changes/movements in insurance liabilities, during the coverage period of contracts under the General Measurement Model.

Reconciliation- Remaining Coverage

Depending on the run that you execute (Normal or Transition), this report helps in reconciling the data derived from the calculation of CSM or net liability under the General Measurement Model.

Figure 69: The Reconciliation – Remaining Coverage Report from a Normal Run

Title: Description of the Reconcilation - Remaining Coverage Report follows - Description: This report helps in reconciling the data derived from the calculation of CSM/net liability under the General Measurement Model.

Figure 70: The Reconciliation – Remaining Coverage Report from a Transition Run

Title: Description of the Reconcilation - Remaining Coverage Report follows - Description: This report helps in reconciling the data derived from the calculation of CSM/net liability under the General Measurement Model.

Insurance Revenue Details

This report helps in reconciling the data derived from the calculation of CSM or net liability under the General Measurement Model.

Figure 71: The Insurance Revenue Details Report

Title: Description of GMM_IRD.png - Description: This image illustrates the Insurance Revenue Details report that helps in reconciling the data derived from the calculation of CSM/net liability under the General Measurement Model.

Statement of Profit or Loss

This report displays the profit and losses that are generated by insurance services and investments for a selected reporting period.

Figure 72: The Statement of Profit or Loss Report

Title: Description of GMM_SPL.png - Description: This image illustrates the Statement of Profit or Loss report that displays the profit and losses that are generated by insurance services and investments for a selected reporting period.

VFA Liability Analysis

This section details the VFA Liability Analysis reports. It includes Movement Analysis, Reconciliation – Remaining Coverage, and Statement of Profit or Loss.

Movement Analysis

Depending on the run that you execute (Normal or Transition), this report provides a detailed analysis of changes or movements in insurance liabilities, during the coverage period of contracts under Variable Fee Model.

Figure 73: The Movement Analysis Report from a Normal Run

Title: Description of the Movement Analysis Report follows - Description: This report provides a detailed analysis of changes/movements in insurance liabilities, during the coverage period of contracts under Variable Fee Model.

Figure 74: The Movement Analysis Report from a Transition Run

Title: Description of the Movement Analysis Report follows - Description: This report provides a detailed analysis of changes/movements in insurance liabilities, during the coverage period of contracts under Variable Fee Model.

Reconciliation – Remaining Coverage

Depending on the run that you execute (Normal or Transition), this report helps in reconciling the data derived from the calculation of liability under VFA.

Figure 75: The Reconciliation – Remaining Coverage Report from a Normal Run

Title: Description of the Reconcilation - Remaining Coverage report follows - Description: This report helps in reconciling the data derived from the calculation of liability under VFA.

Figure 76: The Reconciliation – Remaining Coverage Report from a Transition Run

Title: Description of the Reconcilation - Remaining Coverage report follows - Description: This report helps in reconciling the data derived from the calculation of liability under VFA.

Statement of Profit or Loss

This report displays the profit and losses that are generated by insurance services and investments for a selected reporting period.

Figure 77: The Statement of Profit or Loss Report

Title: Description of VFA_SPL.png - Description: This image illustrates the Statement of Profit or Loss report that displays the profit and losses that are generated by insurance services and investments for a selected reporting period.

PAA Liability Analysis

This section details the PAA Liability Analysis reports. It includes Movement Analysis, Liability Analysis, Liability For Incurred Claims, and Statement of Profit or Loss.

Movement Analysis

Depending on the run that you execute (Normal or Transition), this report provides a detailed analysis of changes or movements in insurance liabilities and transitionary balance, during the coverage period of contracts under the Premium Allocation Approach.

Figure 78: The Movement Analysis Report from a Normal Run

Title: Description of PAA_MA_T.png - Description: This image illustrates the PAA Movement Analysis report that provides a detailed analysis of changes/movements in insurance liabilities and transitionary balance, during the coverage period of contracts under Premium Allocation Approach.

Figure 79: The Movement Analysis Report from a Transition Run

Title: Description of PAA_MA_T.png - Description: This image illustrates the PAA Movement Analysis report that provides a detailed analysis of changes/movements in insurance liabilities and transitionary balance, during the coverage period of contracts under Premium Allocation Approach.

Liability Analysis

Depending on the run that you execute (Normal or Transition), this report provides a detailed analysis of changes or movements in insurance liabilities and transitionary balance during the coverage period of the contract, under the Premium Allocation approach.

Figure 80: The Liability Analysis Report from a Normal Run

Title: Description of PAA_LA_T.png - Description: This image illustrates the PAA liabality analysis report that provides a detailed analysis of changes/movements in insurance liabilities and transitionary balance during the coverage period of the contract, under the Premium Allocation approach.

Figure 81: The Liability Analysis Report from a Transition Run

Title: Description of PAA_LA_T.png - Description: This image illustrates the PAA liabality analysis report that provides a detailed analysis of changes/movements in insurance liabilities and transitionary balance during the coverage period of the contract, under the Premium Allocation approach.

Liability For Incurred Claims

This report provides details on the liability for incurred claims under the Premium Allocation Approach.

Figure 82: The Liability For Incurred Claims Report

Title: Description of PAA_LA_LIC.png - Description: This image illustrates the Liability For Incurred Claims report that provides details on the liability for incurred claims under the Premium Allocation Approach.

Statement of Profit or Loss

This report displays the revenue and expenses which are generated by insurance services and investment in the reporting period. This is taken forward to the Profit and Loss statement under the Premium Allocation approach.

Figure 83: The Statement of Profit or Loss Report

Title: Description of PAA_LA_SPL.png - Description: This image illustrates the Statement of Profit or Loss report that displays the revenue and expenses which are generated by insurance services and investment in the reporting period. This is taken forward to Profit and Loss statement under the Premium Allocation approach.

CSM Projection Trend

This section details the CSM Projection report.

CSM Projection

This report displays the reports CSM or Loss Projection for the future period in tabular as well as graphical format.

Figure 84: The CSM Projection Report

Title: Description of CSM.png - Description: This image illustrates the CSM Projection report that displays the reports CSM/Loss Projection for the future period in tabular as well as graphical format.

Reinsurance GMM Liability Analysis

This section details the Reinsurance GMM Liability Analysis reports. It includes Reinsurance Movement Analysis, Reinsurance Reconciliation Report, and Reinsurance Financial Statement reports.

Reinsurance Movement Analysis

This report gives a detailed analysis of the present value of future cash flows, risk adjustment, contractual service margin, and reinsurance net flow.

Figure 85: The Reinsurance Movement Analysis Report

Title: Description of RI-GMM1.png - Description: This image illustrates the Reinsurance Movement Analysis report that gives a detailed analysis of the present value of future cash flows, risk adjustment, contractual service margin, and reinsurance net flow.

Reinsurance Reconciliation Report

This report gives a detailed analysis of the liability for remaining coverage, expected recoveries for incurred claims, and reinsurance contract held total for the reinsurance reconciliation reports.

Figure 86: The Reinsurance Reconciliation Report

Title: Description of RI-GMM2.png - Description: This image illustrates the Reinsurance Reconciliation report that gives a detailed analysis of the liability for remaining coverage, expected recoveries for incurred claims, and reinsurance contract held total for the reinsurance reconciliation reports.

Reinsurance Financial Statement

This report gives a detailed analysis of the reinsurance financial statements.

Figure 87: The Reinsurance Financial Statement Report

Title: Description of RI-GMM3.png - Description: This image illustrates the Reinsurance Financial Statement report that gives a detailed analysis of the reinsurance financial statements.

Reinsurance PAA Liability Analysis

This section details the Reinsurance PAA Liability Analysis reports. It includes Reinsurance Held Liability Analysis, Reinsurance Held Liability Analysis Incurred Claims, and Reinsurance Financial Statement reports.

Reinsurance Held Liability Analysis

This report gives a detailed analysis of the liability for remaining coverage.

Figure 88: The Reinsurance Held Liability Analysis Report

Title: Description of PAA-RHLA1.png - Description: This image illustrates the Reinsurance Held Liability Analysis report that gives a detailed analysis of the liability for remaining coverage.

Reinsurance Held Liability Analysis Incurred Claims

This report gives a detailed analysis of the expected recoveries for incurred claims.

Figure 89: The Reinsurance Held Liability Analysis Incurred Claims Report

Title: Description of PAA-RHLA2.png - Description: This image illustrates the Reinsurance Held Liability Analysis Incurred Claims report that gives a detailed analysis of the expected recoveries for incurred claims.

Reinsurance Financial Statement

This report gives a detailed analysis of the reinsurance financial statement.

Figure 90: The Reinsurance Financial Statement Report

Title: Description of PAA-RHLA2.png - Description: This image illustrates the Reinsurance Financial Statement report that gives a detailed analysis of the reinsurance financial statement.

Comparison

This section details the Comparison reports. It includes Movement Analysis, Reinsurance Movement Analysis, Reconciliation Report, and Statement of New Profit or Loss.

Movement Analysis

This report compares the movement analysis of the corresponding direct insurance estimates for a selected method.

Figure 91: The Movement Analysis Report

Title: Description of C-1.png - Description: This image illustrates the Movement Analysis report that compares the movement analysis of the corresponding direct insurance estimates for a selected method.

Reinsurance Movement Analysis

This report compares the liability analysis of the reinsurance held liability analysis with the corresponding direct insurance estimates for a selected method.

Figure 92: The Reinsurance Movement Analysis Report

Title: Description of C-2.png - Description: This image illustrates the Reinsurance Movement Analysis report that compares the liability analysis of the reinsurance held liability analysis with the corresponding direct insurance estimates for a selected method.

Reconciliation Report

This report compares the reconciliation of movement analysis of the direct insurance liability analysis with the corresponding reinsurance held estimates for a selected method.

Figure 93: The Reconciliation Report

Title: Description of C-3.png - Description: This image illustrates the Reconciliation report that compares the reconciliation of movement analysis of the direct insurance liability analysis with the corresponding reinsurance held estimates for a selected method.

Statement of Net Profit and Loss

This report compares the statement of net profit and loss of the direct insurance liability analysis with the corresponding reinsurance held estimates for a selected method.

Figure 94: Statement of Net Profit and Loss Report

Title: Description of C-1.png - Description: This image illustrates the Statement of Net Profit and Loss report that compares the statement of net profit and loss of the direct insurance liability analysis with the corresponding reinsurance held estimates for a selected method.

CSM Projection Trends

This report displays a detailed analysis of the CSM projection trend.

Figure 95: The CSM Projection Trends Report

Title: Description of CSM_PT.png - Description: This image illustrates the CSM Projection Trends report that displayes a detailed analysis of the CSM projection trend.

Management Reports

This section details the Summary of Contract Groups report.

Summary of Contract Groups

This report provides a detailed analysis of the LOB, legal entity, number of contracts, and loss-making contracts at initial recognition for a contract group.

Figure 96: The Summary of Contract Groups Report

Title: Description of LCB1.png - Description: This image illustrates the Summary of Contract Groups report that provides a detailed analysis of the LOB, legal entity, number of contracts, and loss-making contracts at initial recognition for a contract group.

Sub Ledger Reports

This section details the Sub Ledger reports. It includes Ledger Closing Balances and Journals – Event View reports.

Ledger Closing Balances

This report displays the Debit Value and Credit Value for the GL Accounts like Cash, Deferred Acquisition Cost, Insurance Contract Liabilities (BEL, CSM, and RA), and so on.

Figure 97: The Ledger Closing Balances Report

Title: Description of LCB2.png - Description: This image illustrates the Ledger Closing Balances report that displays the Debit Value and Credit Value for the GL Accounts like Cash, Deferred Acquisition Cost, Insurance Contract Liabilities (BEL, CSM, and RA), etc.

Figure 98: The Ledger Closing Balances

Title: Description of LCB2.png - Description: This image illustrates the Ledger Closing Balances report that displays the Debit Value and Credit Value for the GL Accounts like Cash, Deferred Acquisition Cost, Insurance Contract Liabilities (BEL, CSM, and RA), etc.

Journals - Event View

This section details the Journals – Event View report.

Figure 99: The Journals - Event View Report

Title: Description of LCB_Journals1.png - Description: This image illustrates the Journals - Event View report.

Figure 100: The Journals Even View Report

Title: Description of LCB_Journals2.png - Description: This image illustrates the Journals - Event View report.

List of Long Duration Contracts Reports

This section details the list of Long Duration Contracts Reports.

Disclosure Reports

This section details the Disclosure reports for the Long Duration Contracts.

Roll Forward – Premium and Benefits

This report provides a detailed analysis of the present value of the expected net premiums, expected future policy benefits, and the net liability for future policy benefits during the coverage period for long-duration contracts.

Figure 101: The Disclosure of Information about the Liability for Future Policy Benefits LFPB RF Report

Title: Description of LDTI_RF_PB1.png - Description: This image illustrates the Disclosure of Information about the Liability for Future Policy Benefits LFPB RF report that provides a detailed analysis of the present value of the expected net premiums, expected future policy benefits, and the net liability for future policy benefits during the coverage period for long-duration contracts.

Figure 102: The Disclosure of Information about the Liability for Future Policy Benefits LFPB RF Report

Title: Description of LDTI_RF_PB1a.png - Description: This image illustrates the Disclosure of Information about the Liability for Future Policy Benefits LFPB RF report that provides a detailed analysis of the present value of the expected net premiums, expected future policy benefits, and the net liability for future policy benefits during the coverage period for long-duration contracts.

Roll Forward – Commission and Expenses

This section details the Balance of and Changes in Deferred Acquisition Costs DAC RF report.

Balance of and Changes in Deferred Acquisition Costs DAC RF

This report provides a detailed analysis of the deferred acquisition cost of commissions and expenses during the coverage period for long-duration contracts.

Figure 103: The Balance of and Changes in Deferred Acquisition Costs DAC RF Report

Title: Description of LDTI_RF_CE1.png - Description: Thisimage illustrates the Balance of and Changes in Deffered Acquisition Costs DAC RF report that provides a detailed analysis of the deferred acquisition cost of commissions and expenses during the coverage period for long-duration contracts.

Ledger Balances

This section details the Present Value of Expected Net Premium report.

Present Value of Expected Net Premium

This report provides a detailed analysis of the debit and credit values of the GL account for a specific event during the coverage period for long-duration contracts.

Figure 104: The Present Value of Expected Net Premium Report

Title: Description of LDTI_RF_PB1.png - Description: This image illustrates the Present value of expected net premium report that provides a detailed analysis of the debit and credit values of the GL account for a specific event during the coverage period for long-duration contracts.

Figure 105: The Present Value of Expected Net Premium Report

Title: Description of LDTI_RF_PB2.png - Description: This image illustrates the Present value of expected net premium report that provides a detailed analysis of the debit and credit values of the GL account for a specific event during the coverage period for long-duration contracts.

Ledger Closing Balances

This report provides a detailed analysis of the debit and credit values of the GL account during the coverage period for long-duration contracts.

Figure 106: The Ledger Closing Balances Report

Title: Description of LDTI_RF_LB2.png - Description: This image illustrates the Ledger Closing Balances report that provides a detailed analysis of the debit and credit values of the GL account during the coverage period for long-duration contracts.

Figure 107: The Ledger Closing Balances Report

Title: Description of LDTI_RF_LB2a.png - Description: This image illustrates the Ledger Closing Balances report that provides a detailed analysis of the debit and credit values of the GL account during the coverage period for long-duration contracts.

Ledger Balances by Event

This section details the Present Value of Expected Net Premium report.

Present Value of Expected Net Premium

This report provides a detailed analysis of the various value of the net premiums of the GL accounts for a specific event during the coverage period for long-duration contracts.

Figure 108: The Present Value of Expected Net Premium Report

Title: Description of LDTI_RF_LBBE1.png - Description: This image illustrates the Present Value of Expected Net Premium report that provides a detailed analysis of the various value of the net premiums of the GL accounts for a specific event during the coverage period for long-duration contracts.

Figure 109: The Present Value of Expected Net Premium Report

Title: Description of LDTI_RF_LBBE1a.png - Description: This image illustrates the Present Value of Expected Net Premium report that provides a detailed analysis of the various value of the net premiums of the GL accounts for a specific event during the coverage period for long-duration contracts.

Figure 110: The Present Value of Expected Net Premium Report

Title: Description of LDTI_RF_LBBEb.png - Description: This image illustrates the Present Value of Expected Net Premium report that provides a detailed analysis of the various value of the net premiums of the GL accounts for a specific event during the coverage period for long-duration contracts.

Adjustments and Allocations

This section details the Cohort Adjustment report.

Cohort Adjustment

This report provides a detailed analysis of the cohort adjustment for a LOB during the coverage period for long-duration contracts.

Figure 111: The Cohort Adjustment Report

Title: Description of LDTI_RF_AA1.png - Description: This image illustrates the image of the Cohort Adjustment report that provides a detailed analysis of the cohort adjustment for a LOB during the coverage period for long-duration contracts.