Hi Jeevi Dandaa
Thanks for reaching out on Microsoft Q&A!
This behaviour is caused by caching in the on-premises data gateway, in specific the SAP .Net (Nco) library. It keeps a copy of the function module for some time (not sure what time). Overnight it most likely should start working again.
One way to force a “refresh” of the cache is by restarting the on-premises data gateway server.
Please click ‘Accept answer’ when you think my answer is helpful. Feel free to drop additional queries in the comments below!
Kind regards,
Sonnt