What's new
Accounting General #
SE-4306 - Calculate preliminary bookings at Upload of Protected Assumed Business from Outward Cedent's Contract side - China Re #
Aim of function
When the Assumed Businesses have been imported to the Assumed Business list on a Prop Treaty OCC, the system will perform the generation of preliminary bookings on the OCC when required. If bookings exist on the newly uploaded and linked Assumed Businesses these bookings shall be transferred to the As Original ledger (preliminary bookings) according to the retroceded shares.
System Parameters Affected
System Parameter / Business / Miscellaneous: Import Protected Assumed Business on Treaty OCC
Existing functionality affected
Protect Business
Changed documentation
/sicsdocs/user_guide/pc/protect_reinsurance/protect_business/#assign-protected-business-by-upload
SE-5107 - Assign review technical worksheet right but no edit right for users - China Re #
Aim of function
User having review access right but no edit technical worksheet right should be able to review technical worksheet from 'Find Accounting Worksheet' screen, if he double clicks on one open technical worksheet, SICS will open 'Worksheet Closing' screen directly.
System Parameters Affected
NA
Existing functionality affected
Double click on an Open technical worksheet from 'Find: Accounting Worksheet' screen.
Changed documentation
SE-3436 - PBR 'Wrong Financial Period' Remove Manual booking for Non-Prop Treaty businesses from trigger - Swiss Re Zurich #
Aim of function
To make it possible to exclude the worksheet origin 'Manual' for a specific type of business from being triggered when producing the PBR report through the WEB service for the rule defined for PBR ' Wrong Financial Period' only
System Parameters Affected
Accounting > Plausibility Rules > PBR 'Wrong Financial Period' only
Existing functionality affected
Plausibility rule defined for PBR 'Wrong Financial Period' only.
Changed documentation
SE-3910 - Mass Pairing automatic update of paid - Swiss Re Zurich #
Aim of function
Added an option 'Update Paid Column in Administration Condition' in the Mass Pairing and Mass Pairing of Paid Remittances Order. This enhancement will automatically update the Paid column In Administration conditions, when the balance pairing is done through Mass Pairing and Mass Pairing of Paid remittance order, provided that the technical balances included in the pairing has the same details (AccYear and AccPeriod) as the single account.
System Parameters Affected
n/a
Existing functionality affected
The Periodic functions Mass Pairing order and Mass Pairing of Paid Remittance order.
Changed documentation
SE-4203 - Enhance FastCreate Technical and Claims Worksheet with Split Percentage - Swiss Re Zurich #
Aim of function
To be able to store given AC Split Percentage on the newly created AC done by the fastCreateTechnicalWorksheet and fastCreateClaimWorksheet web services.
Add element <reasonForStatusChange> to fastCreateTechncialWorksheet and fastCreateClaimWorksheet web services.
System Parameters Affected
none
Existing functionality affected
SICS Web Services fastCreateTechnicalWorksheet and fastCreateClaimWorksheet
Changed documentation
SE-3315 - Support New Amount import and Replacement Values via Import TW from Spreadsheet - Triglav #
Aim of function
Adding the new column named 'New Amount' in the related to SICS functionality 'Import Technical Worksheet from Spreadsheet'.
The New Amount is an optional column and will activate the replacement value function on the worksheet, i.e. the Replacement Values box is ticked, and the Previous Amount and New Amount columns are displayed. The New Amount given in the spreadsheet will be set in the New Amount column for this detail and the Amount column will be calculated according to existing online functionality.
Normally the Amount is mandatory when the spreadsheet is validated, but if the Amount column is empty for detail in the spreadsheet the system should still accept this detail as long as the New Amount is present, i.e. either Amount or New Amount is mandatory.
Exceptions when a spreadsheet is imported:
If both the Amount and the New Amount is given in the spreadsheet, the system will ignore the New Amount value. If the Entry Code on the actual detail does not allow Replacement Value, the system will not use the New Amount value given in the soap which is also according to online functionality, i.e. the user can give the New Amount in the worksheet but the system will just ignore it.
System Parameters Affected
None
Existing functionality affected
The online functionality of Replacement Value wherein the user needs to update the new amount manually. Now, the user able to update the New amount in the 'Import Technical Worksheet from Spreadsheet' spreadsheet itself and which will automatically activate the replacement value online functionality.
Changed documentation
/sicsdocs/user_guide/pc/accounting/find_ws/
/sicsdocs/user_guide/pc/accounting/find_ws/
Business #
SE-5169 - Restrict Edit of Business by Business Administration Restriction - DXC #
Aim of function
SICS Security Use Case 'Business Administration' offers an overall business authorization possibility for easy setup of most general rights of a user. For exceptions to the general set up, specific use cases can be set up to restrict, e.g. update of 'Business Conditions Shares', 'Business Premium and Limit Conditions' or 'Business Protection Assignment.
When not having Update access rights to the use case 'Business Administration', the user earlier was stopped only from creating new conditions. Now the user is stopped also when editing existing conditions. This applies to all conditions and other functions shown as 'white buttons' in the navigation bar, e.g. Share Conditions, Proportional Protection Assignment and Underwriter's Estimates.
System Parameters Affected
None
Existing functionality affected
Maintain Share Condition
Maintain Premium and Limit Conditions
Maintain Deduction Conditions
Maintain Reinstatement Conditions
Maintain Deductibles Conditions
Maintain Profit Commission Conditions
Maintain Claims Conditions
Maintain Administration Conditions
Maintain Deposit Conditions
Maintain Reserve Condition
Maintain Portfolio Conditions
Maintain Internal Premium Reserve Conditions
Maintain Rebate Conditions
Maintain Index Clause
Maintain Clauses
Maintain Cancellation Conditions
Maintain Underlying Business
Maintain Performance Management Data Return Information
Protect Inward Business by Excess of Loss protection for Common Account of Inward
Protect Outward Business by Excess of Loss protection for Common Account of Outward
Protect Business
Maintain Underwriter's Estimate's
Edit Business by Update Business Wizard
Changed documentation
SE-3749 - Manage Bifurcation groups - Swiss Re Zurich #
Aim of function
Bifurcation means dividing something in two parts. In (re)insurance, bifurcation usually refers to situations in which the issues of liability and damages are separated and tried independently. For these contracts, it is important to clearly see that they are part of the same bifurcation agreement, and therefore to group them together.
SICS offers now a new group type, Bifurcation Group, in which you may group such contracts. You link the insured period of one of the contracts to an insured period of the other contract. This feature includes some validations, e.g. that the group contains only businesses of the same level (e.g. only Assumed Businesses or only Outward Cedent's Contracts). The system clearly marks the contracts part of this group by showing the Bifurcation Group Name in their business title bar.
System Parameters Affected
None
Existing functionality affected
Maintain Business Groups
Find Business Groups
View Online Statistics
Create Business Group by Web Service
Update Business Group by Web Service
Changed documentation
/sicsdocs/user_guide/pc/structure_multiple_contracts/group_business/#maintain-bifurcation-groups
/sicsdocs/user_guide/pc/structure_multiple_contracts/group_business/#maintain-bifurcation-groups
Claim, NP Recovery, Cede #
SE-2567 - Creation and reversal of Technical Worksheets from Open Claim Worksheet - Allianz AG #
Aim of function
The claim worksheet is created to reflect a cedent's requests, but may still be under evaluation by reinsurer, and is therefore maintained in an 'open' status. The reinsurer wants to reflect the same booking in their books, but maintained in a technical worksheet. This enhancement introduces an option to create a duplicate technical worksheet, based on the claim worksheet. When this duplicate is created, the claim worksheet is automatically locked for further changes, except for the Booking Year and Period. When the claim worksheet is inactivated or closed, the linked Technical worksheet is reversed.
System Parameters
New Claim Accounting Parameter
Processes
Create Claim Worksheet
Change Status of Claim Worksheet
Changed documentation
/sicsdocs/user_guide/pc/accounting/claim_acc/#apply-and-create-duplicate-technical-worksheet
SE-521 - Cede Life Claim Recalculation - DXC #
Aim of function
Retroactive change of Retrocession of a Light Life Policy triggers a recalculation of previous claim bookings for current claim when running PB order.
The recalculation is triggered by a claim record with transaction type who has Claim recalculation as parent transaction category. Recalculation is done for all transactions for current Life Light Claim.
System Parameters Affected
n/a
Module key
Cede Life module activated
Changed documentation
SE-4070 - Recovery Orders - Auto Test - DXC #
Aim of function
Establish automatic test cases for Recovery Calculation
System Parameters Affected
n/a
Existing functionality affected
n/a
Changed documentation
SE-4078 - Proportional Risk Unit Group protection assignment - remaining enhancement - DXC #
Aim of function
- Enhance Proportional Risk Unit Group functionality:
As of Period Multi RUG Auto protection supporting both Monthly and Quarterly calculation frequency - Validation to prevent inconsistency between ordered and existing RUG PA effective periods
- Support combination of existing protection assignment and inherited RUG PA in Preliminary Bookings/Corrections
System Parameters Affected
Business/Protection: Proportional Risk Unit Group - Protection calculation frequency
Existing functionality affected
Proportional Risk Unit Group w/Per Group option
Multi RUG Auto Protection
Preliminary Bookings/Corrections
Changed documentation
SE-1928 - Original Responsible Partner Type ahead limitation - Renaissance Re #
Aim of function
When linking a technical worksheet detail to an Original Responsible Partner, the available partners should be limited to specific type(s) of partners.
System Parameters affected
New parameter introduced 'Restrict Original Responsible Partner type' - where none, one or more types may be defined.
Existing functionality affected
Manual Bookings on Technical Worksheet
Changed documentation
SE-1929 - Display of bookings on Statistics Screen - Renaissance Re #
Aim of function
In order to see the 'true' attritional losses a new 'grouping' level for 'Original Responsible Partner' is displayed when Original Responsible Partner is set as mandatory, and either 'Headline' and/or 'Claim' is selected as grouping level (possibly in combination with others).
System Parameters affected
Original Responsible Partner is mandatory.
Existing functionality affected
Analyse Business
Changed documentation
SE-1884 - Signed Share and Sections-Limits on Claim search - Swiss Re Zurich #
Aim of function
In order to better identify correct claim section, new search options for Signed Share From and Signed Share To has been introduced when search option is 'Business Identifier'. The result column also displays limit for the linked section when 'View Details' is selected.
System Parameters affected:
Existing functionality affected
Find Claims
Changed documentation
SE-3414 - SICS to validate AAD entry codes against missing AAD condition - Swiss Re Zurich #
Aim of function
Use the accuracy framework to raise errors if the worksheet contains entry codes in any of the 'Annual Aggregate Deductible' sub categories, and corresponding condition is not present on insured period.
System Parameters Affected
Claim Accuracy template
Existing functionality affected
Create Claim Worksheet
process Claim Movement message
Changed documentation
SE-3510 - SICS to validate and calculate expected Reinstatement Premium based on booked figures for a given insured period - Swiss Re Zurich #
Aim of function
When the reinstatement premium calculation is Per Insured Period, there is a new option to calculate and validate the reinstatement based on the Accounting Period to dates of the Claim Bookings.
System Parameters affected
New claim accounting parameter enabling reinstatement premium calculation based on Accounting Period to dates.
Existing functionality affected
Create Technical Worksheet
Changed documentation
/sicsdocs/user_guide/pc/accounting/manual_bookings_on_ws/#automatic-reinstatement-calculation
SE-3512 - Combined Annual Aggregate Limit - Swiss Re Zurich #
Aim of function:
Ensure that the (Annual) Aggregate Limit captured as the 'Combined Aggregate Limit' on Main Section, is the actual Aggregate Limit across all sections, and should not be changed on child sections. Similarly, the Reinstatement condition should not be changed on child sections.
System Parameters:
Validate Combined Annual Aggregate Limit
Processes affected:
Create conditions on child section
Calculate Reinstatement
claim worksheet validations
Claim Accuracy validations
Changed documentation
SE-4446 - Accuracy Validation comparing the current worksheet type with the Calculation Rule on the RIP Condition - Swiss Re Zurich #
Aim of function
Ensure that reinstatement premium is booked on correct and expected type of worksheet, considering the Reinstatement Calculation rule.
System Parameters affected:
Claim and Technical Worksheet accuracy rules defined
Existing functionality affected
Book reinstatement
Validate claim and technical worksheet
Changed documentation
eMessaging #
SE-4979 - Government Tax Validation Step 3 - eMessaging - Swiss Re Zurich #
Aim of function
The aim of this function is;
1) Introduce a new tab 'Government Tax' on TechAccount. This tab will be updated when an error message(s) is found due to validation of Government Tax. It is possible to override the error message by giving a Government Tax Comment and by selecting a Government Tax Category from the Government Tax tab or directly on the Technical Worksheet.
2) Automatically book Government Tax Target Entry Code detail(s) when;
- Processing a TechAccount eMessage
- Validate + 'Swap to Worksheet' from a TechAccount eMessage
System Parameters Affected
Government Tax Framework in use must be active (for 1 and 2)
Government Tax Table
- Respective rule as the booking details (Trigger Entry Code) included in the TechAccount eMessage must present in the table
- field 'Automatic Booking' must be active
Existing functionality affected
eMessaging;
- Validate Government Tax details
- Validate + 'Swap to Worksheet' + Change Status from worksheet created by TechAccount eMessage
- Process a TechAccount eMessage
Changed documentation
/sicsdocs/user_guide/pc/emessaging/highlights/#government-tax
SE-5634 - London Market Processing - Service Provider - Swiss Re Zurich #
Aim of function
Make it possible to identify a Business Partner specifically as a London Market eMessage Service Provider. Specific London Market features will only be activated on an eMessage with Service Provider if the Service Provider is identified as being London Market.
System Parameters Affected
eMessaging Business Partner Rule Set - Available Rules for assignment
Existing functionality affected
eMessaging London Market and London Bureau specific processing for Service Provider messages.
Changed documentation
Life #
SE-2851 - Assumed Cessions to be correctly calculated when the Treaty has multiple layers - Africa Re #
Aim of function
The aim of this enhancement is to be able to calculate cessions when the treaty has multiple layers. For example when a policy is to be reinsured through a Quota Share layer and then a Surplus or through more than one Surplus layer.
System Parameters Affected
None
Existing functionality affected
Reinsurance Program:
A new level of business 'Reinsurance Program' is now available. Multiple proportional assumed businesses can be linked and structured within a Reinsurance Program
Manual Cessions
It is now possible to create a manual cession linked to a Reinsurance Program also.
When a cession benefit is created and linked to a Reinsurnace Program, the Total Sum Reinsured will be validated against the Autocover Limit of the first layer of the Reinsurance Program
When the Gross Sum Reinsured exceeds the Autocover Limit, the remaining sum to be reinsured can be reinsured through the other assumed businesses defined as subsequent layers of the Reinsurance Program
Cession Loader
It is now possible to add a Reinsurance Program as a Business on the Cession Batch. The batch will be processed by applying the same input file and the mapping for all the businesses within the reinsurance program
Changed documentation
SE-5295 - Allocation of original accounting year based on policy anniversary- Outstanding functionality - Africa Re #
Aim of function
Allocation of 'Original Accounting Year' and 'Original Accounting Period' based on policy anniversary- remaining functionality
System Parameters Affected
None
Existing functionality affected
Original Accounting Year and Period on the Cession Benefit and on the Cession Worksheets
Changed documentation
SE-4115 - Life MTK support for Cessions, Claims, Partners - DXC #
Aim of function
To include several new fields on Cessions, Claims and Business Partners that were introduced over the past few releases to be supported through MTK
System Parameters Affected
None
Existing functionality affected
MTK for Cessions, Claims and Business Partners
Changed documentation
SE-5026 - Default transaction effective date and transaction code on the cession based on premium calculation frequency - DXC #
Aim of function
Sometimes the inforce files have only a transaction effective date or only a rule/ transaction code to identify whether the cession transaction is to be considered as a New Business, Renewal or Other transaction. The aim of this enhancement is to be able to identify the type of transaction code to be defaulted based on the transaction effective date and the renewal frequency OR to default the transaction effective date based on the transaction code.
System Parameters Affected
None
Existing functionality affected
Cession loader
When the input file has only a transaction effective date and no transaction code:
If the cession benefit does not already exist, a new business transaction is created with the reinsurance start date and transaction effective date as per the mapped values
If the cession benefit already exists and the transaction effective date as mapped = next renewal date as per the renewal frequency, a renewal transaction is created
If the cession benefit already exists and the transaction effective date as mapped != the next renewal date, then an Other transaction is created.
When the input file has a transaction code but no transaction effective date:
When the cession benefit already exists and the input file has a transaction code= Renewal, then the transaction is created as a renewal transaction and the transaction effective date is defaulted as per the next renewal date
For any other transaction code, the transaction effective date will be defaulted as per the online functionality when the specific transaction code is selected.
Changed documentation
SE-5237 - Cession Loader- Old Business and other transactions- Issues to be fixed - DXC #
Aim of function
To address certain gaps in loading cession transactions with the transaction code 'Old Business' through the cession loader
System Parameters Affected
None
Existing functionality affected
Loading of cession transactions with transaction code 'Old Business'
Changed documentation
SE-5263 - To retrocede in sequence: ordered by policy then rider instead of OCC then rider - Heng An Standard Life #
Aim of function
In a scenario where one cession/ policy has several benefits covered which are being retroceded/ reinsured to different retrocessionaires/ reinsurers, it is expected that the entire policy/ cession is considered as one entity for sequencing.
System Parameters Affected
New System Parameter 'Include Policy Number in Sequencing' is now available.
This will be available for selection ONLY when the system parameter 'Method of Retrocession is reinsured sequentially in excess of Maximum Retention' is selected
Existing functionality affected
1. When the above mentioned system parameter is selected, on the Protection Program a new flag 'Allow more than one PP' is available for selection. This will allow the user to add more than one PP to the same RPO
2. When the RPO is run :
All the cessions that have been picked up by the RPO and have no prior retrocessions are sequenced as per the following order:
i. Reinsurance Start Date
ii. Policy Number- sorted numerically and then alphabetically
iii. Base Benefits within the sequenced policy numbers
iv. Rider Benefits within the sequenced policy numbers
Each cession will then be retroceded in sequence through the PPs within the RPO, where all the benefits on the same cession i.e all benefits that have the same policy number are fully retroceded before the next set of cessions with the same policy number are retroceded.
Note: RPOs that have more than one PP will not be included in a Retrocession Processing Group Order
Changed documentation
MG & Reserve Orders #
SE-3477 - Progress and log recording for all orders - DXC #
Aim of function
Improve usability and diagnostic logging on various accounting orders by showing a progress bar when an order is run from the workstation.
When an order is scheduled, the Job Progress will be logged in the Job step Log.
System Parameters Affected
None
Existing functionality affected
The following orders are included in this release:
- Recovery Calculation For Protection Program
- Recovery Calculation For Protection Program AX
- Recovery Calculation For Protection Program SL
- Recovery Calculation For Single OCC
- Recovery Calculation For Single OCC AX
- Recovery Calculation For Single OCC SL
- Recovery Calculation For US QuotaShare
- Recovery Calculation For XL Fac
- Recovery Calculation Group Order
- Recovery Per Base Company For Protection Program
- Recovery Per Base Company For Single OCC
Changed documentation
SE-4230 - Add Underwriters Estimates Supporting Figures import facility in Life - DXC #
Aim of function
Added Underwriters Estimates Supporting Figures Import Facility in SICS Life.
1. New Reference table Underwriters Estimates Imported Value Data Types (Code 1174)
2. New Import facility in System Administration Utility/Inbound Interfaces
3. New calculation variables in Underwriters Estimates Calculation Rules to retrieve the imported values
The calculation variables will retrieve the imported value for the referenced Data Type
System Parameters Affected
N/A
Existing functionality affected
Underwriters Estimates/Projections Estimate
Changed documentation
SE-4231 - New Order to automatically create and calculate Projections - DXC #
Aim of function
To allow an automated process for Multi GAAP, we have added a new Accounting Order to automatically create and calculate Projections in Underwriters Estimates.
With this Order you can:
1. Create and calculate initial Projections in main currency on businesses with no existing Projections
2. Add and calculate additional Projections on businesses with already existing Projections
3. Recalculate existing Projections with a specific As At Date
When Projection Basis is 'Yearly' the Last Projection Year can be specified on the Order.
System Parameters Affected
N/A
Existing functionality affected
Calculate Projections
Changed documentation
SE-5128 - Add variables for booked amounts in UW Estimates calculation rules in SICS Life, similar to P&C - DXC #
Aim of function
Added calculation variables to retrieve booked amounts in Underwriters Estimates. Functionality has previously been available in P&C only.
A new Entry Code Group Category is available:
4 new variables in Underwriters Estimates calculation rules. When used in a calculation rule, an Entry Code Group within Entry Code Group Category 'Underwriters Estimates' must be referenced.
When calculated in Underwriters Estimates, bookings within the referenced entry code group are retrieved. For bookings in a different currency than the estimate currency, the booking details are converted to estimate currency using different exchange rules retrieved on the Projection Year equal to the Accounting Year on the booking details.
for the 4 variables (see system administration guide for details).
Note that when Projection Basis is Yearly, the booked amounts are System parameters affected
New calculation variables in Underwriters Estimates calculation rules
Existing functionality affected
Configure Underwriters Estimates calculation rules
Changed documentation
SE-6133 - Auto Update EPI issues - Renaissance Re #
Aim of function
Made the following changes to the Revised EPI Mass Update:
1. Revised EPI on a section is updated based on booked premium on the same section only. Previously it was considering booked premium on underlying sections also.
2. When Premium & Limit condition has been amended and has multiple effective periods, only the last effective period is updated. Revised EPI on the last effective period is updated based on the booked premium for the entire insured period. Previously the total booked premium was adjusted with number of days in the last effective period compared with number of days in the insured period.
System Parameters Affected
N/A
Existing functionality affected
Run the Revised EPI Mass Update (available in Periodic Functions)
Changed documentation
SE-4249 - Government Tax Validation - Deviation Details - Swiss Re Zurich #
Aim of function
The aim of the function is to provide additional information when system issues an error message due to Government Tax deviations. The additional information is given on a new window opened from the worksheet.
System Parameters Affected
- '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
- An error message is issued on the worksheet when e.g. deviations due to Government Tax amount not according to tax percentage defined in the Government Tax table.
Changed documentation
SE-4262 - Government Tax - Make it possible to delete linked Target EC or Trigger EC from Worksheet - Swiss Re Zurich #
Aim of function
The aim of the function is to be able to delete a Government Tax Target Entry Code or Trigger Entry Code directly from the worksheet also when details are linked
System Parameters Affected
- '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
- Deleting a Government Tax Target/Trigger Entry Code from an open worksheet;
It is not possible to delete a Government Tax Target Entry Code or Trigger Entry Code from worksheet when details are linked. To delete a linked Trigger/Target detail, the user must unlink the details by accessing the Government Tax Linkage Detail screen. After having unlinked the details, the Entry Code may be deleted from the worksheet.
Changed documentation
/sicsdocs/user_guide/pc/accounting/claim_acc/#delete-a-booking-or-booking-detail
SE-2585 - Upload File for Estimation Complete Mass Update - Toa Re Europe #
Aim of function
New option to import a list of business sections to be included in the Estimation Complete Mass Update. The business list can be imported from a spreadsheet, This must include Business Identifier and Insured Period Start Date. Section name can be included if only some sections on an insured period should be updated.
When the file has been imported, the businesses are shown in the mass update window, instead of the extract criteria.
When the Mass Update is run, only the listed businesses will be updated.
System Parameters Affected
N/A
Existing functionality affected
The periodic function Estimation Complete Mass Update.
Changed documentation
Other #
SE-4218 - Enable use of Java 15 with SICS - DXC #
Aim of function
3rd party libraries are starting to require Java 11+.
To enable SICS to get access to new functionality and the latest security patches, enable SICS to support Java 11+.
Bundle SICS with Amazon Corretto 15.0.2.7.1
System Parameters Affected
None
Existing functionality affected
All
Changed documentation
SE-4063 - ADH - Domain Block - Extra output fields with problem description and execution code - Swiss Re Zurich #
Aim of function
To provide an explanation of the failure reason when a Domain Data block does not provide any output. This explanation will be a new output field on the Domain Data block, for all types. Another new output field will provide an 'execution code': 0=output provided, 1/2/3/...=various failure categories (to be determined).
Imagine a Claim Section Domain Data block that has claim identifier as input, but provides no output. These failure categories come to mind:
- Claim id does not exist in SICS
- Claim id exists on more than one claim (and the DD block is not indexed)
- A Java exception has occurred within the DD block's processing logic, possibly caused by faulty data in the database.
System Parameters Affected
None
Existing functionality affected
ADH Transformation Mappings
Changed documentation
SE-4112 - ADH - There are a number of blocks that should accept SICS objects as input - Swiss Re Zurich #
Aim of function
Currently, a block output which provides a SICS object type (Partner, Section, etc.) can only be connected to a SICS object type input on another block.
Mentioned input and output types are related to Domain Data blocks only.
This enhancement aims to allow SICS objects to be used with other ADH transformation blocks' inputs/outputs that do no more than,
- block or allow input value to be propagated to output
- or, test if input is null/empty.
Such blocks are: Empty, Not Empty, boolean-Gate (not the 'Switch' input), data-Gate, Default, boolean-Branch (not the 'Switch' input), matches-Branch (not the 'Switch' input), If (not the 'Test' input).
A common scenario would be to pass a SICS object output from one Domain Data block, through a boolean Gate block and into another Domain Data block. The Gate block would be configured to block the pass-through of the SICS object, and also other data inputs on the Gate block, if certain conditions are not satisfied. Thus avoiding that the second Domain Data block executes a database query with too few predicates (which could be very time-consuming).
System Parameters Affected
None
Existing functionality affected
ADH Transformation Mappings
Changed documentation
SE-5077 - ADH - Options for date format handling when importing from Excel - Swiss Re Zurich #
Aim of function
When ADH input data is imported from an Excel spreadsheet, cells that are formatted as Date will be converted to a string representation of the date value. This conversion uses default settings that are not always fitting.
In order to get better control over the conversion, this enhancement will add new settings on the ADH system parameter Options UI:
- 'Excel import date format' (e.g. 'dd.MM.yyyy', defaults to empty)
- 'Locale' (e.g. 'English', defaults to empty)
- 'Apply to date cells with built-in formatting only'=yes/no (defaults to 'yes')
Any date imported from an Excel spreadsheet shall be formatted accordingly.
If 'Excel import date format' is empty/missing, the pre-enhancement default settings mentioned above will be used.
Data imported from .xml files are not affected by this enhancement.
System Parameters Affected
- Automated Document Handling -> Processing Options -> Excel Import -> Date Format
- Automated Document Handling -> Processing Options -> Excel Import -> Locale
- Automated Document Handling -> Processing Options -> Excel Import -> Apply to date cells with built-in formatting only
Existing functionality affected
ADH: Import Document
Changed documentation
This report was generated Wed Mar 24 09:35:21 UTC 2021.