What’s New

20 minute read

Accounting General

SE-3493 - Add column ‘Section’ to Deposit Ledger Detail Pairing screen - Allianz AG

Aim of function

Add Section as a new column on the create detail pairing window from the business ledger. This enhancement will help the user to correctly identify and pair the details on the basis of match (i.e. Sections, Accounting Classification and Underwriting Year), thus avoids incorrect/duplicate pairing.

 
System Parameters Affected

n/a

 

Existing functionality affected

Create Detail Pairing from the Business Ledger, either from the Cash Claim tab, Premium Due Later tab, Deposits tab or Non-Liquid Deposits tab

BusinessLedgerCreateDetailPairing.PNG

SE-3566 - Pairing Booking Year and Period in Business Partner Ledger - Allianz AG

Aim of function

Adding the Pairing BYR and Pairing BP columns in Business partner ledger.

Adding option to select Pairing BYR and Pairing BP as a selection parameter under Additional Criteria on Business Partner Ledger.

It is more convenient to view the Pairing BYR and Pairing BP in the business partner ledger itself instead of going inside balance pairing properties to view.

Additional criteria will filter out only the selectin range of period.

This will reduce time and energy to view pairing BYR and BP details.

BPLedger_AdditionalCriteriaTab3.PNG

System Parameters Affected

None

Existing functionality affected

Retrieve and inspect balances on Business Partner Ledger

The web service retrieveBalancesForBusinessPartner in the entry point SicsWsCommonAccountingEntryPoint

SE-488 - Split the Reserve/Portfolio flag on REAC - Lusitania Seguros

Aim of function

When running the Retrocession Calculation order, to ensure that no Portfolio is booked until running the ‘final’ account for the last Account of the Insured Period.

The tick box Reserves/Portfolios has been split into two boxes; Reserves and Portfolios in the Items Included area on the Retrocession Calculation order, Retrocession Calculation Estimation order and Retrocession Calculation Group order.

ItemsIncluded_RetrocessionCalcOrder.PNG

System Parameters Affected

None

Existing functionality affected

Creating and Running Retrocession Calculation Order

Creating and Running Retrocession Estimation Calculation Order

Creating and Running Retrocession Calculation Group Order

SE-3923 - Web-Service for Pairing annulment - Swiss Re Zurich

Aim of function

To be able to annul a balance pairing through web service with the same result as if it is done manually

System Parameters Affected

None

Existing functionality affected

Balance pairing/annulling in Business Partner Ledger

SE-4053 - Government Tax Validation Step 2 - Swiss Re Zurich

Aim of function

The aim of the function is to introduce a more flexible tax calculation than today due to each country has its own tax requirements which need to be applied. Possible to automatically book and validate Government Tax details for Assumed Businesses based on a new Government Tax Table and to manually/automatically link details (e.g. Premium and Government Tax on Premium)

Possible to split balances including ordinary details like premium and claim and Government Tax Target Entry Codes.

System Parameters Affected

Two new Accounting system parameter are introduced;

  • ‘Government Tax Framework in use’ to activate the new Government Tax functionality.
  • ‘Government Tax Table’ to define various rules for what to be booked and validated

Existing functionality affected

  • The existing VAT functionality is disabled when the new system parameter ‘Government Tax Framework in use’ is activated

Business

SE-4084 - Complete Segregation per Base Company - Remaining - Aon

Aim of function

Often organizations have several (re)insurance companies sharing the same SICS installation.  These are legal entities and might not wish to have knowledge of each other, neither each other’s existence, nor each other’s business administration.  To support this, SICS offers an extensive base company segregation facility, which has a high number of features throughout SICS.  This makes it possible to, for example, let the user see only business (claims, accounting, etc.) of his/her assigned Current Base Company. 

In addition to the currently existing functions within base company segregation, some more features  have been added.  For example, it now offers a better support of Viewing Recents (e.g. see Businesses worked on over the last 7 days), assigning protected business, creating new business, assigning business partners and task management. 

image-2020-09-05-17-07-24-522.png

  recents.png

 System Parameters Affected

System Parameter / Database and Systems:  Extend Base Company Segregation

System Parameter / Database and Systems:  Hide Insureds

