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

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))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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