Oracle BPM skip condition for Invoice Approvals having to choose Serial or Parallel task in a Stage

Summary:

During Invoice approval, for a Set of requesters, parallel approval (Approval group) where anyone can approve, and for the rest of the Requester base, the invoice needs to be approved solely by the Requester.

Skip condition binding the invoice id is planned to use, however, the approval fails during execution.

Content (please ensure you mask any confidential information):

Skip db bind query on the Serial task:

orcl:query-database-with-bindvar('select count(PERV.person_id)
from ap_invoice_lines_all ail, ap_invoices_all aih,
per_person_names_f_v PERV ,PER_USERS pu
where aih.invoice_id = ail.invoice_id