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

Dynamic Workflow in BPM

in Purchasing 1 comment

Greetings,

We are trying to implement dynamic workflow using BPM but getting error.

Requirement:

In PO header, we have created a DFF. Buyer can select employee name from the LOV and employee id is storing in the value set.

We have added a dynamic approval level in which PO should go to the employee selected in DFF above.

In BPM, we have added a new stage and selecting Assignees as User and adding below query to fetch approver.

orcl:query-database(   concat(     "SELECT pu.username FROM po_headers_all pha, per_users pu WHERE pu.PERSON_ID = pha.attribute_number5 AND TYPE_LOOKUP_CODE in ('BLANKET','CONTRACT') AND PRC_BU_ID = '300000002356434' AND pha.po_header_Id = '",     string(/task:task/task:payload/task:DocumentId),     "'"   ),   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!