Not able to use query in the BPM Approval RuleSet
I am trying to use the simple query in the Ruleset , i am getting the below error in AP Invoice workflow. Please suggest how to resolve the issue
Query : orcl:query-database(concat('select aia.created_by from ap_invoices_all aia WHERE aia.invoice_id=',/Task/task:task/task:payload/ns2:findInvoiceHeader1Response/ns2:result/ns1:Value/ns1:InvoiceId),true(),true(),'jdbc/ApplicationDBDS')
Error : exception.name: Error in routing slip.
exception.description: The task is assigned to an invalid user orcl:query-database(concat('select aia.created_by from ap_invoices_all aia where aia.invoice_id=' in realm jazn.com. The routing slip is associated with the task definition default/FinApInvTransactionsInvoiceApprovalComposite!14045709_33955769/FinApInvoiceApproval.