Bug
An Oracle versioned view does not list ObjectID as a unique identifier in a query layer.
| Bug ID Number | BUG-000084285 |
|---|---|
| Submitted | February 3, 2015 |
| Last Modified | June 5, 2024 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.2.2 |
| Status | Will Not Be Addressed |
Additional Information
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.Workaround
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>_EVWSteps to Reproduce
Bug ID: BUG-000084285
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App