Database Software

Hi

I have a workflow, in which I pass the names of performers (people who should receive notification) at run time through an Item Attribute.

Before sending the notification, a stored procedure is executed that creates Ad-hoc role using wf_directory.CreateAdHocRole and assigns users to this role using wf_directory.AddUsersToAdHocRole:-

wf_directory.CreateAdHocRole( role_name => v_role_name
,role_display_name => v_role_display_name
,language => NULL
,territory => NULL
,role_description => 'ROLE DESC'
,notification_preference => 'MAILTEXT'
,role_users => v_Recipients -- Comma or space delimited list
,email_address => null
,fax => null
,status => 'ACTIVE'
,expiration_date => null
,parent_orig_system => null
,parent_orig_system_id => null
,owner_tag => null
);

wf_directory.AddUsersToAdHocRole(role_name => v_role_name,
role_users => v_Recipients);

The v_Recipients is an item attribute (Recipients) got using wf_engine.getitemattrtext. The performer for workflow is also specified as the item attribute 'Recipients'.

Now, my workflow runs fine when notification is being sent to one user.
But, when I try to send it to 2 or more users, I hit the error:-

Failed Activity NOTIFICATION
Activity Type Notice
Error Name WFNTF_ROLE
Error Message 3205: '<user1>,<user2>' is not a valid role or user name.

Please note that I have also run "Synchronize WF LOCAL tables" Concurrent program. But, that also does not help.

What am I missing?

Thanks
Ajay K. Garg