Procurementpublic

Self Service Procurement

Get Involved. Join the Conversation.

This is a public Forum  public

Topic

    Ashok
    How to use the 'Query-Database' feature in BPM
    Topic posted November 14, 2019 by AshokBlack Diamond: 60,000+ Points, tagged Approvals/Notification, How-To 
    39 Views, 2 Comments
    Title:
    How to use the 'Query-Database' feature in BPM
    Summary:
    How to use the 'Query-Database' feature in BPM
    Content:

    Customers and Support,

    We receive a lot of questions around the requirement to send notifications to users that are not part of the seeded user routing designed in our Self Service Procurement flows. This article, thanks to my colleague Khalil (an expert in approvals), finds its way for your review and explains the feature that you can potentially consider to meet a few of these asks.

    As always, do provide us your feedback, observations and ratings so we can understand if these articles are indeed as helpful as we expect them to be.

    Thanks
    Ashok

    Document:
    Using the Query Database Feature in+BPM task configuration.docx (165KB)

    Comment

     

    • Gopalakrishna Bulasala

      Thanks Ashok. Its really useful.

      But, i have tried this for one of our requirements on sending purchase order creation failure notification to requester as well along Buyer (seeded task sends notification to buyer only).

      Its not working as expected. Can you please help on this.

      Expression used:

      orcl:query-database(concat('select pu.username from po_headers_all pha,po_lines_all pla,po_line_locations_all pll,po_distributions_all pod,fusion.per_users pu where pha.po_header_id=pla.po_header_id and pla.po_line_id = pll.po_line_id and pll.line_location_id=pod.line_location_id and pod.DELIVER_TO_PERSON_ID=pu.person_id and pha.po_header_Id=',/task:task/task:payload/task:DocumentId),true(),true(),'jdbc/ApplicationDBDS')

       

       

      2019-11-14_16-19-41.png (57KB)
    • Ashok

      Gopalakrishna

      I would love to help but Self Service Procurement might not be your go-to here. For best results, you may wish to post this specific question in the Purchasing Forums Lab. The reason is that the data model for Purchasing is something they are innately familiar with and it would be quicker response time for you.

     

    community forum