EBS invoice approval email is not going to AP team for approval from the workflow.

EBS invoice approval email is not going to AP team for approval from the workflow. I logged in as the APREPORTUSER and checked if the workflow notification was received, but did not find any notification in the application.

I ran below query :

select * from apps.wf_notifications where recipient_role='APREPORTUSER' order by begin_date Desc

I noticed that the mail status column says "mail" for the invoice that was not sent but the sent date is populated.

Could anyone please help me how can i find the root cause of this issue ?

Note : This is an intermittent issue.

Regards,