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

Skip Rule not working

Accepted answer
65
Views
4
Comments
edited Feb 23, 2021 1:46PM in Purchasing 4 comments

Summary

We have requirement to reject PO's if Item is Revision Controlled and Revision number not exist on Purchase Order/BPA

Content

I have created one Rule at pre approval stage and selected rule always applies and setup action to auto reject. From BPM define Skip rule for same participant with  below query. But PO's getting auto approved even though Revision number not entered for PO. Can someone help me if the query is correct or not.

orcl:query-database(concat('SELECT count(l.po_line_id) abc FROM po_headers_all h,po_lines_all l,egp_system_items_b e WHERE h.po_header_id = l.po_header_id and  l.ITEM_REVISION is null and l.item_id=e.INVENTORY_ITEM_ID and e.organization_id=''300000002012004'' and e.REVISION_QTY_CONTROL_CODE=''1'' AND h.po_header_id =', /task:task/task:payload/task:DocumentId), true(),true(),'jdbc/ApplicationDBDS') = 0

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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