How To Add System Administrator Responsibility To A User from backend

Most of the time oracle apps developers are given only limited access to the front end application for development, in such cases you would like to add a responsibility from back end.

By using the below PL/SQL script/code you can add any responsibility to a user.

Syntax:

BEGIN

   fnd_user_pkg.addresp (username         => 'SXMARGAM',

                                        resp_app         => 'SYSADMIN',

                                        resp_key         => 'SYSTEM_ADMINISTRATOR',

                                        security_group   => 'STANDARD',

                                        description      => 'Auto Assignment',

                                        start_date       => SYSDATE - 10,

                                        end_date         => SYSDATE + 1000);

   COMMIT;

   DBMS_OUTPUT.put_line ('Responsibility Added Successfully');

EXCEPTION

   WHEN OTHERS

   THEN

      DBMS_OUTPUT.put_line (‘Responsibility is not added due to ' || SQLCODE || SUBSTR (SQLERRM, 1, 100));

      ROLLBACK;

END;