Database Software

Hi,

I have a couple of roles that are created as contacts for parties. On querying wf_local_roles
their notification preference is QUERY and MAILTEXT respectively.

select name, description, notification_preference from wf_local_roles
where name in ('HZ_PARTY:4106', 'HZ_PARTY:4107');

NAME DESCRIPTION NOTIFICATION_PREFERENCE
------------- ----------------------------------------------------------- -----------------------
HZ_PARTY:4106 mrs resident QUERY
HZ_PARTY:4107 mrs resident-xxx PARK xxx EAST yyy 11 1111 MAILTEXT

I would like the notification preference to be MAILHTML for HZ_PARTY:4107(This party id is a party relationship). I have tried the following:

1. I updated the wf_local_roles and set the notification_preference to MAILHTML
2. I also tried the following PL/SQL code

declare
myList wf_parameter_list_t;
begin
wf_event.AddParameterToList('ORCLWORKFLOWNOTIFICATIONPREF', 'MAILHTML', mylist);
wf_local_synch.propagate_role(p_orig_system=>'HZ_PARTY',p_orig_system_id=>4107, p_attributes=>mylist);
COMMIT;
end;
/

Both the above methods sets the notification preference to MAILHTML, But on running the concurrent program
"Synchronize WF LOCAL tables" it gets reset to MAILTEXT.

Any pointers on how to do this will be greatly appreciated.

Thx in Advance

Best Regards

Ramdas