My Oracle Support Banner

AP Invoice Approval - New Participant Using SQL And XPATH Expressions (Doc ID 2690893.1)

Last updated on AUGUST 01, 2020

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Goal

AP Invoice Approval - New Participant using SQL and XPATH expressions

For FinApInvoiceApproval, trying to derive an approver by adding a new participant, and creating asignees based on names and expressions. The asignees type is User, and issuing a query using the following variable:(/task:task/task:payload/ns2:findInvoiceHeader1Response/ns2:result/ns1:Value/ns1:InvoiceId).

The type of the expression was updated from STATIC to XPATH in the task definition file from the SOA composite.

After submitting an invoice for approval, the approval errors out with the following message:'The XPath expression failed to execute; the reason was: oracle.xml.sql.OracleXMLSQLException: ORA-00936: missing expression.'

When following the same approach but hardcoding an invoice_id, as opposed to using the variable, the approval works as expected.

Why is the variable(/task:task/task:payload/ns2:findInvoiceHeader1Response/ns2:result/ns1:Value/ns1:InvoiceId) is not returning the invoice id?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.