Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BPM Dynamic Task Assignment based on SQL query

Vladimir ZhilyaevFeb 16 2016 — edited Mar 10 2016

Hi, gurus

I have big problem with Task Assignment. Many people can to initiate my process. And based on initiator I'm must to assign task to an responsible employee.

e.g:

If initiator of my process = employee of Department 1 in India then to assign responsible employee from Department 1 in India.

. . .

If initiator of my process = employee of Department N in Japan then to assign responsible employee from Department N in Japan.

I have sql query which get responsible employee for initiator.

Question is how I can use my sql query in my process to find and assign to responsible employee?

I read some articles about dynamic task assignment but it not my case https://technology.amis.nl/2014/03/24/humantask-assignment-assignment-with-dynamic-approval-group/

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2016
Added on Feb 16 2016
11 comments
3,030 views