Error while using SQL Condition for Skip Approval in Payment Approvals – Namespace Prefix 'orcl'

8:11AM

We are encountering an error while configuring the Skip Approval condition using a SQL condition for Payment Approvals (Payment Process Request) in Oracle Fusion.

When the SQL condition is evaluated, the approval workflow fails with the following error:

Error:“Namespace prefix 'orcl' used but not declared.” We tried the following different approaches while configuring the Skip Approval condition; however, none of them are working:

a. orcl:query-database(concat('select 0 from iby_pay_service_requests ipsr WHERE payment_service_request_id=',/task:task/task:payload/ns8:findPaymentProcessRequestResponse/ns8:result/ns7:PaymentServiceRequestId),true(),true(),'jdbc/ApplicationDBDS')=0

b. orcl:query-database(concat('select 0 from iby_pay_service_requests ipsr WHERE payment_service_request_id=',/task:task/task:payload/ns8:getPaymentProcessRequestResponse/ns8:result/ns7:PaymentServiceRequestId),true(),true(),'jdbc/ApplicationDBDS')=0

Error while using SQL Condition for Skip Approval in Payment Approvals – Namespace Prefix 'orcl'

Howdy, Stranger!