Oracle Adapter Connection test fails with error ORA-00904: "V"."BANNER_FULL": invalid identifier
Article ID: KB0071127
Updated On:
| Products | Versions |
|---|---|
| ibi WebFOCUS | WebFOCUS 9.1.0 and higher |
Description
Symptoms
Receiving Error message:
ORA-00904: "V"."BANNER_FULL": invalid identifier
During Test Adapter Connection when configuring Oracle 18c, 19c, or 21c Adapter with Oracle 11g, 12c as a Target database
Environment
Windows, Linux
Resolution
Cause:
The "BANNER_FULL" column, used by the Oracle Adapter Test query, was introduced by Oracle from 18c releases. Prior Oracle releases were using the "BANNER" column.
The "BANNER_FULL" column, used by the Oracle Adapter Test query, was introduced by Oracle from 18c releases. Prior Oracle releases were using the "BANNER" column.
Issue/Introduction
Oracle Adapter Connection test fails with error ORA-00904: "V"."BANNER_FULL": invalid identifier
Additional Information
Refer the below Article for more information
Oracle Adapter Connection Test fails while configuring against Oracle 11g or 12c databases
Oracle 18c - Database Reference - 9.129 V$VERSION
https://docs.oracle.com/en/database/oracle/oracle-database/18
Oracle Adapter Connection Test fails while configuring against Oracle 11g or 12c databases
Oracle 18c - Database Reference - 9.129 V$VERSION
https://docs.oracle.com/en/database/oracle/oracle-database/18
Feedback
Yes
No
Powered by
