Identify doesn't work when using views in Oracle (bug?)

Discussion created by mbhansen on Dec 28, 2012
Latest reply on Mar 12, 2018 by ppapadopoulosmarathondata-gr-esridist
The Identify/info function in ArcMap (or via javascript API in a web application) doesn't work when using a View in Oracle.

Identify works fine on a simple feature class (eg. "MyFeatureClass" with an ID, a shape and a text attribute column), but when I create a simple view, eg. "SELECT * FROM MyFeatureClass", the identify function doesn't give any result, no matter where I click.

Both the feature class and the view are created via ArcCatalog in ArcMap.

The problem was identified using ArcGIS Server and the Javascript ArcGIS API, but the same problem exists using ArcMap directly on the database connection.

If I use the exact same setup, but with SQL Server instead of Oracle, the problem dissapears.

I am using ArcGIS 10.1.

Is it a bug in ArcGIS 10.1 (in connection with Oracle)?