An Oracle versioned view does not list ObjectID as a unique identifier in a query layer.
Last Published: August 27, 2015ArcSDE/Enterprise Geodatabase
Bug ID Number
February 3, 2015
October 20, 2021
Will Not Be Addressed
The development team has considered the issue or request and concluded it will not be addressed. The issue's Additional Information section may contain further explanation.
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.
Use CAST to change the field type of the ObjectID field to integer (INT) if the versioned view needs to be displayed in a query layer. For example, if the original query layer is the following: select objected, shape from <schema>.<featureclassname>_EVW Replace it with the following and use the new field (objectid_INT) as the unique identifier: select CAST(ObjectID as INT) as ObjectID_INT, shape from <schema>.<featureclassname>_EVW