Project and Portfolio Management Practitioners Forum
cancel

ksc_move_request_workflow doen't cancel a request

Highlighted
Alexander (Sua)
Super Contributor.

ksc_move_request_workflow doen't cancel a request

Hello
I have a requirement to close child requests by in an event in parent one.
I made execution step to cancel child requests:
1. Get the Req number and store it to a hidden field
2. Get child request workflow step number and store it into hidden field
3. Call ksc_move_request_workflow REQUEST_ID="[REQD.VP.REQ_NUMBER]" FROM_WORKFLOW_STEP_SEQ="[REQD.VP.STEP_NUMBER]" EVENT_NAME="INSTANCE_SET_CANCEL"

In execution log I see that step has success result but nothig happen

What did I do worng?
11 REPLIES
Alexander (Sua)
Super Contributor.

Re: ksc_move_request_workflow doen't cancel a request

Here is command log:

Running PL/SQL procedure KCRT_REQUEST_UTIL.MOVE_REQUEST_WORKFLOW
Summary of parameters:
REQUEST_ID=31281
FROM_WORKFLOW_STEP_SEQ=4
EVENT_NAME=INSTANCE_SET_CANCEL
RESULT_VISIBLE_VALUE=
SCHEDULE_DATE=
DELEGATE_TO_USER_ID=
TO_WORKFLOW_STEP_SEQ=17
Special Command successfully run.
Jim Esler
Acclaimed Contributor.

Re: ksc_move_request_workflow doen't cancel a request

Be sure the user id used when executing this step has security access on the From Step in the child request.
Alexander (Sua)
Super Contributor.

Re: ksc_move_request_workflow doen't cancel a request

I tried this
I set all users rights to cancel request in child request type security settings

Doesn't help (((
Jim Esler
Acclaimed Contributor.

Re: ksc_move_request_workflow doen't cancel a request

Look at the Security tab for the workflow step that is currently active. The user needs to be included in that list.
Alexander (Sua)
Super Contributor.

Re: ksc_move_request_workflow doen't cancel a request

It doesn't help

Also I tried following command
ksc_move_request_workflow FROM_WORKFLOW_STEP_SEQ="1" EVENT_NAME="APPROVAL_DELEGATE" DELEGATE_TO_USER_ID="[REQD.P.DELEGATE_TO]"
The goal - to solve problem that PPM doesn't send notofocation to users if they set via delegation and it's impossible to filter users in user list while choosing whom to delegate

The result of the command is ...
Running PL/SQL procedure KCRT_REQUEST_UTIL.MOVE_REQUEST_WORKFLOW
Summary of parameters:
REQUEST_ID=30717
FROM_WORKFLOW_STEP_SEQ=2
EVENT_NAME=APPROVAL_DELEGATE
RESULT_VISIBLE_VALUE=
SCHEDULE_DATE=
DELEGATE_TO_USER_ID=100105
TO_WORKFLOW_STEP_SEQ=
Special Command successfully run.

But noting happend
kerimkilic
Trusted Contributor.

Re: ksc_move_request_workflow doen't cancel a request

u need to set result_visible_value to something also
Alexander (Sua)
Super Contributor.

Re: ksc_move_request_workflow doen't cancel a request

Documentation says that it's not necessary for delegation and I also tried - doesn't help
Jamie Pick
Super Contributor.

Re: ksc_move_request_workflow doen't cancel a request

One of the other things you can try, for debugging purposes, is using the itg_pr.kcrt_request_util.move_request_workflow utility. We've used this successfully several times now. Once complete, the results can be verified in the following tables
knta_interface_errors
kwfl_transactions_int

Perhaps the special command "ksc_move_request_workflow" results can be verified in these tables as well?

Thanks,

Jamie
VarunS
Trusted Contributor.

Re: ksc_move_request_workflow doen't cancel a request

I am able to cancel request using the attached SQL block you can use it too.

If you pass INSTANCE_SET_CANCEL as event it will cancel the request.

You have to apps visible result value also even you are cancelling it.
Alexander (Sua)
Super Contributor.

Re: ksc_move_request_workflow doen't cancel a request

Thanks a lot. I'll give a feedback when I try.
Alexander (Sua)
Super Contributor.

Re: ksc_move_request_workflow doen't cancel a request

Thanks. Desrived suggestion works.
And what I noticed (while testing different combinations)
If child request is moving belong simple workflow (just one step) everything works, but
if child requests are working belong real workflow and stay on different steps - command doesn't work at all.