Is there a way to add PR Requestor to the AwardApprovalStatusFYI BPM Notification Task
Summary:
Is there a way to add PR Requestor to the AwardApprovalStatusFYI BPM Notification Task
Content (please ensure you mask any confidential information):
We have a requirement to notify the Purchase requisition requestor about the Negotiation Award Approval Status.
We are trying to add a custom user to BPM task using the sql query but not able to achieve the requirement.
Below are the queries we used to get the requestor but seems like some syntax issues.
Query 1: with bind variable
oraext:query-database-with-bindvar("SELECT RTRIM(LISTAGG(DISTINCT PU.USERNAME, ','), ',') USER_NAME from pon_auction_headers_all pah,pon_backing_requisitions pbr ,por_requisition_headers_all prh ,per_users pu
0