System Parameter / Database and Systems:  Hide Business Partners 

System Parameter / Database and Systems:  Hide Base Companies 

Existing functionality affected

View Recents

Assign Protected Assumed Businesses

Create New Business

Maintain Business Partner Roles

Maintain Technical Worksheets by Task Management

Changed documentation

database_and_system

SE-3235 - When searching by business partner, find objects also by other partners in merger group - China Re

Aim of function

Corporate restructuring occurs often by two company merging, creating a new merger parent,  or by one company acquiring another.   As in these arrangements, one of the companies might take over the portfolio of the other, searching for information with this company might need to search also by the parent merger company.   In some cases, one of the merged companies might even be inactive, in which case it is even more important to find its active merger parent. 

The system now offers search functionality to support this.  For finding business, accounting and claim related scenarios, if business partner in the search criteria belongs to a merger group, all other members of this business partner’s merger group will be automatically added to search criteria. Including or not including merger group in searches is customized by a system parameter.  

ParamSE3235.png

System Parameters Affected

System parameters / Find / Partners/ Other Option: Include merged companies and merge parent at search by business partner

Existing functionality affected

Find Business

Find Accounting Worksheet

Find Business for Facultative Analysis

Find Claims

Find Claim Program

 

Changed documentation

find/#8116-partners

SE-1829 - Log Contract Assignment to Cedent Program - Milli Re

Aim of function

Most organizations check the activities done by users within their applications.  SICS Log Activities logs changes done by users throughout the system.  One of these are the changes made to a cedent’s program.  As contract assignments or removal of them are major changes in a program, knowing who did this and when is important. 

The system now therefore also logs the linking of contracts to cedent’s programs, as well as the delinking of them.  For these, it shows the standard log of what changed, when it changed and who did the change. 

  image-2020-12-14-17-30-03-116.png

System Parameters Affected

N/A 

Existing functionality affected

Create Assumed Business

Create Cedent’s Program

Maintain Assumed Business

Maintain Cedent’s Program

Log Activities

Changed documentation

outbound_interface_facility/#log-activity-settings

SE-1831 - Log Excess of Loss Protection for Common Account assignment to proportional treaty - Milli Re

Aim of function

SICS Log Activities log changes done by users throughout the system.  This facility has however not supported logging of excess of loss protection for common account bought for proportional treaties.  As these protections are significant changes to a treaty, knowing who did this and when is important.      

The system now therefore logs the creation of an XL CA protection, both for inward and outward treaties.  It also logs removal of them and status changes.  For XL CA protection, the system shows the standard log of what changed, when it changed and who did the change. 

image-2020-12-14-18-53-40-826.png

  

System Parameters Affected

N/A 

Existing functionality affected

Create Excess of Loss Protection for Common Account of Inward Business

Maintain Excess of Loss Protection for Common Account of Inward Business

Create Excess of Loss Protection for Common Account of Outward Business

Maintain Excess of Loss Protection for Common Account of Outward Business

Log Activities

 

 

 

Changed documentation

outbound_interface_facility/#log-activity-settings

SE-1833 - Log Change of Reporting Unit on Business - Milli Re

Aim of function

Reinsurance companies may reflect how they divide their business internally by use of the SICS reporting units. These allows registering a contract with one or more reporting units per category, e.g. profit centres or segments.  As it is important to most organizations to know the activities done by users within their applications, and reporting unit assignments or removal of them are significant changes, knowing who did this and when is important.  

The SICS log facility, now logs also the adding of Reporting Units to a contract, as well as the removal of them.  For these, it shows the standard log of what changed, when it changed and who did the change. This log includes showing the Names and Categories of the Reporting Unit linked for any level of business that may have reporting units, e.g. assumed business and outward cedent’s contract.

LogReportingUnits.png

System Parameters Affected

N/A 

Existing functionality affected

Maintain Reporting Units on business

Log activities

 

 

Changed documentation

outbound_interface_facility/#log-activity-settings

Claim, NP Recovery, Cede

SE-2740 - Claims must be organized based on ‘Complexity Level’ with values ‘Complex’ and ‘Non-Complex’ - Allianz AG

 

Aim of function

