Title: Quality Center is not supported with oracle 10.2.0.4 updated with oracle patch-bundle\mini-patch 2 and beyond
Document ID: KM526588R
Product: Quality Center
The following oracle exception cascaded by the JDBC driver is popping in Quality Center when reviewing the test coverage of the requirements from the Requirements module or trying to issue a report from the Analysis or from the Document Generator:
ORA-00918: column ambiguously defined
Oracle fix for bug# 5368296 has been recognized by Oracle as introducing a regression. This regression occurs on any Oracle 10.2.0.4 server updated with patch bundle 2 and beyond (it also occurs on oracle 11iR1). This regression is registered as bug# 7318276 in oracle support and is supposed to be fixed on patch-bundle 14 for Oracle 10.2.0.4 (and Oracle 11iR2).
Do not upgrade your Oracle server 10.2.0.4 with patch bundle 2 or any higher patch bundle that contains Fix for bug# 5368296 and do not upgrade your Oracle database server to a version higher than 10.2.0.4. Quality Center is not supported on those environments. This may change once we review Oracle fix for bug 7318276 which is supposed to address this regression and that is going to be implemented in Oracle11iR2 and, without any commitment from Oracle, into patch bundle 14 of Oracle 10.2.0.4.
If you did upgrade, uninstall the oracle patch bundle if you have installed a patch bundle containing fix for bug 5368296 or downgrade to Oracle 10.2.0.4 if you have upgrade your oracle server to a higher version (readme files of Oracle patch installations and Oracle upgrades are considering situations where those uninstall and downgrade actions have to be done with detailed directive on how to perform them)