The current function to generate a new NR number uses a random number that excludes existing NR numbers in PostgreSQL but no longer checks Oracle. Consequently, duplications may occur in Oracle.
We need to double-check the production environment for both Oracle and PostgreSQL before code release. If any NR numbers exist only in Oracle, they can be added to the nr_number_exclude table, as the NR generation function also excludes numbers listed in this table.
The current function to generate a new NR number uses a random number that excludes existing NR numbers in PostgreSQL but no longer checks Oracle. Consequently, duplications may occur in Oracle.
We need to double-check the production environment for both Oracle and PostgreSQL before code release. If any NR numbers exist only in Oracle, they can be added to the
nr_number_excludetable, as the NR generation function also excludes numbers listed in this table.