mail not send to preparer after WF_ITEM REQAPPRV completes APPROVAL
Email is not sent to the preparer/submitter of the purchase requisition after the purchase requisition is approved.
the WF notification table has an entry. the output is from bde_wf_item.sql
Subject:Purchase Requisition 50179 has been approved
RECIPIENT_ROLE: SCOTT.TIGER
STATUS: OPEN
MES_TYPE:REQAPPRV
MAIL_STAT is NULL (expecting it to be SENT')
FROM_USER: Tiger Scott
TO_USER: Scott Tiger
CALLBACK : WF_ENGINE.CB
This is happening only with RECIPIENT_ROLE: SCOTT.TIGER other are receiving emails.
regards