This release broadens the list of formats that Duco supports as standard, and improves the Data Prep user experience allowing users to sort and filter their results. It brings:
- CAMT.053 Bank to Customer statement messages support in all process types
- More data captured in OCC FIXML trade capture report message
- Easier analysis of Data Prep results with filtering and sorting
Data input formats
Get ready for SWIFT ISO 20022 migration for cash management
To help you get ready for the upcoming Swift migration to ISO 20022 for cash management, Duco now supports the camt.053 format out of the box. This is the ISO 20022 equivalent of the ISO 15022 MT 940 and MT 950 messages, aiming to greatly improve the quality of information exchanged. Specifically camt.053 is a bank to customer statement message, sent by an account servicer to the customer to report the prior day’s transactions, opening and closing balances.
This template allows you to submit your cash statement data in the latest industry recognised Swift message format. Cash Reconciliation is available and normalisation will be possible through Data Prep, making use of the additional information contained in the enhanced message for greater matching.
See this page for full details.
Update to OCC Trade Capture report format
We are now exposing more data for trade parties in this message format so that you can include them in matching and exception investigations. For a set of commonly used party types, now you can see their IDs, list of sub party IDs and the corresponding sub party types, as well as a dedicated field for sub ID of their position account.
See this page for full details.
Data Prep enhancements
Analyse your normalised data
When you are investigating an exception from your reconciliation and want to see how the original data was normalised and transformed, or simply make sure your Data Prep process is correctly configured, you can now analyse pending data or snapshots easily using the new filtering and sorting options.
Bugs
Issue Addressed |
Description |
Data Prep process promotion fails in some scenarios. |
In a Data Prep process when a data input with applied filter got deleted, the configuration became invalid, blocking the process promotion between environments. |
The date and date/time formats are not cleared when the field data type is being changed. |
In Data Prep when a field type was changed between date and date/time, the field formats of the previous data type were not getting removed automatically. |
Missing space in an NRL rule. |
In a Data Prep process some NRL rules were missing a space when displayed, causing user confusion. |
Not possible to choose 'a unique value' from the NRL dropdown. |
In Data Prep while configuring an NRL rule using a reference data table, it was not possible to choose 'a unique value' from the dropdown. |
Errors when extracting data from headers. |
In Data Prep parsing long header values was resulting in errors. |
Errors while uploading MT940 message. |
In a cash process an MT940 message was loaded with errors if it contained big integer values. |
Reference table is granted with access to the same process twice. |
When several users were working on the same reference table or in case of a slow network it was possible that the same process got added to a reference data table twice, causing issues with running the process. |
Run failures while using submission windows for automatic file submissions. |
In some rare instances when there were many processes in the environment with submission windows set to run with submitted data, the runs could be failing. |