While upgrading from 15.9.2 and Oracle 19c Database to 16.0.2 in two steps:
We launched 16.0.1 install and it has failed with this error message while installing the schema:
Process - table: INV_INVESTMENTS.xml
com.ca.clarity.jdbc.oraclebase.ddc: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified
The root of the problem stems from the ORA-30556 situation, and is indicating a customisation that is on the Database tables. As per oracle forums, there may be CIAI Columns and Indexes Implemented in the Database and which is getting caught on the clarity schema validation phase.
There were custom indexes found against INV_INVESTMENT starting I_*
Drop custom indexes and restart the 16.0.1 upgrade.