Error when using skip rule on negotiations award approvals
Summary:
We are using a skip rule for award approval.
All award negotiations are ending up as Automatically Rejected, not respecting the skip rule conditions.
BPM > Task Configuration > Award Approval > Assignee > Advanced > Specify skip rule
oraext:query-database(concat("SELECT count(*)FROM PON_AUCTION_HEADERS_ALL PAH, PON_AUCTION_ITEM_PRICES_ALL PAI, POR_REQUISITION_HEADERS_ALL PRH, POR_REQUISITION_LINES_ALL PRLWHERE 1=1AND PAH.AUCTION_HEADER_ID = PAI.AUCTION_HEADER_IDAND PRH.REQUISITION_NUMBER = PAI.REQUISITION_NUMBERAND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_IDAND PAI.requisition_number = PRH.requisition_numberAND PRL.AUCTION_HEADER_ID = PAI.AUCTION_HEADER_IDAND PRL.AUCTION_LINE_NUMBER = PAI.LINE_NUMBERand (select ((SUM (PRL2.UNIT_PRICE * PRL2.QUANTITY) * 10) /100 ) + SUM (PRL2.UNIT_PRICE * PRL2.QUANTITY) REQ_porcentagem from POR_REQUISITION_LINES_ALL PRL2 where PRL.REQUISITION_HEADER_ID = PRL2.REQUISITION_HEADER_ID )<= (select SUM (PAI2.BEST_BID_PRICE * PAI2.AWARDED_QUANTITY) NEG_AMOUNT2 from PON_AUCTION_ITEM_PRICES_ALL PAI2 where PAI.AUCTION_HEADER_ID = PAI2.AUCTION_HEADER_ID)and PAH.AUCTION_HEADER_ID = ", /Task/task:task/task:payload/ns1:findAwardApprovalHeaderVOResponse/ns1:result/ns2:AuctionHeaderId,"))"),true(),true(),'jdbc/ApplicationDBDS')=1))