20 September 2011

How to delete the Resposibility using PL/SQL script


BEGIN
   fnd_user_pkg.delresp ('SCOTT',  ---- User Name
                         'FND',    ---Application Short Name
                         'APPLICATION_DEVELOPER', ---Responsibility Key
                         'STANDARD');   --Security Group Key
END;Execute below Query you will get the Application Short Name and Responsibility Key
SELECT MUT.APPLICATION_SHORT_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;
Examble:-
BEGIN
   fnd_user_pkg.delresp ('MUTHU',
                         'INV',
                         'INVENTORY',
                         'STANDARD');
END;

No comments: