Release documentation - Cede - Enhancements and requests

Problem:
Error when running Multi Business Auto Protection Order
PostgreSQL is particular about the parameter types when using PreparedStatements and will not convert a value provided as a String to a Number.

Solution:
Convert Strings to Numbers before setting the PreparedStatement arguments.

Workaround:
Turn off ParameterizedSql in the sics-database-sources.xml file

Root Cause:
Some queries have used a string to as part of the argument criteria for number type columns.

Problem:
While creating BO views in DBs through SICS and When Parsing the cede universe getting an error for the view V_ENTRY_DATES  as 'N' is missing in 'BOOKING' filed.

Solution:
This needs to change to 'BOOKING' instead of 'BOOKIG' For the view V_ENTRY_DATES in SICS.

Declination Reason:

Workaround:

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected

Problem:
XML scripts when running via SICS script manager in SICS 22.4 is throwing errors and not getting executed as expected due to changes in the data type of the input parameters due to the change in scripts code.

Solution:
The XML script input parameters need to be changed as per the database script input parameters.

Declination Reason:

Workaround:

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected

Problem:
Configuring a custom user exit implementation is not supported on SICS Servers (ADH, API, Batch, eMessaging).

Solution:
Add support to configure a custom user exit implementation on SICS Servers (ADH, API, Batch, eMessaging).

Workaround:

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected

Problem:
National Language Support is not supported for Light Policies

Solution:
When National Language Support is activated, and selected, the corresponding values should be displayed on Light Policy

Workaround:

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected

Problem:
The system crashes in Cede Interface Order if Accounting function is set up with Calculations which does not have a result Entry Code

Solution:
When running Cede Interface order only Calculation with a result Entry Code will be considered. If no valid calculations are defined, no calculation is done.

Workaround:
Only enter valid Ceded Premium calculations in Accounting function

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected

Problem:
Abend when Add & Realize OCC Facultative Protection from PP of Policy Light

Solution:
When selecting Add & Realize OCC Fac Protection from Proportional Protection of a Light Policy, the system should do calculation of proportional share of already booked amount for current Policy Light section. This should be done also if there are proportional protections existing - and if Preliminary booking order has been run or not.
When confirm message AC0258 is given; calculation of retroceded share of Light Policy bookings are due.

Workaround:
None

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected

Problem:
Unable to open attachments on worksheet

Solution:
It must be possible to open attachments on worksheets

Workaround:

Root Cause:
Caused by SICSR-23399 in version 22.2

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected

Problem:
Abend when Life Policy list is opened from an OCC
PostgreSQL is particular about the parameter types when using PreparedStatements and will not convert a value provided as a String to a Number.

Solution:
Convert Strings to Numbers before setting the PreparedStatement arguments.

Workaround:
Turn off ParameterizedSql in the sics-database-sources.xml file

Root Cause:
Some queries have used a string to as part of the argument criteria for number type columns.

Aim of function
Introduction of a second currency/amount for Policy Light transactions.
The new FX Currency and Amount is included in

• Light Ledger
• Cede Interface record
• Cede Excel Loader
• Web Services

Business value for customers
Possibility to load a second currency / amount corresponding to the original amount. This is planned used to reflect the functional amount for the original entry at the time of booking.

System Parameters Affected
N/A

Existing functionality affected
Policy Light ledger transactions

Aim of function
Enhance Recovery Calculation process by removing unnecessary links from inward to outward at detailed booking level - both for light and assumed claims. As a consequence of this, we have disabled the possibility to view Source figures from the Outward Cedent's Contract business ledger detailed View.
Links historically created at detailed claim level will not necessarily give the correct picture, as the sequence as per current latest run is the correct one. The sequence is set according to current conditions when running the recovery order, and can be seen when selecting to view figures in the Recovery Calculation order.
NONPROP_REC_DETAIL table is created when running recovery calculation order, and will contain the current detailed result.
We will look into making additional enhancements to the view of the recovery feature in the next release - to ensure better overview of the current accumulated recovery allocation.

Business value for customers
Customers will experience a better performance as a result of the changes

System Parameters Affected
N/A

Existing functionality affected
Recovery Calculation / Reinstatement Premium Calculation order