The database migration to 7.0.2 GA (or P01) can fail with the following error:
ORA-00001: unique constraint (AVUSER.UK_T_VIEW_DEF_VIEW_ID) violated ORA-06512: at line 24
The migrate.log will show the error during the running of the script /home/oracle/wildfly/standalone/tmp/vfs/temp/temp485174e0d2634b4f/content-4ac86bd61b8cb9d2/contents/aveksa.war/WEB-INF/database/Upgrade/Initialization/update/ACM-00092.sql.
Note: The location listed above will be different for every customer and through every ACM restart.
There was a change in review definition views that affected Group by Application (now called Group by Business Resource in new installations) that will affect customers upgrading from 7.0.1 P05.
To resolve this issue,
Download the attached SQL script from a later patch of 7.0.2.
Rename the downloaded file and replace the original in /home/oracle/database/database/Upgrade/Initialization/update/ACM-00092.sql. For example: