Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to use the 'Query-Database' feature in BPM for FinExmWorkflowExpenseApproval — Cloud Customer Connect
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

How to use the 'Query-Database' feature in BPM for FinExmWorkflowExpenseApproval

Received Response
35
Views
1
Comments
edited Oct 5, 2020 5:30PM in Expenses 1 comment

Summary

How to use the 'Query-Database' feature in BPM for FinExmWorkflowExpenseApproval - person id

Content

I need help with deriving my code/the syntax for the task expression.

For instance, I am wanting to use a a skip rule on FinExmWorkflowExpenseApproval using Query-Database'  to obtain a flexfield value for foreign national (from HCM table). I was able to get the 'Query-Database' feature in BPM to work for ReqApproval, but i am having trouble with my syntax for FinExmWorkflowExpenseApproval using xpath: person_id, and SQL query database for individual international flag. (i have verified that my sql works).
The only thing i can think of is that this syntax isn't correct /task:task/task:payload/ns7:getExpenseReportVOResponse/ns7:result/ns2:PersonId

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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