For the version 12.0 upgrade, a series of grants must be given to a DBA_USER.
After creating the grants, you must then run the grant section of the 00cu120i.sql
script to grant all the necessary privileges. See Step 4. Upgrading the database for more information.
When completing a fresh HxGN EAM installation, there is a larger series of grants that must be run.
See information on creating the EAM database user in the HxGN EAM Oracle Database Installation and Upgrade Guide.