The problem was, payments app was not included in the apps.json list. Hence installation failed.
I observed that bench --site sitename install-app command wasn’t working without erpnext installed during the bench new-site.
I will post further updates if any other observation comes in between