I am trying to create a report that shows all Fulfillment Groups in Workflow Activities in an effort to find assignment groups that are no longer in use. I had set this report up in the past and it was working, but today I found out that it is no longer working. When the report is opened nothing is reported and the "Columns" slushbucket is gone. I recreated the report, and it was working up until I added the Fulfillment Group column (Variables.Catalog Task.Fulfillment Group) at which point, the report broke again. Here are the configurations for my report before it is run.
Here is what happens once the report is run:
Is this a bug or am I selecting the Fulfillment Group wrong somehow?
Well, here it is a couple of years later and I just noticed the question from shane_davis.
To find all the places where a group is used as a fulfillment group in a workflow, use the following link. Then adjust the query to use the sys_id of the group of interest.
The steps to find the actual workflow are still convoluted, but here are the steps ( I think! )
- Use the link immediately above to display the variables for the group
- Open one sys_variable_value record of interest. And click on the ID variable’s icon:
- Note the stage and the workflow version:
These correspond with the workflow and the task in the workflow:
