BPM - RcvSelfSvcReceiptTask - SQL Query - The HWF is assigned to an invalid user

Summary:

Hi Everyone,

We are customizing the BPM Task - RcvSelfSvcReceiptTask.

In the assignees tab, we selected 'Name and Expression' and added User and passed xpath expresssion with dynamic sql query. It did not work. (Screenshot - 1)

 Xpath query:

orcl:query-database("SELECT username FROM per_users WHERE username = 'karthick@gmail.com'", false(), false(), "jdbc/ApplicationDBDS")

Error: The HWF is assigned to invalid user.

We also have an observation that Xpath Expression builder is not opening for RcvSelfSvcReceiptTask. (Screenshot 2)

Valid username 'karthick@gmail.com' is available and verified in the Fusion Security Console.

Later, we tried hardcoding with plain string - karthick@gmail.com instead of xpath query, it worked. (Screenshot 3)