laptop and a wrench

Bug

Creating a join between a feature layer with a table results in the following error, "ORA:00918: column ambiguously defined."

Last Published: September 1, 2016 ArcGIS for Desktop
Bug ID Number BUG-000098835
SubmittedAugust 24, 2016
Last ModifiedMarch 30, 2022
Applies toArcGIS for Desktop
Version found10.2.1
StatusWill 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

After creating the join on the feature class with the table, modify the definition query as follows: (SDE.fc.DEF=17 or SDE.fc.DEF=20) and SDE.fc.UTSTATUS<=4.

Steps to Reproduce

Bug ID: BUG-000098835

Software:

  • ArcGIS for Desktop

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback