Indirect Responsibility assignment.
In some organizations, role based responsibilities will be given instead of direct responsibility assignment. To assign an indirect responsibility you can use below API.
In some organizations, role based responsibilities will be given instead of direct responsibility assignment. To assign an indirect responsibility you can use below API.
Begin
Wf_local_synch.PropagateUserRole(
p_user_name => 'XXUSER',
p_role_name => <Role>,
p_start_date=>'03-APR-18',
p_expiration_date=>null);
commit;
End;
To get list of active role assignments for a particular role:
select distinct assigning_role from wf_user_role_assignments
where user_name='XXUSER'
and end_date is null;
