Scribd
Upload
10 views

responsibility coding

Uploaded by

sail8
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
10 views

responsibility coding

Uploaded by

sail8
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 3

/

select
frt.responsibility_name "Responsibility Name",
furg.start_date "Start Date",
furg.end_date "End Date",
fr.responsibility_key "Responsibility Key",
fa.application_short_name "Application Short Name"
FROM fnd_user_resp_groups_direct furg,
apps.fnd_user fu,
apps.fnd_responsibility_tl frt,
apps.fnd_responsibility fr,
apps.fnd_application_tl fat,
apps.fnd_application fa
WHERE furg.user_id = fu.user_id
AND furg.responsibility_id = frt.responsibility_id
and fr.responsibility_id = frt.responsibility_id
AND fa.application_id = fat.application_id
AND fr.application_id = fat.application_id
AND frt.language = USERENV ('LANG')
and UPPER (fu.user_name) = UPPER ('sai_test'); -- modify user name
/

select resp.responsibility_key
,resp.responsibility_name
,app.application_short_name
from fnd_responsibility_vl resp
,fnd_application app
where resp.application_id = app.application_id
and resp.responsibility_name in ( 'System Administrator'
,'Application Developer'
,'Functional Administrator') ;
/
select * from fnd_responsibility_vl resp where
resp.responsibility_name='Application Developer' ;--20419 --application id is 0 --
req_group_id=4
/
select *from apps.fnd_user where user_name =upper('Sailish');
select * from fnd_user_resp_groups_direct where user_id=15895;

/
select * from fnd_user where upper(user_name)=upper('sailish');
/
select * from fnd_responsibility;
/
select * from fnd_responsibility
/
select * from fnd_user_resp_groups_direct;
/
begin
dbms_output.put_line('sailidh');
end;
/
SELECT APPLICATION_SHORT_NAME
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = 'FND';
/
select * from FND_APPLICATION;
/
begin
fnd_user_pkg.addresp (
username => v_user_name
,resp_app => 'FND'
,resp_key => 'APPLICATION_DEVELOPER'
,security_group => 'STANDARD'
,description => null
,start_date => sysdate
,end_date => null);
end;
/
fnd_user_pkg.addresp (
username => v_user_name
,resp_app => 'FND'
,resp_key => 'APPLICATION_DEVELOPER'
,security_group => 'STANDARD'
,description => null
,start_date => sysdate
,end_date => null);
/
set serveroutput on ;
begin
fnd_user_pkg.createuser (
x_user_name => 'SAI'
,x_owner => null
,x_unencrypted_password => 'Ramsailish88'
,x_session_number => userenv('sessionid')
,x_start_date => sysdate
,x_end_date => null );
dbms_output.put_line ('User created !!!!!');
dbms_output.put_line ('1');
commit;
exception
when others then
dbms_output.put_line ('2');
dbms_output.put_line ('Exception : '||SUBSTR(SQLERRM, 1, 500));
dbms_output.put_line ('rollback occuring');
--rollback;
end;

/
select * from fnd_responsibility;
/
SELECT fu.USER_NAME,
fr.RESPONSIBILITY_NAME,
fur.START_DATE,
fur.END_DATE
FROM FND_USER fu
JOIN FND_USER_RESPONSIBILITY fur ON fu.USER_ID = fur.USER_ID
JOIN FND_RESPONSIBILITY fr ON fur.RESPONSIBILITY_ID = fr.RESPONSIBILITY_ID
WHERE fu.USER_NAME ='SAILISH';
/
select * from apps.FND_USER_RESPONSIBILITY;
/
select * from FND_USER_RESPONSIBILITY_ASSIGNMENTS;

/
SELECT fu.user_name "User Name",
frt.responsibility_name "Responsibility Name",
furg.start_date "Start Date",
furg.end_date "End Date",
fr.responsibility_key "Responsibility Key",
fa.application_short_name "Application Short Name"
FROM fnd_user_resp_groups_direct furg,
apps.fnd_user fu,
apps.fnd_responsibility_tl frt,
apps.fnd_responsibility fr,
apps.fnd_application_tl fat,
apps.fnd_application fa
WHERE furg.user_id = fu.user_id
AND furg.responsibility_id = frt.responsibility_id
and fr.responsibility_id = frt.responsibility_id
AND fa.application_id = fat.application_id
AND fr.application_id = fat.application_id
AND frt.language = USERENV ('LANG')
and UPPER (fu.user_name) = UPPER ('sailish.fedisha'); -- modify user name
/
select resp.responsibility_key
,resp.responsibility_name
,app.application_short_name
from fnd_responsibility_vl resp
,fnd_application app
where resp.application_id = app.application_id
and resp.responsibility_name in ( 'System Administrator'
,'Application Developer'
,'Functional Administrator')
/
select * from fnd_user_resp_groups_direct;

You might also like