Query layer functionality does not work with z-enabled SDO geometry attributes

Description

Opening a query layer defined with Oracle spatial (SDO) with Z values fails to display in ArcMap.

Cause

Attempting to create a query layer and displaying the layer in ArcMap fails when the spatial attribute has a three-dimensional spatial index. ArcGIS uses a two-dimensional search geometry as input when executing spatial queries in ArcMap. Because the input search geometry is 2D and not 3D, the query fails with a type mismatch. This causes many of the operations in ArcMap to fail, such as panning, zooming and identify.

Workaround