Thursday, June 5, 2014

Adding System Adminisitrator Reponsibility from the Backend

--get the user_id to feed the api below
select *
from fnd_user
where user_name like 'AHMAD.RAMMAL'  ----

--get the responsibility_id to feed the api below
select *
from FND_RESPONSIBILITY
where RESPONSIBILITY_KEY = 'SYSTEM_ADMINISTRATOR'


-- replace the user_id and responsibility_id with the out values above
begin
fnd_user_resp_groups_api.insert_assignment
(user_id => 19477
,responsibility_id => 20420
,responsibility_application_id => 1
,security_group_id => 0
,start_date => SYSDATE
,end_date => NULL
,description => NULL
);
end;

Commit;

No comments:

Post a Comment