Introduce a claim complexity indicator on claims, and when set automatically activate the Claim Security.

 

System Parameters affected:

Claim Complexity Level in use

 

Existing functionality affected

Create and Update Claims

Find Claims 

 

Changed documentation

claims/#872-miscellaneous

SE-2395 - Support for Client IBNR and Client IBNR LAE in FGU - Renaissance Re

Aim of function

Enable recording of Client’s IBNR and Client’s IBNR LAE figures in From Ground Up, consideration of same in Inuring Calculation, distribution, booking, reinstatement calculation, and Event IBNR.

When in use, the ACR is used to reflect additional case reserves on top of clients actual loss figures and their IBNR figures. Client IBNR figures are prioritised before ACR  figures in the FGU distribution, and Reinstatement Calculation.

 

System Parameters affected:

Include Client IBNR/LAE in worksheet

 

Existing functionality affected

Create FGU Record

Create FGU Inuring

Calculate FGU Distribution

Create FGU worksheet

Create Claim worksheet

Calculate Reinstatement

Create an Event IBNR Calculation record

 

Changed documentation

claims/#872-miscellaneous

claims/#875-claim-accounting

eMessaging

SE-3307 - Close Server Side Request Forgery (SSRF) vulnerability preventing man-in-the-middle attacks for eMessaging Server - DXC

Aim of function

Close Server Side Request Forgery (SSRF) vulnerability preventing man-in-the-middle attacks for eMessaging Server by upgrading to Apache Axis2 version 1.7.9

Name
CVE-2019-0227
Description

A Server Side Request Forgery (SSRF) vulnerability affected the Apache Axis 1.4 distribution that was last released in 2006. Security and bug commits commits continue in the projects Axis 1.x Subversion repository, legacy users are encouraged to build from source. The successor to Axis 1.x is Axis2, the latest version is 1.7.9 and is not vulnerable to this issue.
CWE

CWE-918
CVSS v2.0 Severity

MEDIUM
CVSS v3.0 Severity

HIGH
Dependency

axis-1.4.jar

axis-jaxrpc-1.4.jar

Name
CVE-2018-8032
Description

Apache Axis 1.x up to and including 1.4 is vulnerable to a cross-site scripting (XSS) attack in the default servlet/services.
CWE

CWE-79
CVSS v2.0 Severity

MEDIUM
CVSS v3.0 Severity

MEDIUM
Dependency

axis-1.4.jar

Name
CVE-2014-3596
Description

The getCN function in Apache Axis 1.4 and earlier does not properly verify that the server hostname matches a domain name in the subject’s Common Name (CN) or subjectAltName field of the X.509 certificate, which allows man-in-the-middle attackers to spoof SSL servers via a certificate with a subject that specifies a common name in a field that is not the CN field. NOTE: this issue exists because of an incomplete fix for CVE-2012-5784. CWE-297: Improper Validation of Certificate with Host Mismatch
CWE

NVD-CWE-Other
CVSS v2.0 Severity

MEDIUM
CVSS v3.0 Severity

Dependency

axis-1.4.jar

axis-jaxrpc-1.4.jar

Name
CVE-2012-5784
Description

Apache Axis 1.4 and earlier, as used in PayPal Payments Pro, PayPal Mass Pay, PayPal Transactional Information SOAP, the Java Message Service implementation in Apache ActiveMQ, and other products, does not verify that the server hostname matches a domain name in the subject’s Common Name (CN) or subjectAltName field of the X.509 certificate, which allows man-in-the-middle attackers to spoof SSL servers via an arbitrary valid certificate.
CWE

CWE-20
CVSS v2.0 Severity

MEDIUM
CVSS v3.0 Severity

Dependency

axis-1.4.jar

axis-jaxrpc-1.4.jar

System Parameters Affected

None

Existing functionality affected

SICS eMessaging Server

Changed documentation

se_3307

Life

SE-2841 - Free Cover Limit - Africa Re

Aim of function

The aim of this enhancement is to be able to apply an extra mortality premium on cessions where the original sum insured is above the defined free cover limit

System Parameters Affected

None

Existing functionality affected

Reference Data:

A new system defined reference data value ‘Above Free Cover Limit’ is available under Reference Data 00816 ‘Reason for Loading’

