How to use SQL query in BPM workflow.
Summary:
We have a business scenario where we would like to use SQL query in BPEL workflow and based on the result, we want to Reject or Approve the workflow.
We tried using the rule oraext:query-database in Skip Rule under Advanced tab. Attached is the document where I have used.
Content (please ensure you mask any confidential information):
Currently we are not using BPA's in our organization. We want to implement that, business want to route Approvals for BPA's on certain conditions. For that we need to execute sql query. For that I used oraext in BPM workflow using skip rule. It saved sucessfully but gave me we error while approving PO. Please advise me on this.
Tagged:
0