Hi ,

Once we got a tedious job to disable the responsibilities for 500 users. So we decided to use the API. This can be done using the API mentioned below.



Begin
fnd_user_pkg.delresp(
'&User_Name',
'&Responsibility_application_short_name',
'&Responsibility_Key',
'&Security_Group');
commit;
End;

Ex :

exec fnd_user_pkg.DELRESP('A00073','MFG','LGEIL_NOIDA_MFG_RK','STANDARD')

But above mentioned API has a bug also (Bug 4600645 ) i.e. it sets both start_date and end_date to sysdate . This might cause problem during auditing.

So , in this case API mentioned below can also be used . In this you are allowed to give start_date also .


exec fnd_user_resp_groups_api.update_assignment(user_id => 7391,responsibility_id => 20707,responsibility_application_id => 201,start_date => '02-JAN-2008',end_date => sysdate,description => null);


Note : fnd_user_resp_groups_direct can be used to find the end_date . API fnd_user_pkg can also be to disable the users etc