Cession Benefit:

When the Reason for Loading on the cession benefit is selected as ‘Above Free Cover Limit’ and the type of loading is ‘Total Mortality/Morbidity Rating’ then when the Original Sum at

Risk > Free Cover Limit:

Extra Mortality Premium is calculated using the formula : MAX(MIN( (Sum Insured Free Cover Limit), (SoC Autocover Limit)),0) * Ceded Share% * premium rate* Extra Mortality %

When the Reason for Loading is NOT ‘Above Free Cover Limit’ then the extra mortality loading will be calculated on the basic reinsurance premium as per existing functionality

When the premium is defined as a fixed amount then the extra premium will not be calculated when the reason for loading is ‘Above Free Cover Limit’

SE-3007 - Allocation of original accounting year based on policy anniversary - Africa Re

Aim of function

Allocation of ‘Original Accounting Year’ and ‘Original Accounting Period’ based on policy anniversary.

System Parameters Affected

A new system parameter under Accounting - > Worksheets ‘Original Accounting Year and Period based on Policy Anniversary’ is available for selection ONLY when a value under ‘Original Accounting Period Set in Order is selected

SystemParameters.png

Existing functionality affected

Cession Benefit:

On the Cession Benefit a new dropdown to select the Original Accounting Period is available. This is informational as per the current functionality

cessionscreenshot.png

SE-3720 - Cession Loader calculate the Our Share Amounts - Africa Re

Aim of function

To be able to calculate the Sum at Risk in the Ceded Share percentage as per the respective amendment when the cession figures loaded as a 100%

System Parameters Affected

New system parameter under Cessions ‘Cession and Claim Amounts in Our Share’ is available

CessionSystemParameter.png

Existing functionality affected

Assumed Business Share Condition:

When the above system parameter is selected, a flag ‘Cession and Claim Amounts in Our Share’ will be available for selection on the Share condition of the assumed business

ShareCondition.png

Inward Cession Benefit:

When the flag is selected on the Share condition of the business, then on the inward cession new business transaction, a flag ‘Sum At Risk Our Share’ is available and selected by default. When a value is entered in the field Total Reinsured Sum at Risk, the ceded share percentage as per the amendment to which the cession is linked is applied to this amount and defaulted as the Gross Sum Reinsured and Sum at Risk

When the Reinsurance Premium Method is Original Terms and the Rates Amount Option is As Original, then the entered ACIs will also be recalculated in the ceded percentage

InwardCession.png

Inward Claim

When the Claim Liability Amount is updated on the claim and changed from the defaulted value, then the Accounted Claim Liability will be recalculated in the Ceded Share percentage.

When there is no change to the Claim Liability Amount in the Paid status, the flag will not be editable and there will be no recalculation of the Claim Liability figures

Claims.png

SE-2779 - Claim Recovery, Premium waiver cases processing - Heng An Standard Life

Aim of function

The aim of this enhancement is to be able to calculate the recovery of the waived premium and process these recoveries as either lumpsum recoveries or instalment recoveries on the outward claim based on one inward ceded paid claim transaction and ACI

System Parameters Affected

Under the system parameters Business- > Claim Liability Calculation Rule, a new set of Claim Variables is now available. These variables along with the existing cession variables may be used to define a claim liability calculation rule

ClaimLiabilityCalculationRule.png

Existing functionality affected

On the Cession Benefit transaction:

A new field ‘Policy Year’ is available. This will indicate the policy year of the cession benefit transaction and the remaining duration for the cession will be calculated based on the benefit term and the current policy year.

PolicyYearOnCessionBenefit.png

On the Ceded Paid Claim:

Two new system defined reference data values ‘Lumpsum Settlement’ and ‘Instalment Recovery’ are available for selection on the Ceded Paid claim

When the claim SoC has the Claim Liability Calculation rule defined to process the claim as a waiver of premium claim, then depending on the Claim Liability reason selected the outward claims that are created by the Retrocession Claim Processing Order will be calculated as

a) When Lumpsum Recovery is selected: The ceded percentage will be applied to the lumpsum ACI on the inwar ceded paid claim

