Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Case sensitive schema name in Physical layer

Question

Views

Comments

VIJAY Rank 1 - Community Starter

Nov 8, 2016 6:54PM edited Aug 13, 2024 7:18PM in Oracle Analytics Cloud and Server

Hi,

I'm using Oracle Database 12c and OBIEE 12.2.1.1.0.

I have imported a schema named "Person" into the Physical layer and when I right click on a table and View Data, I get the following error:

nQSError: 17001 Oracle Error code 942, message: ORA-00942 table or view does not exist.

The "Require fully qualified table names" in the Connection Pool settings is checked.

Regards.

Vijay