SOFiE Support Release updates Release updates In the upper list, you will find the release notes for each new verison of the Sofie client, starting with version 5.20, release on the 21st March, 2018. The releases are ordered by date in reversed order, newest first, oldest at the bottom. SOFiE V6.05.04 (2022-11-16) 1. BCL - New table S1.5 layout 4: Please take note of the circular letter ST.22-0449 of the BCL regarding the introduction of the new table S1.5 layout 4 from the reporting referring to December 2022. The related documents can be consulted on the BCL website: S 1.5 "Information on interest rates in EUR". The TEST channel will be available with the BCL as of November 16 (using the TEST Context in your SOFiE client). Please note that this is a TEST channel and S1.5 layout 4 can only be sent in PRODUCTION mode from January 1, 2023. 2. CSSF - EBA V3.2 taxonomies Please take note of the implementation of the new naming conventions concerning the reports for credit institutions using the naming convention "COFREP". You will find this information in the Reporting Handbook and the latest version of the CSSF naming convention. SOFiE V6.05.03 (2022-08-25) This update will be available only for the SOFiE Sort version 6.05.03 and concerns an update for AnaCredit reports for BCL. New schema SDMX v1.0.7 for AnaCredit Linked to the circular-letter form BCL new XSD v1.0.7 will be mandatory for AnaCredit as of September 25, 2022. The old XSD is no longer valid as of this date. (Re)submissions of reports for past periods will have to respect this new version of the XSD for any submission from September 25, 2022. SOFiE V6.05.03 (2022-06-16) The changes to the FATCA editor are a follow-up to the newsletter published by the "Administration des Contributions Directes", (Direct Tax Administration), aka ACD on April 7th, 2022: "https://impotsdirects.public.lu/fr/archive/newsletter/2022/nl07042022.html". You will find all the information regarding FATCA reports as processed by the DTA: "https://impotsdirects.public.lu/fr/echanges_electroniques/FATCA.html". SOFiE V6.05.02 (2022-04-21) This version includes an update concerning the V160-F files (CDDP6 report) sent to the BCL (Banque Centrale du Luxembourg). SOFiE V6.05.02 (2022-03-31) Update of the postal address, e-mail address and phone number of the Sofie helpdesk following the Worldline rebranding. SOFiE V6.05.1 (2022-02-01) Correction of the nomenclature of OTHREP and OTXREP files. The character 'dot', for example, is now supported in the free part of the file name. In addition, the Sofie client now uses a third level in the version number. SOFiE V6.05 (2022-01-17) Fixed a bug that could cause the Sofie client to crash on very rare occasions. SOFiE V6.04 (2022-01-10) The SOFiE client uses version 2.17.1 of the log4j library. It fixes important security flaws discovered at the end of 2021. SOFiE 6.03 (2021-10-26) We are pleased to inform you about the new SOFiE Sort update dated 26th October, 2021. This update will be available only for the SOFiE Sort version 6.03 and concerns new reports for BCL and CSSF. New feature in version 6.03 : 1- New regulation ECB/2020/59 (CDDP6) CDDP6 documentation is available on the BCL website. All these reports will be added to the existing SOFiE VIRT package. 2- New BCL circular 2021/244 Among the impacted reports, the following reports have technical changes: - S 1.8 "INFORMATION ON SECURITIZATION TRANSACTIONS CARRIED OUT BY CREDIT INSTITUTIONS": https://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/S0108/S0108_L2_XML_2021.zip - - TPTBB "SECURITY BY SECURITY REPORTING - BALANCE SHEET DATA" : o - TPTBBL Layout 5 Luxembourg entity: https://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/TPTBB/TPTBBL_L5_XML.zip o - TPTBBN Layout 5 Luxembourg entity and its foreign branches: https://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/TPTBB/TPTBBN_L5_XML.zip For other reports, the technical version (XSD schema version) has not changed, only the business version (layout) has changed. BCL has not yet communicated a revocation date for the old XSD. 3- New schema SDMX v1.0.6 for AnaCredit New XSD v1.0.6 will be mandatory for AnaCredit as of January 25, 2022. The old XSD is no longer valid as of this date. 4- New CSSF Circular-CODERES 21/13 Changes in CSSF-CODERES Circular 21/13 result in a new OTHREP-BNNNN-XXXXXXXXXXXXXXXXXXXX_LU_SRF070002_EACIND_2022-01-31_yyyymmddhhmmssnnnn report that will be included in the existing SOFiE ESPT package. As we already mentioned in our previous communications, all these changes will only be available on SOFiE 6 series. It is therefore imperative that you update to the latest version of the 6 series. As a reminder, it is not possible to switch from version 5 to version 6 automatically. More information is available on Sofie's website and more particularly this document. Please do not hesitate to contact our SOFIE helpdesk in case of technical questions at +352 355 66 – 600 (option 1), or by E-mail: Sofie.lux@six-payment-services.com . SOFiE V6.02 (2021-07-05) On July 5th, 2021, a new version of the CRS v2 report editor was released. An error in the creation of "Zero reporting" reports has been corrected and a simplified user guide describing the creation of such a report has been published in the "Support / Documentation" section. SOFIE V6.02 (2021-06-29) On June 29th 2021, a new version of the FATCA v3 report editor was released. The values 222222222 to 777777777 are now accepted to inform why a TIN is not filled in. Please refer to the FATCA documentation on the ACD’s website for more information. SOFiE V6.02 (2021-04-07) On April 7th, 2021, a new and improved version was put online. It concerns an update of the COFREP report naming convention and the new accepted tables (SFRTBX, CFRTBX, CGSIIX, MRDECI, SMRTLA, CMRTLA) as well as the support of version 1.0.5 of the Anacredit report validation XSD, which comes into force on 1 July 2021 and replaces version 1.0.4. SOFiE V6.02 (2021-02-15) On 15 February 2021, a bugfix regarding the sending of SGOREP reports was made available. It is labelled "V6.02 (2021-02-15)". SOFiE V6.02 (2021-02-02) New features for SOFiE-Business customers: Support of a new file type (SECU) for the “Centre Commun de la Sécurité Sociale” (CCSS). The CCSS will communicate more information on this subject directly to its affiliates at a later date. Various minor corrections News about SOFiE-SORT customers: Two new reports for the “Commissariat Aux Assurances ” . (See this CAA document for more information.) ‘Rapport distinct Solvabilité 2 de l’entreprise’ (RSE) with “Déposant“= Company ‘Rapport distinct Solvabilité 2 de l’entreprise (narrative part)'. (N11) with “Déposant“= Company Availability of business feedbacks from the “Banque Centrale du Luxembourg” regarding the ANACREDIT report (FDBBUSI) Ability to control two different XSD versions in parallel for the ANACREDIT report Various minor corrections SOFiE V5.26 & V6.01 (2020-11-24) On November 14th, 2020, an updated version of the SOFiE V5.26 & V6.01 client were made available. These two versions contain the same functionalities and differ only in the Java Runtime used. The version 5 series will no longer be maintained after 2020. Please refer to the chapter above for more information. This update includes the following new features: FDBTECH files from BCL are now supported. They replace the former BCLFBR files. Minor corrections SOFiE V5.26 & V6.01 (20201014) On October 14, 2020, two new versions of the SOFiE client were made available, "5.26" and "6.01". These two versions contain the same functionalities and differ only in the Java Runtime used. The version 5 series will no longer be maintained after 2020. Please refer to the chapter above for more information. This update includes the following new features: Implementation of version 2 of the CRS schema and FATCA changes AnaCredit - IDA report follow-up AnaCredit conference of 27/28 February 2020 Minor corrections SOFiE V5.25 & V6.00 (20200922) On September 22 nd, 2020, the list of entities that can send OTXREP files to the BCL was expanded. SOFiE V5.25 (20200310) On March 10th, 2020, an updated version of the Sofie client has been made available. This version contains: Reports to the CAA (Commissariat Aux Assurances) that alreday suported the file formats "xls" now also support "xlsx". SOFiE V5.25 (20200128) On January 28th, 2020, a version of the SOFiE client was made available to users, "5.25". This version contains : Availability of reports covered by the 19/731 CSSF circular (direct link). Please contact Cetrel-Securities for more information. Several minor corrections SOFiE V5.25 (20191127) On November 27th, 2019, a version of the SOFiE client was made available to users, "5.25". This version contains : The list of supported tables related to COFREP reports has been updated. Please contact Cetrel-Securities for more information. Several minor corrections SOFiE V5.24 (20190925) On September 19th, 2019, a version of the SOFiE client was made available to users, "5.24". This version contains : Availability of the SUFREP report for the CSSF Availability of reports F24, F25, ... F32 for the CAA Update of the V0115 report layout for the BCL Several minor corrections SOFiE V5.23 (20190619) On June 19, 2019, version "5.23" of the SOFiE client was made available. There are only a few minor changes. The binary "wget.exe" has been updated. The screen that displays error messages when a file does not validate via the GUI now contains the Sofie version number and the connected SOFiE identifier. It incorporates the latest amendments made to the previous version, "5.22", on March 28th and May 14th. As a reminder, these are the following points: The agreement naming the reports sent by the financial institutions to the BCL, and to the CSSF in copy, has been updated. Entities of type "P" can now send all S* and TPTB* reports, such as S0001, S0213, TPTBBL, TPTBBN. The agreement naming the reports sent by the financial institutions to the BCL, and to the CSSF in copy, has been updated. These are the "S0103", "S0106", "S0213" and "TPTOBS" files of the OPCT package. The "reporter type" field now accepts values 1, 5, 6, A, B, I, K, O, P and S. The "declarant type" field now accepts values 1, 5, 6, A, B, I, K, O, P and S as well as NAF. SOFiE V5.22 (20190514) On May 14th, 2019, an update to version 5.22 of the Sofie client has been released. The naming convention for the reports sent by the financial institutions to the BCL, and to the CSSF in copy, has been updated. Every S* and TPTB* report can now be sent by an entitiy tpe "P", e.g S001, S0213, TPTBBL. SOFiE V5.22 (20190328) The naming convention for reports sent by the financial institutions to the BCL, and to the CSSF in copy, has been updated. These are the "S0103", "S0106", "S0213" and "TPTOBS" files of the OPCT package. The "reporter type" field now accepts values 1, 5, 6, A, B, I, K, O, P and S. The "declarant type" field now accepts values 1, 5, 6, A, B, I, K, O, P and S as well as NAF. The naming convention for these files is described in this document, published in October 2018: http://www.bcl.lu/en/Regulatory-reporting/Fonds_Investissement/Instructions/Electronic_transmission_IF_EN.pdf Please note that SOFiE does not currently support the value “NAF” as a "type reporter" yet. SOFiE V5.22 (20181115) Update « statistiques des fonds d'investissement » report (S2.13) for the BCL – SOFiE update mandatory for the latest BCL recommendations Availability of the « Prélèvement et versement indirects de billets libellés en EUR par l'intermédiaire d'un tiers » report (S 1.12-L) for the BCL - Package FINT The PRED and LMDI files have been added to the CETB package improvements in the parameter editor Updating the verification rule for the AnaCredit reporting agent code updating the list of document types accepted for DOCREP reports other small improvements SOFiE V5.21 (20180919) This version implements a set of corrections and adaptations including in particular - For FATCA documents, the impossibility to load the TIN field with 9 zeros for cases where a Tax Identification Number (TIN) could not be obtained. The Tax Administration now only accepts 9 capital letters "A" or code "#NTA001#". - A mandatory update of the SOFIE client before December 1, 2018 to align with the latest security recommendations. SOFiE V5.20 (20180718) SOFiE-SORT: Two new values (X and T) have been added to the list of possible values for the "final version" field in the file name of COF reports. A new BCL report is supported: SHSGRP. SOFiE V5.20 (20180626) SOFiE-SORT: New table names added to COF reporting. Some minor bug fixes. - ANA Credit report: validation pattern for the agent code has been set to ^[A-Z]+[A-Z0-9]+$ - Files are process in alphabetical order when processed in batch mode. SOFiE V5.20 (20180321) SOFiE-SORT-Crypt users may save the active user certificate to a flat file. This should simplify things when sending the certificate to the CSSF. Some minor bug fixes. Below the release notes of older SOFiE version ordered by date in reversed order, newest first, oldest at the bottom. SOFiE 5.19 20180228 – changes This new version supports layout 4 of the TPTBBN and TPTBBL reports. For more information, please visit this page on BCL’s website. The naming convention for AnaCredit reports has been adapted (field MessageID). For more information, please visit this page on BCL’s website. New Ca certificates from Digicert are now included. AN update of the SOFiE client software is requested in order for it to work as of March 15th , 2018. SOFiE 5.19 20180122 – changes This new SOFiE version includes the new MIFID II TAF rules. Effective from that date, only the TAF file name will be controlled. Concerning the EME reports, table W22 is now supported. (Please see page 14 in the following document ) SOFiE 5.19 20180109 – changes The older version of the TAF reports are extended even after December 31st, 2017. SOFiE 5.19 20171228 – changes Content: Bug fixed fixed in the TAF 2 report editing GUI ((Mifid /Mifir) SOFiE 5.19 20171122 - changes Support for new TAF reports (MiFID 2/MiFIR) New graphical editor for TAF reports (MiFID 2/MiFIR) (see doc in pj) Support for the new BCL AnaCredit report (see http://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/AnaCredit/index.html) Ability to use batch mode to send production and test files at the same time Possibility to define, for GUI mode, a default folder where to look for files to send, send or decrypt. Create a backup of files essential to the current SOFiE profile Displaying the SOFiE contract type used in the graphical user interface Minor corrections SOFiE 5.18 20170921 - changes The new file naming convention for FATCA feedback file is now supported. The ACD will start sending them as of September 26th, 2017. SOFiE 5.18 (20170627) - changes The CRS report editor now allows any value in field “Account number” when “Account Number Type” is set to “OECD605: other”. SOFiE 5.18 (20170622) - changes Content check on V0115 files has been activated (CDDP reports V1.15) Update on processing rules of TRAM files Bug concerning sending of FTCA and CRS files in batch mode an Production context has been fixed SOFiE 5.18 (20170613) - changes Updated configuration - V0115 report for CSSF/BCL SOFiE 5.18 (20170523) - changes Fixes in the following editors: Fisep, FATCA2 and NCD/CRS Deployment of the TAF II GUI Update of the extended COREP SOFiE 5.17 (20170503) - changes Some minor bug fixes in the CRS editor. SOFiE 5.17 (20170411) - changes Bugfix concerning the sending of CRS reports SOFiE 5.17 (20170403) - changes (SOFiE-BUSINESS) This update mainly includes taking into account the editor level and the reports of the new common norms for declaration (NCD or CRS, Common Reporting Standard) from Administration des Contributions Directes. (SOFiE-S.O.R.T.) It also includes the notion of alternative investment fund managers (type A) at the level of the fund reports (S0103 and S0213). If your SOFiE application is configured to be updated automatically during the setup. As of the afternoon of 29th march 2017, your SOFiE login screen, main window, and the “Help – About” menu should display “V5.17 20170329”. Otherwise a manual update will be necessary (see the manual for more details). This update is optional but recommended in the frame and context of this new norm. SOFiE V5.16 (20170301) - changes FATCA version 2 editor has been updated New reports supported towards CAA (RSO, FRI, RNx). Please contact Cetrel-Securities for more information. Some minor bugfixes SOFiE V5.15 (20170215) - changes Fix of a bug. In some cases, SOFiE worked fine but wouldn’t write any log file. SOFiE V5.15 (20170118) - changes FATCA report: Support o version 2 as defined by the Luxemburgish tax administration (ACD: Administration des Contributions Directes). You will find more information about FATCA 2 on the ACD’s website on the following page: “FATCA” (French only). Minor bug fixes SOFiE V5.14 (20161123) - changes New data collection CDDP BCL. Adding of the report solo EAC (SEACXX – COREP extended). Set up of the naming convention for the Solvency 2 report “group”. Some minor bug fixes SOFiE V5.13 (20161003) - changes Because of a bug, when trying to send an erroneous file , the error messages were not shown in the popup window when using the GUI and were not written to the log file. The bug has been fixed. SOFiE V5.13 (20160922) - changes Some minor bugfixes. SOFiE V5.12 (20160809) - changes The encryption parameters for the U1.1 reports were updated. Only the customers sending these files (name: U11REP) have to update their SOFiE client installation. SOFiE V5.12 (20160622) - changes The following category codes are now accepted for a GIIN code : LE, SL, ME, BR, SP, SF, SD, SS and SB. A US formatted TIN has to be a sequence of nine numbers only. The value ‘000000000’ is accepted to indicate an unknown TIN. SOFiE V5.12 (20160426) - changes Bug fix concerning the feedback files from CAA (Commissariat Aux Assurances), see naming convention version 1.01 under : http://commassu.lu/upload/files/504/CAA_FNC_v101.pdf New table Z22 allowed for EDP reports (see CSSF naming convention version 1.27,page 15 : https://www.cssf.lu/fileadmin/files/Reporting_legal/transport_securisation_reporting)/Convention_de_nom.pdf ) SOFiE V5.11 (20160121) - changes New reports related to the CSSF circular 15/624. The new BCL - insurance corporations reports related to the BCL circular 2015/239 Suppression of the unnecessary extensions related to the CAA sending. Correction regarding the BCL validation rules: the pool factor value must be greater than 0. New naming conventions of the BCL reports CDDP (files V0000 – V9999). some minor bug fixes and enhancements Please contact our helpdesk for more information. SOFiE V5.10 (20151210) - changes Bugfix in the FATCA editor, also known as FATCA GUI, of your SOFiE Business license: The installation of this correction is compulsory if you wish to use this functionality. If you have to send a FATCA file, we kindly ask you to wait until your SOFiE has been upgraded to version 5.10 in order to do your input via the graphical interface to prepare your FATCA reports. If you are not using this functionality, you can wait for the next release that is foreseen in January 2016 As usual, some minor enhancements and bugfixes have been included. Please contact our helpdesk for more information. SOFiE V5.09 (20151110) - changes Bugfix in the FATCA editor, also known as FATCA GUI, of your SOFiE Business license: The installation of this correction is compulsory if you wish to use this functionality. If you have to send a FATCA file, we kindly ask you to wait until your SOFiE has been upgraded to version 5.10 in order to do your input via the graphical interface to prepare your FATCA reports. If you are not using this functionality, you can wait for the next release that is foreseen in January 2016 As usuals, some minor enhancements and bugfixes have been included. Please contact our helpdesk for more information. SOFiE V5.08 (20150729) - changes Fix a bug concerning the password change procedure Fix a bug concerning the log file not being written under some circumstances Fix a bug in the FATCA editor (aka FATCA GUI) when modifying saving an existing "Zero reporting" file. Minor improvements in the FATCA editor. Please contact our helpdesk for more information. SOFiE V5.08 (20150716) - changes Fix a bug concerning the encryption of S0216 and S0217 files. Please contact our helpdesk for more information. SOFiE V5.08 (20150714) - changes Reports towards the CAA (Commissariat aux Assurances). For more information, please refer to Cetrel-Securities web page. Concerning the reports sent to the BCL, hte content of these ones is now also tested in addition the their name: S0001, S0101, S0104, S0105, S0108, S0205, S0208, S0209, S0401, S0216, S0217. Sofie user's may now resend the installation report when requested so by our helpdesk. It contains some usefull information for debugging purposes. (see menu Tools-> Installation report, then clieck on the "Send" button. A bug has been fixed which caused some installation files to be corrupted when running more than one instance of the client software on a same computer. Please contact our helpdesk for more information. SOFiE V5.07 (20150421) - changes Support new report S 1.9 «Information on CNY (renmibi) operations»: S0109 (package FINT): http://www.bcl.lu/en/reporting/credit_institutions/S19_en/index.html Naming convention has been adapted to the latest definiton from CSSF (version 1.19 to 1.21):http://www.cssf.lu/fileadmin/files/Reporting_legal/transport_securisation_reporting/Convention_de_nom.pdf Please contact our helpdesk for more information. SOFiE V5.06 Version 5.06 has been merged into version 5.07. SOFiE V5.05 (20150219) - changes Support new layouts of reports: S0214 (package TTRT): http://www.bcl.lu/en/reporting/Securisation_vehicules/S214_en/index.html . Support new layouts of reports: S0215 (package TTRT): http://www.bcl.lu/en/reporting/Securisation_vehicules/S215_en/index.html . Support new layouts of reports: TPTTBS (package TTRT): http://www.bcl.lu/en/reporting/Securisation_vehicules/Reporting_SBS_SVS/index.html SOFiE V5.04 (20150128) - changes Support of new S0302 reports, which replaces report S0401: http://www.bcl.lu/en/reporting/credit_institutions/S32_en/index.html Support of new reports: S0103, S0106, S0213, TPTOBS (package OPCT): http://www.bcl.lu/fr/reporting/Fonds_Investissement/index.html Bugfix in IBS editor(TPTIBS report). Filed "shareholderCountry" should only be present for liabilities, not for assets. SOFiE V5.03 (20150116) - changes Support of new S0216 et S0217 reports:http://www.bcl.lu/en/reporting/issuing_companies/index.html Support of layout 0 and 1 of reports S0101, S0104, S0105, S0108, S0205, S0208, S0209: http://www.bcl.lu/en/reporting/credit_institutions/index.html SOFiE V5.03 (20150114) - changes Bugfix concerning declarant identification for TPTBBL, TPTBBN, TPTBHR, TPTBHN reports: http://www.bcl.lu/en/reporting/credit_institutions/Reporting_SBS/index.html SOFiE V5.02 (20141204) - changes Bugfix: TPTIBS reports, both layout 0 and 1, were blocked due to a configuration error. SOFiE V5.02 (20141127) - changes The major enhancement in version 5.02 is the support of layout 2 for the TPTIBS report to the BCL. For more information, please go to BCL's dedicated web page. This version also includes some minor bug fixes. SOFiE V5.20 20180718 - changes SOFiE-SORT: New values added to COF reporting's final version tag in the filename (X,T). Support of the new BCL report "SHSGRP". Some minor bug fixes. SOFiE V5.01 (20140909) - changes Bugfix: malformed requests sent to server SOFiE V5.00 (20140625) - changes TPTBNR reports are sent to CSSF and BCL (before BCL was the sole recipient). COFFBX reports (CSSF response to a COFREP) are compatible. Fix of the connexion issue "redirected too many times (20)" which impacted some SORT-CRYPT accounts. Fix of a display issue in the login screen on Solaris systems. Fix of update issues in batch or run_gui mode. SOFiE V5.00 (20140414) - changes Windows 8.1 compatibility Java 7 compatibility Simplified network configuration. In particular, the LDAP communications are established through a HTTPS tunnel. The opening of port 389 is not needed anymore. The legal reporting COFREP (Prudential reporting scheme regarding capital adequacy in xbrl format 2014 ) , AIFREP (alternative investments funds ) for CSSF/BCL are supported The new Sécurité Sociale identifiers for companies registered under the owner’s name are supported Display of caps-lock and num-lock status in login screen Error messages enhancements Password synchronization in batch mode on system without graphical interface is supported OTHREP reports with an extension of 4 characters are no longer allowed.