b) When Instalment Recovery is selected: The claim recovery will be calculated based on the rule as below and create the all the instalments that need to be recovered as outward ceded paid claims

Recovery amount = Claim Liability Amount from claim variable * the value (If MLY=12, If QLY=4 etc) based on the renewal frequency variable on the cession* (PPT - Current Policy Year) from cession variable * ceded percentage

CededPaidClaim.png

SE-3763 - Can’t change additional classification when renew cession or doing “Other” amend - Heng An Standard Life

Aim of function

The aim of this enhancement is to be able to modify these additional classifications on an ‘Other’ amendment transaction on the cession benefit

System Parameters Affected

None

Existing functionality affected

On cessions where the ceded flag is active, it is possible to add additional classifications from the business as part of the cession classifications.

Now, when an ‘Other’ transaction is created as an amendment on the ceded cession benefit, it is possible to edit the additional classifications.

These updated additional classifications will be copied to the respective outward cession transaction and any premiums that are based on additional classifications will be calculated using the updated values from the current Other transaction onwards

The Benefit Covered and Insurance Product will not be editable on any transaction as per existing functionality

None of the classifications can be edited on any other transaction except the ‘Other’ transaction

SE-4117 - Sequential Retroprocessing – Remaining Testing (Carryover of SE-2881) - Heng An Standard Life

Aim of function

Extended testing of the following functions:

a) To be able to assign a cession benefit identifier for all the cession benefits within the benefit group

b) To be able to sequentially process retrocessions when the ‘standalone retrocessions’ functionality is in use

System Parameters Affected

  None

Existing functionality affected

None

SE-4119 - Backdated transactions and reversals – Remaining functionality (Carryover of SE-2885) - Heng An Standard Life

Aim of function

Extended testing :

To be able to enter a transaction number for each cession benefit transaction manually or through the cession loader and to be able to reverse specific transactions on the cession benefit and the corresponding outward cession benefit by referring to this transaction number

System Parameters Affected

None

Existing functionality affected

None

SE-4121 - Joint Life cessions through loader- Outstanding functionality and testing (Carryover of SE-3323) - Heng An Standard Life

Aim of function

Extended testing: To be able to create joint life cession benefits through the cession loader

System Parameters Affected

None

Existing functionality affected

None

SE-4123 - Retroprocessing for cessions on Group level (Outstanding functionality from SE-2776) - Heng An Standard Life

Aim of function

  1. To be able to apply the per life, per benefit retention and autocover limits defined on the OCC for the entire group using the Group Scheme Number of Lives and the uniform Individual Sum at Risk per life

  2. When there is a claim that has been reported on a cession benefit and there is a termination transaction with a date later than the claim event date, no unearned premiums will be calculated

System Parameters Affected

None

Existing functionality affected

1. Apply Limits to the total number of lives in the group

Cession Benefit:

A flag ‘Group Cession without Individual Member List’ is available on the inward cession Group Information Tab

When this flag is selected, the Sum at Risk on the cession benefit is considered as the total sum of risk for the group which will be the Group Scheme Number of Lives * Individual Sum at Risk. (Note: There is no automatic calculation done)

screenshot-1.png

When the RPO is run, the

The sum to be retroceded is calculated as per the following :

Capped Quota Share and Quota Share

Retention= MIN( Cedent’s Retention* Group Scheme Number of Lives, Accumulated Sum at Risk*Cedent’s Retention%)

Autocover Limit=Our Reinsurance* Group Scheme Number of Lives

Sum to be Retroceded= Sum at Risk – Retention

Surplus:

Retention = Surplus Retention * Group Scheme Number of Lives

Autocover Limit= Autocover Amount Our Share* Group Scheme number of Lives

Sum to be Retroceded = Sum at Risk- Retention

Retro SAR = MIN (Sum to be Retroceded, Autocover Limit)
Note: The above calculation will not be supported for more than one surplus

2. Unearned Premium not returnable after claim

On the OCC AC Condtion when the Unearned Premium is selected as ‘Unearned Premium Excluding Claim’ AND The ceded flag is selected on the cession benefit:

When there is a ceded paid claim that has an event date earlier than the termination transaction created on a cession benefit, then the unearned premium will not be calculated on the outward cession when the RPO is run for the termination transaction.

This will not be applicable to the calculation of unearned premium that is returnable on inward cessions.

MG & Reserve Orders

SE-2379 - Estimate Settlement Indicator Mass Update - Allianz AG

Aim of function

  1. Added an option for the Multi GAAP Accounting and Retrocession Orders to split Liquid and Non-Liquid details into separate balances.

This is controlled by a new Multi GAAP General system parameter.

MG_GeneralSystemParameters.png

When the new parameter is selected, Liquid and Non-Liquid details created by the Multi GAAP Orders will always be split into separate balances. The balances with Liquid details will then be set to Unsettled, and the balances with Non-Liquid details will be set to Settled.

  1. Changed the Estimate Settlement Indicator Mass Update, so that it can set estimate balances to Settled, even if estimation items in Period Estimates are not set to Complete.

A new option is added to the Estimate Settlement Indicator Mass Update Order.

Estimate_Settlement_Indicator_MassUpdate.png

When option “Validate Complete Flag” is selected, Insured Periods are only included if all Estimation items, with a liquid Accrual Entry Code defined in the Period Estimation rule, are set to Complete.

When the “Validate Complete Flag” option is cleared, there is no validation of the Complete Flag. All businesses matching the extract criteria will be included in the Mass Update.

Note that the default value of this flag is cleared. To get the old/existing functionality, the flag must be selected.

System Parameters Affected

New Multi GAAP / General system parameter, as described above.

Existing functionality affected

Run Multi GAAP Accounting Order

Run Multi GAAP Retrocession Order

Create and run the Estimate Settlement Indicator Mass Update

Changed documentation

multi_gaap/#other-multi-gaap-system-parameters

SE-4049 - Underwriters Estimation Calculation Order: To allow creation of pricing estimates on a child section when it is already created on another child section - China Re

Aim of function

Underwriters Estimation Calculation Order: To allow creation of Pricing Estimates on a child section when there already exists Pricing Estimates on any of other sections.

System Parameters Affected

System Parameter / UnderWriters Estimates / General: Calc. Order: Allow creation Pricing Estimate on a child section when it has already been created on another child section

screenshot-1.png

Existing functionality affected

Automatic Creation of Estimates

Changed documentation

underwriters_estimates/#8176-general

SE-3932 - Closing date as a variable in MGAAP - Renaissance Re

Aim of function

Added a new variable for Closing Date in Multi GAAP Calculation Rules

ClosingDate.png

Returns the last day in the Default Period in Booking Terms for the relevant Base Company. Taken from the Extended Booking Terms if this exists and has Multi GAAP Accounting Order selected as Order Type, otherwise it is taken from the General (Local) Booking Terms

System Parameters Affected

N/A

Existing functionality affected

Calculate Period Estimates

Changed documentation

multi_gaap/#variables

SE-3015 - Validate Pricing As At Date with IP From Date - Toa Re Europe

Aim of function

When Pricing Estimates are created using the Underwriters Estimation Calculation Order, the As At Date on the Order is populated to the As At Date of the Pricing Estimate.

UW_Estimation_Calc_Order.png

The new functionality will make sure Pricing Estimates are not created on businesses where the Insured Period Start Date is later than the As At Date on the Order.

The new functionality is controlled by a new system parameter

UW_Est_System_Parameters.png

System parameters affected

New Underwriters Estimates / General system parameter “Prevent Pricing Estimates Prior To Insured Period Start Date”

Existing functionality affected

Run Underwriters Estimation Calculation Order with option ‘Create Pricing Estimates’ selected.

Changed documentation

underwriters_estimates/#8176-general

Other

SE-4157 - Library Update - DXC

Aim of function

Update 3rd party libraries used by SICS to their latest version, giving SICS access to new functionality and the latest security patches.

System Parameters Affected

None

Existing functionality affected

All, though it is mostly not visible to the end user.

SICS5

SE-4024 - SICS4 20.4 changes supporting integration into SICS5 - DXC

Aim of function

Make non-functional changes in SICS4 that will support/ease updating SICS5 with the latest SICS4 contents.

System Parameters Affected

None

Existing functionality affected

Functionally, none.