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)?