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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

We are trying to assign preparer rather than requester for the ConfirmReceiptRequestForAction wf

in Purchasing

Summary:

Hi everyone

We have some users that are creating requisitions for other users.

When the supplier sends us the invoice and we have not received the Purchase Order, the confirmation is being sent to the requester.

This is causing issues because they will click on receive in full not knowing that the PO should be ongoing for multiple years.

Content (please ensure you mask any confidential information):

We have tried to use the following query in the user assign rule but the out of the box variables appears to be empty or blank :
orcl:query-database(Concat('Select pu.username from POR_REQUISITION_HEADERS_ALL prha, po_headers_all pha, po_distributions_all pda, por_req_distributions_all prda, POR_REQUISITION_LINES_ALL prla, po_lines_all pla, per_users pu where pha.po_header_id = pda.po_header_id AND pla.po_line_id = pda.po_line_id AND pda.req_distribution_id = prda.distribution_idAND prda.requisition_line_id = prla.requisition_line_id AND prla.requisition_header_id = prha.requisition_header_id AND pha.po_header_id = pla.po_header_id AND pu.person_id = prha.preparer_id AND pha.po_header_id =', Task/task:task/task:payload/ns0:SingleNotificationKey/ns0:POHeaderId), true(), true(),'jdbc/ApplicationDBDS')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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