BUG-000108231 for ArcGIS for Desktop

Bug ID Number	BUG-000108231
Submitted	September 21, 2017
Last Modified	June 5, 2024
Applies to	ArcGIS for Desktop
Version found	10.5.1
Operating System	Windows OS
Status	Will Not Be Addressed

Additional Information

This behavior is expected. When the properties of an unregistered object (table or view) are queried, the values derived from the first record are used for the entity type and spatial reference. Creating a query layer, or registering the object with the geodatabase allow you to chose a different entity type. From http://desktop.arcgis.com/en/arcmap/latest/manage-data/databases/databases-and-arcgis.htm "The first row of the table is used to determine the geometry type (point, multipoint, line, or polygon), spatial reference, and dimensionality (that is, 2D or 3D). "

Workaround

1) If data is not in SDO_Geometry- Ensure the first record in a multipoint feature class table is not a singular geometry / is multipoint in nature.2)Register the view with the geodatabase and select "Multipoint" during registration. However there have been inconsistent issues registering SDO_Geometry views that are incorrectly created as "Point" geometry types with the geodatabase as "Multipoint"