How to Add a Responsibility from Backend

PL/SQL Script to be executed from APPS

BEGIN
fnd_user_resp_groups_api.load_row
(x_user_name           => <UserName>,
x_resp_key            => <Resp Key of Responsibility>,
x_app_short_name      => ‘SYSADMIN’,
x_security_group      => ‘STANDARD’,
x_owner               => ‘APPS’,
x_start_date          => SYSDATE,
x_end_date            => NULL,
x_description         => ‘Description’
);
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (   ‘Resp. not assigned to : ‘
|| ‘USER_NAME’
|| ‘ Error : ‘
|| SQLERRM
);
END;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s