...
System Overview
Developer installation
...
Completely uninstall and reinstall oracle 12c. The installer can be found in \\TC4S0A\GROUPS\AARA\AARAD\Software Library\Developer Tools\Oracle. Regular installation, except there is no need for any VS dev tools and can be installed system-wide. (Note: Not having Visual Studio 2015 installed might prompt the following error. Downloading Visual Studio 2015 should fix that issue.)
...
Unconfigure Oracle’s GAC with the attached bat file from \\Tc4s0a\groups\AARA\AARAD\NORMS.
...
Install the latest ODT from Oracle’s website.
Note: Although installing Visual Studio 2015 is needed for step 1, the application is run on Visual Studio 2019.
How to get NORMS running locally if there are Oracle issues
How to Create a NORMS User for Development Purposes
Good To Know
Valid Occurrence Number Formats
How-To and Fixes
Production Error Log - Tracking all the production issues to notice trends as they can't be replicated in ACC