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

Skip Query in Oracle Fusion HCM BPM workflows is not working

in Reporting and Analytics for HCM

Summary:


Hi All,

We want to skip the approval step if the approver is the CEO. We tried using the below query; however, it is neither skipping the hardcoded person nor working correctly. Instead, it throws an error when the workflow reaches that participant level.

'abc@xyz.com' = oraext:query-database(concat("select username from per_users where person_id=300000003752069"),false(),false(),"jdbc/ApplicationDBDS")

BPM Worklist task name: VariableAllocationTask

We have also tried the below queries in the skip rule/query,

oraext:query-database(concat("select count(*) from (select username from per_users where person_id=300000003752069)"),false(),false(),"jdbc/ApplicationDBDS")=1

task:task/task:systemAttributes/task:assigneeUsers/task:displayName = 'xxxx'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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