Query in OC_JUL2021_ORACLE.sql returns "ORA-00942: table or view does not exist" for query below:
ALTER TABLE OCMETRICNAMEDVIEW
DROP CONSTRAINT UNQ_VIEW_ACCOUNT_IDX1;
This issue is seen when UIM 20.3.0 is not at version 20.3.3
Release : 20.3
Component : UIM - INSTALL
Per Operator Console 20.3.3 July 2021 Patch documentation, UIM 20.3.3 must be installed in order to install OC 20.3.3 monthly patches
See the following statement in link below: Patches Included: These Hotfixes can be applied on Operator Console 20.3.3 or on top of patches released in April/June 2021.