What's new
Accounting General #
SE-13372 - Enhancement on Payment Task and Balance Split options - Aon #
Aim of Function
When booking on an Assumed Business, either manually or automatically from Premium & Limit conditions, e.g. Instalment, and Deduction details are calculated from the Deduction Conditions, then the system will check the 'Paid To' field for all deductions to be calculated. If there is no partner assigned in the 'Paid To' field no special action to be taken, i.e. existing functionality will apply. If there IS a partner assigned in the 'Paid To' field for the actual deduction to be calculated, then the system shall add this detail in a new balance or add it to an existing balance where the same partner is the Business Partner.
System Parameters Affected
A new system parameter named Activate the 'Paid To' column in deduction condition under System parameter maintenance>>Accounting>>Miscellaneous.
Existing functionality affected
Manually booking with automatic deduction calculation.
Automatic booking.
Installment/Adjustment order.
Changed documentation
SE-13209 - Additional Warning on currency - Continental Reinsurance #
Aim of Function
The Aim of this function is to trigger a additional confirmation message on the closing screen, while the status is changed to closed, on both Technical and Claim worksheet, each time bookings are made in different currency than the main currency defined on the business.
System Parameters Affected
A new system parameter named 'Confirmation Message While Closing Worksheet When Currency is not Main', is found under Accounting, Miscellaneous page
Existing functionality affected
Worksheet Closing Window - when status is set to Closed
Changed documentation
SE-12820 - Due date to follow booking date - Labuan Re #
Aim of function
For all types of Business, when the user adds the first Booking row to the Worksheet, when the Due Date is defaulted on a technical worksheet and it is earlier than the Booking Date, then the system shall set the Due Date equal the Booking Date. When the Due Date is defaulted on a technical worksheet and it is equal or higher than the Booking Date, then the system shall keep the defaulted Due Date. This should also be the case for details created by the functions Copy, Reverse and Reverse and Replace.
System Parameters Affected
A new system parameter named Do not default Due Date before Booking Date, is found under Accounting, Worksheet page
Existing functionality affected
The system shall compare the defaulted Due Date with the Booking Date, and set it equal the Booking Date if it is less than/before the Booking Date. This should be the case for all types of businesses independent of how the booking details are created on the worksheet, manually, reversal, automatic instalment bookings etc. If the user change the Due Date manually after it has been defaulted, then it will not be changed even if the Booking Date is changed. New details created manually on the worksheet will get the Due Date from the previous detail.
Excluded from this would be booking created by Retrocession Calculation and Account orders, and all booking of Estimates, manually or through orders.
Changed documentation
SE-2375 - Entry Code Transformation between IAB and Fac ORP - SOMPO JAPAN INSURANCE INC. #
Aim of function:
We have the Entry code Transformation Term selected on ORP (Admin condition->Currency) then the EC defined on assumed business should be transformed to EC on ORP(for both As booking and As Account)
When a user create Proportional Facultative business and directly places to ORP than as per the terms defined under the admin conditions<Currencies Tab <EC transformation, booking made with entry code in assumed business will be transformed to another entry code for ORP. This enhancement is done to transform the booking when ORP is directly placed to Proportional facultative business.
System Parameters affected:
None
Existing functionality
Entry Code Transformation when booking takes place on Assumed Business protected by Fac ORP
Changed documentation
SE-12648 - UGLOE split when different FX details - Triglav #
Aim of function
To give users an option to split the balances of a Technical or Claim Worksheet on the basis of Special Functional Currency 1 Exchange rules, to ensure that all details within the same balance follow the same exchange rule when calculating the Functional Currency 1 amounts. This split of balances is additional to the other balance split options that take place on a worksheet. Entry codes that are part of any special Functional Currency 1 Exchange rule will be part of their respective separate balances whereas Entry Codes with no Special Functional Currency 1 Exchange Rules will remain in the normal balance.
System Parameters Affected
A new system parameter named 'Split Entry Codes with special FC1 Calculation Rule in Separate Balance' can be found under Accounting-> Currency-> General, below the parameter 'Include Realized Gain/Loss In FC Revaluation' . The new parameter gets enabled when 'Include Realized Gain/Loss In FC Revaluation' is CHECKED.
Existing functionality affected
- Manual creation of Technical and Claim Worksheet.
- Reverse worksheet for Technical and Claim Worksheet
- Reverse and Replace for Technical and Claim Worksheet.
- Copy for Technical and Claim Worksheet.
- Import Technical Worksheet through Spreadsheet.
- Installment Order & Adjustment Order.
- Automatic booking of Installments and Adjustments.
Changed documentation
Accounting Orders #
SE-13421 - Estimates based on the different recording frequency of each business - Qianhai Re #
Aim of Function
Added a new option for Estimation Frequency in Multi GAAP/General system parameters, labelled Depend On Each Business
When the new option is selected, the Estimation Frequency on each business will be the same as the Account Frequency set in Administration Conditions.
Supported estimation frequencies with this option are Monthly, Quarterly and Half Yearly.
If no Administration condition exists, or there is no Account Frequency defined in the Administration Condition, the Estimation Frequency will be Quarterly.
System Parameters Affected
Multi GAAP General Parameters for Estimation Frequency
Existing functionality affected
Calculate Period Estimates
Changed documentation
SE-13423 - Period Number according to calendar time - Qianhai Re #
Aim of Function
Added a new system parameter named Period Number According to Calendar Time under the system parameter: MultiGAAP/General/Estimation Frequency/Depend On Each Business. When the new system parameter is selected:
- The period numbers in Administration Condition follow calendar time.
- The period number in Period Estimates is the same as the period number in Administration Condition.
- AccYr and AccPeriod in Technical worksheet and Estimate worksheet are the information configured in Administration Condition.
System Parameters Affected
MultiGAAP/General/Estimation Basis/Accounting Year
MultiGAAP/General/Estimation Frequency/Depend On Each Business
Existing functionality affected
Business/Administration Condition
Business/Underwriters Estimate/Period Estimates
Technical Worksheet
MultiGAAP Accounting Order
Retrocession Estimation Calculation Order
MultiGAAP Retrocession Order
Changed documentation
SE-13444 - Add Last Projection Year (SICS LIFE) in update period estimate webservice - Qianhai Re #
Aim of function
Allow to update Last Projection Year in Period Estimates tab through updatePeriodEstimates webservice.
Added new element named <lastProjectionYear> in Entry Point: urn:SicsWsBusinessEntryPoint/updatePeriodEstimatesInput
System Parameters Affected
None
Existing functionality affected
updatePeriodEstimates web service
Changed documentation
SE-12948 - New MGaap functionality for non-prop deals - Renaissance Re #
Aim of function
Add New Calculation Variable in Underwriters Estimates/Multi Gaap Calculation rules.
It will allow to setup calculation rules based on the Installment booked and not booked, If the 'Total Amount Not Booked' is Zero system follows the old approach and other than zero follows the new approach.
System Parameters Affected
Added new calculation variable i.e. 'Total Amount Not Booked' with Two sub variable 'Gross' & 'Net'.
Changed documentation
BO #
SE-13696 - New Database Views to support universe updates (SQL & Oracle) - DXC #
Aim of function
Need to create Views (In SQL and ORACLE) to resolve few object level and join level issues in the unified universes like CEDE, Life, GL_Interface & PC Main .
Creating views to resolve date calculation, date format and measure calculations.
System Parameters Affected
These changes will not effect any existing system parameters.
Existing functionality affected
As we are creating new views , it won't disturb the existing functionality.
Changed documentation
SE-13752 - New Database Views to support universe updates (PostgreSQL) - DXC #
Aim of function
To have one universe to develop and maintain and this ONE universe can then connect to the different supported database platforms.
System Parameters Affected
NA
Existing functionality affected
There will be a new universe which is the unified universe, in this universe there will be no RTRIM() functions and dates will be extracted as datetime stamp without any conversions as they have today. There will also be a new exchange rate function which is similar for all database platforms.
Changed documentation
SE-14984 - Create BOAC procedures for PostgreSQL database - DXC #
Aim of function
To add database views, procedures, and functions so that the BO functionalities will be supported for Postgresql database as they are supported for Oracle and SQL Server database
System Parameters Affected
None
Existing functionality affected
None
Changed documentation
Business #
SE-14685 - New validation of reporting unit code uniqueness - Aon #
Aim of function
Reporting units reflect how the business is divided internally according to a reporting structure. The Reporting Units are identified by a unique name and a code.
SICS now offers the possibility to set up the system so that the Reporting Unit Code also must have a unique value.
System Parameters Affected
Reporting Unit Code must be unique
Existing Functionality Affected:
Maintain Reporting Unit
Changed documentation
SE-13460 - Improve placement complete when sum on reinsurers placements through broker has small deviations - DXC #
Aim of Function
When a contract is fully placed, you flag the contract as placement complete. The Placement Completed flag can only be set when the sum of signed shares for all the definite retrocessionaires is 100%. The system allows here for a deviation of +/-0,0000000049.
Also, when setting this flag, the system checks that the total of retrocessionaires' signed shares placed through each intermediary with a definite status is equal to the intermediary's signed share. Earlier, this check did not allow for any deviation between the intermediary's share and total share of retrocessionaires accepted through this intermediary. Now, SICS will also accept the same deviation of +/- 0,0000000049 for retrocessionaires placed through an intermediary, as it did earlier only for the total check.
System Parameters Affected
Allow Proportional OCC Placement above 100%
Existing Functionality Affected
Maintain Share Conditions
Edit Placement Completed
Check for Placement Completed
Place intermediary
Changed documentation
SE-13647 - Additional Business Conditions visibility depending on Security - DXC #
Aim of function
To reduce clutter in the user experience of the system, the security facility hides the condition buttons if they have no content (empty) and the user do not have an Update or Create right for these conditions. This has now been implemented also for conditions consisting of sub parts, like deduction conditions and premium and limit conditions.
System parameters affected
None
Existing functionality affected
Maintain Premium and Limit Main Conditions
Maintain Deduction Conditions
Manage Security
Maintain Section Overview
Maintain Cedent's Program Contract Overview
Changed documentation
Claim, NP Recovery, Cede #
SE-13246 - Cede Interface - Support for additional classifications - DXC #
Aim of Function
When creating a Policy Light via Cede Interface order there is a possibility to update seven more additional classifications.
The items added to the record is Additional Classification 12-18
System Parameters affected
None
Existing functionality affected
Cede Interface Order
Changed documentation
SE-13321 - Cede Interface new UDFs - Triglav #
Aim of Function
When creating a Policy Light via Cede Interface order there is a possibility to directly create sixteen more User Defined fields.
The items added to the record is:
5 boolean fields, 2 string fields, 2 date fields, 1 percentage field, 5 decimal fields, 1 ref data field
System Parameters affected
None
Existing functionality affected
Cede Interface Order
Changed documentation
eMessaging #
SE-11067 - Straight Through Processing - By Message Type - Renaissance Re #
Aim of function
Enable process/validate the eMessages per message type. Previously, the system did not have the feature to process/ validate the selected message types through the scheduler. With the new enhancement, we have introduced the Message Type field in the job step parameter, by selecting the options from the Message Type field, the user can perform the process/validation of the existing messages accordingly.
System parameters affected
NA
Existing functionality affected
New field Message Type added to the Job step parameters: eMessage import and process and eMessage import and validate
Changed documentation
SE-11505 - New UMR requirement: extend the rules (UniqueMarketReferenceIPValidationRule) & (InsuredPeriodReferenceRule) - Renaissance Re #
Aim of function
Contract with sections for the receiver are often handled with multiple contracts by the sender or broker. The system now shows a list of all eMessaging Reference types that have category Unique Market Reference from all the sections of a contract. This list is shown on the Insured Period tab.
System Parameters Affected
In the default settings of the eMessaging system parameter, introduced a new table Unique Market Reference.
Existing functionality affected
Maintain Sections
Update Business
Show Unique Market Reference Information
Changed documentation
SE-13333 - eMessaging to allow utilisation of Acord message extensions - Swiss Re Zurich #
Aim of function
When processing an Accord Claims (CM) eMessage, any extension to the claim attributes, the claims fields were populated manually. However, with this new enhancement, the system will allow the sender to include extensions, which have no restrictions in terms of formatting and content, and it will allow the sender to define which extensions are to be used and considered for 'claim creation' in the wizard and when creating the claim automatically. Basically, when there are mappings from message fields to Claim attributes, which contain valid values (internal or external codes) the claims attributes are automatically populated.
System Parameters Affected
Added a new field under the Mapping 'eMessage extension' and mapped eMessaging Message Field to SICS Attribute.
Existing functionality affected
N/A.
Changed documentation
Life #
SE-13022 - Additional String fields in Cession and Claim UDF and Additional fields in Other Information Tab - DXC #
Aim of function
To be able to add a total of 20 String fields on the UDF for cessions and claims
To be have 10 informational fields on the Group Information tab
System Parameters Affected
None
Existing functionality affected
User Defined Fields
It is now possible to add 20 String fields on the following User Defined Layouts
Cession
Cession Benefits
Claims
Cession- > Other Information tab
A total of 10 informational fields in the Other Information Tab are now available
Changed documentation
SE-13239 - Calculation Rule for Deductible based on the new column and variable - DXC #
Aim of function
The aim of this function is to be able to use the values 'Deductible' and 'Payment Ratio' in a Premium Calculation Rule
System Parameters Affected
None
Existing functionality affected
A fields 'Deductible' and 'Payment Ratio' that are available on the cession benefit transactions can be added to a Lookup Table
Changed documentation
SE-13340 - Add a new field to cession benefit transactions to show accumulated sum at risk value per person per benefit - DXC #
Aim of function
The aim of the function is to be able to view the accumulated sum at risk on the cession benefit transaction level and have this value updated on each transaction where applicable
System Parameters Affected
None
Existing functionality affected
The following functionality will be applicable only when the System parameter 'Sequencing based on Original transaction date' is selected
A new field On the Other Information tab labelled 'Accumulated Sum at Risk' is now available
The accumulated Sum at Risk on the life, for the benefit covered on the cession will be recalculated on each transaction based on the Original Transaction Date
The recalculated value will continue to be updated on the field 'Accumulated Sum at Risk' in each transaction with the values as on the Original Transaction Date of the cession benefit transaction
Changed documentation
SE-13343 - Enhance Webservices to pass Mapping Document - DXC #
Aim of function
The aim of the function is to enhance the CreateLfCessionBatchRequest webservice such that it will support to pass Mapping document.
System Parameters Affected
None
Existing functionality affected
As per the existing functionality, mapping reference element is not available to define the mapping name when we generate the new skeleton of cession batch. Therefore the cession batch used to pick the unique mapping that is linked with the input file
Changed documentation
SE-13442 - Reporting on Joint Life level for Joint Life cessions - DXC #
Aim of function
The aim of the function is to include the data on the Joint Life Data tab in reporting
System Parameters Affected
None
Existing functionality affected
None
Changed documentation
SE-11760 - Accumulation and Cover using the IO with Maximum Sum at Risk(in Sequential Order) for Joint Life Policies - Misr Insurance Company #
Aim of function
The aim of the enhancement is to be able to define the basis of Joint Life accumulation.
When the basis is selected as 'Maximum Sum at Risk', then the individual insurable object on the joint life insurable object that has the maximum sum at risk will be considered for the purpose of accumulation
System Parameters Affected
None
Existing functionality affected
On the P/L condition of the Assumed Business and OCC:
A new selection dropdown option for Joint Life Accumulation Basis with the options 'Primary Life' and ' Maximum Sum at Risk' will be available.
The selection will be informational on an assumed business
Retroprocessing:
When the Joint Life Accumulation Basis is selected as 'Maximum Sum at Risk' on the PL condition, then the individual insurable object with the maximum sum at risk within the joint life insurable object will be considered for determining the accumulated sum at risk to be used while creating the retrocessions
Changed documentation
SE-11785 - Claim Recovery - Calculation of Claim Expenses - Misr Insurance Company #
Aim of function
To be able to calculate the Inward Claim Expenses using a rule of Original Expenses Amount (Account Item) *(Sum at Risk/ Sum insured)
System Parameters Affected
None
Existing functionality affected
Only on Claims created on cessions that have the Ceded flag selected
- A new flag 'Method 1' will be available on the Claim Expenses tab
- When this flag is selected the claim expenses and the claim expenses ACIs will be calculated using the rule Original Expenses Amount (Account Item) *(Sum at Risk/ Sum insured)
- Claim Expenses will not be calculated as an account costing item. They will be part of the Ceded Paid account costing item
- It will be possible to create a separate claim expense to each Ceded Paid status
- It will be possible to map any entry code to the claim expenses
- The currency and the payment due date of the claim expense will default from the Decision Liability tab
- When the Retrocession Claim Processing Order is run, the ceded % will be applied to claim expenses from the inward claim to calculate the Retrocession Claim Expenses
Changed documentation
SE-13350 - New API interface for creating worksheets in the Life environment and P&C environment - Qianhai Re #
Aim of function
A new API Interface is to be created which would be using the Column Spreadsheet to Create Technical Worksheets for both SICS Life and SICS P&C.
System Parameters Affected
N/A
Existing functionality affected
This enhancement is providing the end user to create and close the Technical Worksheets through a API interface in addition to the existing manual upload Technical Worksheet from Column Spreadsheet process. Below are the new tags that were implemented as part of this enhancements,
Create Technical Worksheet with Column Spreadsheet
- Operation: <ImportTechnicalWorksheetFromSpreadsheetInput>
- Element: <fileName>,<mappingName>
Changed documentation
SE-13352 - Add Reinsurer Signature Date (SICS P&C & LIFE), Projection Basis (SICS LIFE), Last Projection Year (SICS LIFE) in webservice - Qianhai Re #
Aim of function
The aim of the function is to add the Reinsurer Signature Date and Projection Basis while creating a business or updating a business through Webservices
System Parameters Affected
None
Existing functionality affected-
- Reinsurer signature date: Prior to this enhancement Cedent Signature and Reinsurer signature date elements were not available under insured period element. The reinsurance and cedent signature date elements are now available while creating business through webservices
- Projection basis: Prior to this enhancement projection basis element is not available in createLfBusiness Skelton. As part of this enhancement Projection basis element is now available while creating business through webservices where the user can input projection basis as 'Yearly , Ultimate or none'.
Changed documentation
Other #
SE-3237 - .Net Core API Client - DXC #
Aim of function
Generate new P&C and Life API Server .NET Core Clients using the Windows Communication Foundation (WCF) dotnet-svcutil tool.
Deliver the new clients as NuGet packages.
System Parameters Affected
None
Existing functionality affected
None
Changed documentation
SE-8538 - UI/UX Improvements Life - DXC #
Aim of function
The aim of this epic is
- Improved the UX of the Accounting Classifications window.
- Added support for 'view calculation window' to show syntax color highlighting.
- Improved the UX of the Life Cession window , Life Cession wizard, Insurable objects.
- Fixed SOAP Tester alignments for Windows 10 and corrected 'help' tab with correct screenshots.
System Parameters Affected
N/A
Existing functionality affected
N/A
Changed documentation
SE-9302 - UI/UX Improvements Business - DXC #
Aim of function
The aim of this epic is
- Improve the UI alignments of various Business Consitions of SICS P&C Workstation.
- Make sure screens are properly visible in different screen display resolutions.
System Parameters Affected
N/A
Existing functionality affected
N/A
Changed documentation
SE-12549 - UI/UX Improvements Claims - DXC #
Aim of function
The aim of this epic is
- Improve the UI alignments of Claims related functions of SICS P&C Workstation.
- Make sure screens are properly visible in different screen display resolutions.
System Parameters Affected
N/A
Existing functionality affected
N/A
Changed documentation
SE-12975 - Automatic server data refresh - DXC #
Aim of function
Automatically refresh SICS Servers if there are changes to system parameters, security, etc.
When a change is made to system parameters, etc and an automatic refresh is requested, the server components will automatically refresh before processing a new request or job.
System Parameters Affected
None
Existing functionality affected
SICS SOAP Server
SICS Batch Server
SICS REST Server
SICS eMessaging Server
SICS ADH Server
Changed documentation
SE-13060 - Native Support for Apple Silicon - DXC #
Aim of function
Support for Apple Mac OS is still preliminary and not production ready, however as part of our continued work on in this area we have added native support for Apple Silicon with the inclusion of the appropriate SWT libraries. It requires a native Apple Silicon Java Runtime in order to work.
System Parameters Affected
None
Existing functionality affected
None
Changed documentation
SE-13084 - Switch Find windows to Paged Collections - DXC #
Aim of function
Find windows in 22.2 and lower would use an open cursor to support the 'More' button. This added load to the database server by having an open SQL statement waiting to provide more records that may never be asked for.
We have replaced the open cursor with new paged SQL statements that are opened when Find Now is pressed and closed immediately the first page of records is returned. Pressing More issues a new SQL statement asking for the next page of results.
This reduces the load on the server.
System Parameters Affected
None
Existing functionality affected
UIs with a More button!
Changed documentation
SE-13088 - Remove support for SQL Server 2012, Oracle 12c from the HW/SW docs - DXC #
Aim of function
Oracle 12c extended support ended in July 2022. We have now removed support for Oracle 12c from our supported platform list.
As of September 2022, the only long term release version of Oracle is 19c with an extended support EOL date of April 2027.
Microsoft SQL Server 2012 extended support ended in July 2022. We have now removed support for Microsoft SQL Server 2012 from our supported platform list.
System Parameters Affected
None
Existing functionality affected
None
--------------------------------------------------
References to Vendor EOL support terms:
- https://docs.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2012
- https://www.oracle.com/us/support/library/lsp-tech-chart-069290.pdf
Changed documentation
SE-13109 - Desktop App UX Improvements - DXC #
Aim of function
The aim of this epic is
- Improved the UX of the Life Cession tool bars.
- Added support to hi resolution displays to show a larger splash screens.
- Fix the UI/UX for Underwriting Estimates window.
System Parameters Affected
N/A
Existing functionality affected
N/A
Changed documentation
SE-13399 - PostgreSQL Application Support - DXC #
Aim of function
Support PostgreSQL 11+ in the SICS application.
Included:
- System Admin and SICS Desktop app
- Creating the database
- Running DB patches in future releases
- All SICS server components
Not Included:
- SAP BI Support
- Create BOAC scripts & related functions
- Any DB conversion tools from other DBMS platforms. There are many 3rd party options available.
SAP BI will be supported in a future release.
System parameters affected
None.
Existing functionality affected
All DBMS configuration related functions
Changed documentation
SE-14710 - Improved SQL Log Analyzer - DXC #
Aim of Function
The SQL Log Analyzer has been improved with the following:
- An information tab with basic details about the log
- A report of duplicate SQL in a separate tab with a count of the number of instances. These are completely identical SQL statements issued within the SQL log being analyzed
- A tab with a list of the number & type of statements issued each minute
- A tab with a chart of the number & type of statements issued each minute
Existing Functions Affected
The SQL Log Analyzer available on the System Information > Logging tab.
System Parameters Affected
None
Changed documentation
SE-14891 - Reorganize Mass Update & Import Functions - DXC #
Aim of function
1. Ultimate Loss Ratio Import and UW Estimates Supporting Figures Import, previously found in the Inbound Interfaces folder in the System Administration Utility, has been moved to the Periodic Functions folder on the SICS Desktop
2. Typical Mass Update functions, previously found in the Periodic Functions folder, has been moved to a new Mass Update Functions folder on the SICS Desktop
3. Separate the Mass Update functions from the Periodic Functions by creating a new Mass Update folder and moving all mass update functions to that folder
System Parameters Affected
None
Existing functionality affected
Ultimate Loss Ratio Import (P&C only)
UW Estimates Supporting Figures Import
Periodic Functions and Mass Updates
Changed documentation
This report was generated Wed Sep 21 12:03:07 UTC 2022.