PROBLEM
Attempting to generate a feature layer using the 'Add XY data' tool fails if the XY table has another table joined to it.
This is a known issue.
Note:
If your data is in an ArcSDE server, and is registered with the geodatabase, this problem will still occur.
Get help from ArcGIS experts
Download the Esri Support App