PLSQL Snippet to create FND User and assign FND Responsibilities
DECLARE
v_user_name VARCHAR2(30):=UPPER('&Enter_User_Name');
v_password VARCHAR2(30):='&Enter_Password';
v_session_id INTEGER := USERENV('sessionid');
BEGIN
fnd_user_pkg.createuser (
x_user_name => v_user_name,
x_owner => NULL,
x_unencrypted_password => v_password,
x_session_number => v_session_id,
x_start_date => SYSDATE,
x_end_date => NULL
);
COMMIT;
DBMS_OUTPUT.put_line ('User:'||v_user_name||'Created Successfully');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line ('Unable to create User due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));
ROLLBACK;
END;
BEGIN
fnd_user_pkg.addresp ('DEVENDRA.R',
'SYSADMIN',
'SYSTEM_ADMINISTRATOR',
'STANDARD',
'Add Responsibility to USER using pl/sql',
SYSDATE,
SYSDATE + 100);
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;
v_user_name VARCHAR2(30):=UPPER('&Enter_User_Name');
v_password VARCHAR2(30):='&Enter_Password';
v_session_id INTEGER := USERENV('sessionid');
BEGIN
fnd_user_pkg.createuser (
x_user_name => v_user_name,
x_owner => NULL,
x_unencrypted_password => v_password,
x_session_number => v_session_id,
x_start_date => SYSDATE,
x_end_date => NULL
);
COMMIT;
DBMS_OUTPUT.put_line ('User:'||v_user_name||'Created Successfully');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line ('Unable to create User due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));
ROLLBACK;
END;
BEGIN
fnd_user_pkg.addresp ('DEVENDRA.R',
'SYSADMIN',
'SYSTEM_ADMINISTRATOR',
'STANDARD',
'Add Responsibility to USER using pl/sql',
SYSDATE,
SYSDATE + 100);
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;
Comments
Post a Comment