Can SQL Or Subqueries In Be Used In ?Workflow Task Configuration (Doc ID 1572888.1)

Last updated on FEBRUARY 06, 2015

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.5.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Goal

In the BPM worklist where you configure the workflows, can you use an SQL or a subquery in the IF clause.
For example:

IF task.payload....assignmentID in (select assignment_ids from where...)
THEN
...

Is there any provision like above?


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms