Oracle Databases and Email Subscriptions
Fusion Registry Version 1.3 (due to be released in August 2025) contains a change to the way email addresses (entered and stored during the Email Subscription process) are handled in Oracle databases.
Previously, in the Fusion Registry 11 series and subsequent versions, it was possible to have duplicate emails stored in the Oracle database which was resulting in multiple notifications being sent for the same event.
Once R1.3 is installed, new subscriptions will be converted to lower case email addresses and duplicated emails will not be allowed.
Email subscriptions made prior to Version 1.3 will not be affected (so duplicates may exist in the database table) however, if the subscription is changed (for example a new subscription to a different event) the system will perform the remove duplicate process.