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.
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