You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there a way to add PR Requestor to the AwardApprovalStatusFYI BPM Notification Task

edited Mar 17, 2025 7:52AM in Sourcing 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!