Abbas Di Palma, Shaykh Abbas Di Palma holds a BA and an MA degree in Islamic Studies, and certifications from the Language Institute of Damascus University. He has also studied traditional Islamic sciences in... Answer updated 6 months ago

as salam alaikum

there are ahadith stating that the prayer for the one who have consumed wine will not be accepted for forty days. There is no mention in those ahadith that his dhikr or du'a won't be accepted and actually it is said that such practices can accompany Muslims in all circumstances of life.

In the mentioned case, the person should also not forget to do istighfar and ask forgiveness for the sin that he committed. If he sincerely repents and has resolution of not committing the sin anymore,  Allah is certainly All-Forgiving.

With prayers for your success.