This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi All,
We have a requirement to automate the following whenever there is a workflow delegation on the PERSON record:
1. The acting person will inherit the additional security groups of the person who is on vacation/leave.
2. If there are any active workflows, before the delegation is done, should be reassigned to the acting person.
3. After the end date, the reverse of the above two points should be done i.e. any active workflows from the acting person to be reassigned and the additional security groups to be removed from him/her. There is a tricky part over here. I would like to reassign only those assignments which have happened because of the workflow delegation and not the ones which would be normally assigned to the acting person. Is there any way to differentiate these assignments?
4. After the end date, the workflow delegation from the PERSON record should be removed automatically.
I can write a PL/SQL procedure for this, but I would like to know the following:
1. Is there any better way to achieve it?
2. Can a CRON task be scheduled which would call this PL/SQL procedure?
Regards,
If anyone has a solution to this situation, I would like to know too . this
problem comes up over and over again.
Shannon Rot
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
Priyaranjandas
Sent: November-07-12 10:52 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Workflow Delegation - Automation of tasks
Hi All,
We have a requirement to automate the following whenever there is a workflow
delegation on the PERSON record:
1. The acting person will inherit the additional security groups of the
person who is on vacation/leave.
2. If there are any active workflows, before the delegation is done, should
be reassigned to the acting person.
3. After the end date, the reverse of the above two points should be done
i.e. any active workflows from the acting person to be reassigned and the
additional security groups to be removed from him/her. There is a tricky
part over here. I would like to reassign only those assignments which have
happened because of the workflow delegation and not the ones which would be
normally assigned to the acting person. Is there any way to differentiate
these assignments?
4. After the end date, the workflow delegation from the PERSON record should
be removed automatically.
I can write a PL/SQL procedure for this, but I would like to know the
following:
1. Is there any better way to achieve it?
2. Can a CRON task be scheduled which would call this PL/SQL procedure?
Regards,
>> The acting person will inherit the additional security groups of the person who is on vacation/leave.
Beware of you licensing agreement! You may have to deactive the user that goes on vacation.
>> I would like to reassign only those assignments which have happened because of the workflow delegation and not the ones which would be normally assigned to the acting person. Is there any way to differentiate these assignments?
The WFASSIGNMENT table would have two entries for this. Say the Workflow task should be for Suzie, and it is set to forward to Bill. When a Workflow hits this Task Node, it puts an entry into WFASSIGNMENT for:
Assigncode = SUZIE
Origperson = SUZIE
Assignstatus = FORWARDED
WFID = 123456 <some number>
NodeID = 78 <some number>
and a second entry for:
Assigncode = BILL
Origperson = SUZIE
Assignstatus = ACTIVE
WFID = 123456 <some number, same number as above>
NodeID = 78 <some number, same number as above>
Hopefully that info can help you some.
Travis Herron
--- In MAXIMO@yahoogroups.com, "Incomm Solutions Inc." <shannonrotz@...> wrote:
>
> If anyone has a solution to this situation, I would like to know too . this
> problem comes up over and over again.
>
>
>
>
>
>
>
> Shannon Rot
>
>
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
> Priyaranjandas
> Sent: November-07-12 10:52 PM
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Workflow Delegation - Automation of tasks
>
>
>
>
>
> Hi All,
>
> We have a requirement to automate the following whenever there is a workflow
> delegation on the PERSON record:
>
> 1. The acting person will inherit the additional security groups of the
> person who is on vacation/leave.
>
> 2. If there are any active workflows, before the delegation is done, should
> be reassigned to the acting person.
>
> 3. After the end date, the reverse of the above two points should be done
> i.e. any active workflows from the acting person to be reassigned and the
> additional security groups to be removed from him/her. There is a tricky
> part over here. I would like to reassign only those assignments which have
> happened because of the workflow delegation and not the ones which would be
> normally assigned to the acting person. Is there any way to differentiate
> these assignments?
>
> 4. After the end date, the workflow delegation from the PERSON record should
> be removed automatically.
>
> I can write a PL/SQL procedure for this, but I would like to know the
> following:
>
> 1. Is there any better way to achieve it?
> 2. Can a CRON task be scheduled which would call this PL/SQL procedure?
>
> Regards,
>
>
>
>
>
>
>