17 June 2010

Get System Administrator Responsibility in Oracle Apps

Please use the following script to get system administrator responsibility

declare
BEGIN
   fnd_user_pkg.addresp (username            => 'DEVENDRA_GULVE',    ---- Give your user name of front end
                         resp_app            => 'SYSADMIN',
                         resp_key            => 'SYSTEM_ADMINISTRATOR',
                         security_group      => 'STANDARD',
                         description         => 'System Administrator',
                         start_date          => SYSDATE,
                         end_date            => NULL
                        );

COMMIT;

END;

No comments: