BEGIN
fnd_user_pkg.addresp ('MUTHU', /*Application User Name */
'SYSADMIN', /*get from Query Below */
'SYSTEM_ADMINISTRATOR', /*get from Query Below */
'STANDARD', /* Most of cases it is ‘STANDARD’ so you can hard code it */
'SystemAdmin', /* Any comments you want */
SYSDATE, /* Sysdate From Today */
NULL); /* Sysdate + 365 Rights for Next One Year*/
END;
commit;Execute Below Query You will get the detail :-
SELECT MUT.APPLICATION_SHORT_NAME, MUT.APPLICATION_NAME,SHI.RESPONSIBILITY_KEY, SHI.RESPONSIBILITY_NAME
FROM FND_APPLICATION_VL MUT, FND_RESPONSIBILITY_VL SHI
WHERE SHI.APPLICATION_ID=MUT.APPLICATION_ID
ORDER BY SHI.RESPONSIBILITY_NAME;
fnd_user_pkg.addresp ('MUTHU', /*Application User Name */
'SYSADMIN', /*get from Query Below */
'SYSTEM_ADMINISTRATOR', /*get from Query Below */
'STANDARD', /* Most of cases it is ‘STANDARD’ so you can hard code it */
'SystemAdmin', /* Any comments you want */
SYSDATE, /* Sysdate From Today */
NULL); /* Sysdate + 365 Rights for Next One Year*/
END;
commit;Execute Below Query You will get the detail :-
SELECT MUT.APPLICATION_SHORT_NAME, MUT.APPLICATION_NAME,SHI.RESPONSIBILITY_KEY, SHI.RESPONSIBILITY_NAME
FROM FND_APPLICATION_VL MUT, FND_RESPONSIBILITY_VL SHI
WHERE SHI.APPLICATION_ID=MUT.APPLICATION_ID
ORDER BY SHI.RESPONSIBILITY_NAME;
No comments:
Post a Comment