Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Sending a request from one step to another

SOLVED
Go to solution
Highlighted
Cris Robin
Regular Collector

Sending a request from one step to another

Hello

I got number of request that I need to move them (one-time) from one step to another from the back-end.

How cane it be done?
Is the "Workflow Transaction Open Interface" got something to do with it?
If yes, I really do not understand how.

Please advice

Sagi
15 REPLIES
B Swanson
Regular Collector

Re: Sending a request from one step to another

There are functions in the KCVS_UTILITIES package that move requests from one step to another in a workflow.

I'll try to attach the package for version 6.0 here. In version 7.1 you'll need to comment out a couple of the functions in the package as they are no longer valid with the new database schema. However, the others should work.
Varun Singh
Regular Collector

Re: Sending a request from one step to another

KCVS_UTILITIES.MOVE_REQUEST_IN_WF(P_REQUEST_ID => V_SIGN_OFF_REQ_ID,
P_USER_ID => 1,
P_FROM_WORKFLOW_STEP_SEQ => '10',
P_TO_WORKFLOW_STEP_SEQ => '18',
P_RETURN_STATUS => 'Approved',
P_EVENT => 'FORCE_TRANSITION',
P_RUN_INTERFACE => 'TRUE');


Here is an example shows how you can achive the same.
Attahing a KCVS Utilities
If you need to do in the bulk, call this procedure in database with passing request ID. Let me know if u need more help on this
Arguing with a fool, proves there are two
Lizabeth
Regular Collector

Re: Sending a request from one step to another

Cris,

In 7.1, there is a functionality called as 'Batch Update',(seen when we search for requests) you could use that only if you have the appropriate workflow step security .

Thanks
Semenov Alexand
Esteemed Contributor

Re: Sending a request from one step to another

Hi all
I have same problem
HI.
For example, there is a table component in which the set of requests is done. They are necessary for moving.
I use following function:
move_multiple_request_in_wf
(p_request_id => [REQD.T.PR_TABLE_PLAN.TC.P.ZNI_TABLE_NOMER]
,p_user_id => [SYS.USER_ID]
,p_from_workflow_step_seq => 4
,p_to_workflow_step_seq => 6
,p_return_status => 'Testing'
,p_event => 'FORCE_TRANSITION'
,p_run_interface => 'TRUE'
,p_group_id => 1)
in this token stored requests ID '[REQD.T.PR_TABLE_PLAN.TC.P.ZNI_TABLE_NOMER]'
PPM send Orale error
Whats wrong?
Cris Robin
Regular Collector

Re: Sending a request from one step to another

Hello

I can download the zip file but it say it is not an archive so I can not open it.
I got the original KCVS_UTILITIES but when I run it on the 7.1 it gives a lot compile errors so I believe a lot of the table just do not exist any more.

Can you upload just the function for the move_request?

Can anyone elaborate on the batch_update subject.
I fail to find material on that subject.

Thank you
Sagi
Darshan Bavisi
Occasional Visitor

Re: Sending a request from one step to another

Hi Sagi,

The KCVS_UTILITIES is decommissioned from version 7.1 onwards. It has been replaced with special commands. There is a special command ksc_copy_request that does the same thing.

If you still want to use the KCVS_UTILITIES in 7.1, then you can request HP to provide the 7.1 version of KCVS_UTILITIES, which, as far as I know, is not distributed by HP usually now due to the introduction of the special commands to do the same thing and also because as such it is decommissioned. I believe HP recommends not to use 6.0 version of KCVS_UTILITIES anymore, so you may be able to get 7.1 version of it from HP once you explain your issues.
Cris Robin
Regular Collector

Re: Sending a request from one step to another

Thank you

i just need to jump some request from one step to another not as a single use and i do not see another way to do so.

Please advice

Sagi
Semenov Alexand
Esteemed Contributor
Solution

Re: Sending a request from one step to another

HI Cris.
Try this standart command
ksc_move_request_workflow REQUEST_ID="31147"
FROM_WORKFLOW_STEP_SEQ="1"
EVENT_NAME="FORCE_TRANSITION" RESULT_VISIBLE_VALUE="Decissions"
TO_WORKFLOW_STEP_SEQ="7"

This coomand must be rum from WF step With Execution type "WF step command".
I for a long time use this command and it works correctly.
Good Luck.
Cris Robin
Regular Collector

Re: Sending a request from one step to another

Thank you

Can i just open a new workflow to do this? with a new "demo" request type?
Semenov Alexand
Esteemed Contributor

Re: Sending a request from one step to another

Yes
Cris Robin
Regular Collector

Re: Sending a request from one step to another

thank you very much.
this work like a charm.
what if i need to send a request from a step in a sub-workflow to a step in the main workflow?
can it be done?

thank you again.

Sagi
Semenov Alexand
Esteemed Contributor

Re: Sending a request from one step to another

Hi Cris
If you need move request from sub wf to main wf use this

1.WF step for sub wf
ksc_move_request_workflow REQUEST_ID="31147"
FROM_WORKFLOW_STEP_SEQ="5.1"
EVENT_NAME="FORCE_TRANSITION" RESULT_VISIBLE_VALUE="Decissions"
TO_WORKFLOW_STEP_SEQ="5.8"
This step moves request in sub wf
5.8 last step in wf

2.WF step for main wf
ksc_move_request_workflow REQUEST_ID="31147"
FROM_WORKFLOW_STEP_SEQ="5"
EVENT_NAME="FORCE_TRANSITION" RESULT_VISIBLE_VALUE="Decissions"
TO_WORKFLOW_STEP_SEQ="8"

(step 5 - SubWF)
Total it is necessary for you to create two steps

Good luck
Cris Robin
Regular Collector

Re: Sending a request from one step to another

Thank you very much
eadscasa
Occasional Contributor

Re: Sending a request from one step to another

Hi, i've a question respect a this situation, i would try to reopen a request, i try to applying the function:
move_request_workflow
(p_request_id
,p_user_id
,p_from_workflow_step_seq
,p_event
,p_result_visible_value
,p_schedule_date
,p_delegate_to_username
,p_to_workflow_step_seq
,p_run_interface )
and doesn't return the result like expect, this function works fine when the request is in any step except in step complete, someone can tell me why? or any kind the support for realize this reopen request.

Thanks!
Linda Hauck
Regular Collector

Re: Sending a request from one step to another

We have successfully used the ksc_move_request_workflow to advance a workflow from one step to another. This was needed because of a couple of requests that were "stuck" in a workflow due to a bug in a new change type implementation.
It works very well. One point to note is that there must be administrator security access on the starting step.
//Add this to "OnDomLoad" event