20 September 2011

How to add Responsibility using PL/SQL


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;

No comments: