Not sure why this post was closed in december but I can still reproduce the issue in the mongols campaign where it is vital to build rams to kill stone walls.
https://forums.ageofempires.com/t/ranged-units-unable-to-build-rams-campaign/
Here are some additional information:
- only archers might be affected
- reload did not help
- as a workaround I found out that spears could build rams