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

How to move a request status from step A to step B?

SOLVED
Go to solution
Highlighted
TurboMan
Member

How to move a request status from step A to step B?

Hi,

 

To move a request status from step A to step B,

I designed a workflow and in the execution step typed the correct parameter values.

In the log I see it run ksc_move_request_workflow  command properly as follows.

 

Beginning command: KSC Move Request in Workflow
Running PL/SQL procedure KCRT_REQUEST_UTIL.MOVE_REQUEST_WORKFLOW
Summary of parameters:
REQUEST_ID=38718
FROM_WORKFLOW_STEP_SEQ=17
EVENT_NAME=FORCE_TRANSITION
RESULT_VISIBLE_VALUE=Succeeded
SCHEDULE_DATE=
DELEGATE_TO_USER_ID=
TO_WORKFLOW_STEP_SEQ=16
Special Command successfully run.

 

But, the request status never changes.

Am I missing something?

 

Thanks in advance

Regards

TM

5 REPLIES
AlexSavencu
Honored Contributor

Re: How to move a request status from step A to step B?

Hi, TurboMan,

 

there is a constraint: the same user which is responsible in step A must be configured in the Security section of the step which executes the move command.

 

cheers

alex


--remember to kudos people who helped solve your problem
TurboMan
Member

Re: How to move a request status from step A to step B?

Thanks Alex,

 

This is not what ı am after.

I get this kind of requests 10-20 times a day.

Users are not very careful, they submit a request and need to move to previous or other steps sometimes.

In this case, my solution is to add a transition button mark as "ADMIN ONLY" so no one can touch it.

When I finished moving the request to another step, I remove the link and button.

I am planning to do this in an Admin screen which will be used just by me.

 

Regards

TM

Celil
Esteemed Contributor
Solution

Re: How to move a request status from step A to step B?

As Alex said the person who is taking action on the request, should have security at both the 'To' and 'FROM' workflow steps. In addition to that maybe RESULT_VISIBLE_VALUE parameter could be written by quotes.

 

usage of command below:

ksc_move_request_workflow

REQUEST_ID="[REQD.P.ID]"

FROM_WORKFLOW_STEP_SEQ="[REQD.P.ELIG_STEP]"

EVENT_NAME="FORCE_TRANSITION"

RESULT_VISIBLE_VALUE="Work_Rejected"

TO_WORKFLOW_STEP_SEQ="7"

 

PS: Please keep alive our forum via kudos the professionals

Celil

IT Governance Professional
& PPM Solution Architect
HCLDB
Acclaimed Contributor

Re: How to move a request status from step A to step B?

Hi,

 

But this is a workflow command that can only be used in workflow.

I want to use this procedure directly in another function. Because I want to move multiple requests, so will pass in a cursor and run in a function.

How can i do that?

I used:

 

exec KCRT_REQUEST_UTIL.MOVE_REQUEST_WORKFLOW(<request_id>,1,<from step seq>,'FORCE_TRANSITION',<transition name from step1 to step2>',null,null, <to step seq>,'Y')

 

but nothing worked. The request is still at first step.

 

Step1 and step2 are decision steps and user id 1 has security access on both the steps.

 

Any help would be appreciated!

 

Regards

Priyanka

Jim Esler
Honored Contributor

Re: How to move a request status from step A to step B?

Check table knta_interface_errors to see if any error messages he been logged there.

//Add this to "OnDomLoad" event