Highlighted
Absent Member.. Absent Member..
Absent Member..
1019 views

Mass Demand Request Cancel

Jump to solution

(HP PPM 9.11)

 

We are in the midst of cleaning up open requests that have been allowed to languish without being closed out.  I'd like to just run a batch process to cancel them (there are over 3000).  Does anyone know of a way to take a set of request numbers and force them to cancel (either through a UI or Oracle)?

 

Thanks!

Tags (2)
0 Likes
1 Solution

Accepted Solutions
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

You can do this by populating KWFL_TRANSACTIONS_INT with the request IDs that you want to cancel, use INSTANCE_SET_CANCEL as the Event, and run the Workflow Transaction Open
Interface. Check out the Open Interface guide...they have a PL/SQL block in there you can modify & use.

View solution in original post

0 Likes
5 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

You can do this by populating KWFL_TRANSACTIONS_INT with the request IDs that you want to cancel, use INSTANCE_SET_CANCEL as the Event, and run the Workflow Transaction Open
Interface. Check out the Open Interface guide...they have a PL/SQL block in there you can modify & use.

View solution in original post

0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Eric, I know this is a couple years old, but the actual Request Number - does that go into the 

TRANSACTION_ID column of the KWFL_TRANSACTIONS_INT table?

Then the EVENT column is set to INSTANCE_SET_CANCEL.

Per the documentation, there will also need to be a group_id set.  Is anything else mandatory?

 

Thanks,

Steve Duncan

 

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Hi, Steve,

 

there is a much simpler option for you: use the ksc_move_request_workflow PL/SQL procedure.

 

You can find all required information in the Commands and Tokens Guide.

 

cheers

alex


--remember to kudos people who helped solve your problem
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Got it - thanks Alex.

I have managed to get a report set up to use this functionality.  Works just fine!

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Wanted to renew this discussion.   Can anyone comment on how they manage cleaning up old unsubmitted requests or reports?   Do you leave them  or build a report to clean up unsubmitted reports or requests using ksc_move_request_workflow PL/SQL procedure?   Was wondering how that works?   

 

Did you setup option to auto cancel unsubmitted requests older than xx days old?   

 

Is it possible to run a query of unsubmitted requests and pipe that into a cleanup procedure?

 

 

 

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.