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

SQL-based approval rules support for the AP Invoice approval process (FinApInvoiceApproval)

in Inventory Management

Summary:

BPM: FinApInvoiceApproval

Getting error when using below SQL for Sequential Participant Asignees based on Name and Expressions.

Name and Expression User:

oraext:query-database-with-bindvar(‘select pha.attribute2 from PO_HEADERS_ALL pha,ap_invoices_all aia where aia.po_header_id = pha.po_header_id and aia.invoice_id= :bind_header_id’,true(),true(),’jdbc/ApplicationDBDS’,concat(‘bind_header_id=’,/task:task/task:payload/ns2:findInvoiceHeader1Response/ns2:result/ns1:Value/ns1:InvoiceId))

Gettting below error

exception.code:30049 exception.type: ERROR exception.severity: 2 exception.name: Error in routing slip. exception.description: The task is assigned to an invalid user orcl:query-database(concat('select pha.attribute2 from po_headers_all pha in realm jazn.com. The routing slip is associated with the task definition default/FinApInvTransactionsInvoiceApprovalComposite!11.13.25.04.0/FinApInvoiceApproval. exception.fix: Verify that the user is specified correctly in the routing slip in the task definition.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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