Oracle EBS Standard Package Function Add User & Resp
Oracle EBS Standard Package Function Add User & Resp.fnd_user_pkg.CreateUser;
fnd_user_pkg.AddResp;
Demo:
fnd_user_pkg.CreateUser('WILSONCHUAN', 'ADMIN', 'PW$123456');
fnd_user_pkg.AddResp ('WILSONCHUAN', 'SYSADMIN', 'SYSTEM_ADMINISTRATOR', 'STANDARD', 'Test API', sysdate, null);
----------------------------------------------------------------------------
Tips:
procedure CreateUser (
x_user_name in varchar2,
x_owner in varchar2,
x_unencrypted_password in varchar2 default null,
x_session_number in number default 0,
x_start_date in date default sysdate,
x_end_date in date default null,
x_last_logon_date in date default null,
x_description in varchar2 default null,
x_password_date in date default null,
x_password_accesses_left in number default null,
x_password_lifespan_accesses in number default null,
x_password_lifespan_days in number default null,
x_employee_id in number default null,
x_email_address in varchar2 default null,
x_fax in varchar2 default null,
x_customer_id in number default null,
x_supplier_id in number default null);
procedure AddResp(username varchar2,
resp_app varchar2,
resp_key varchar2,
security_group varchar2,
description varchar2,
start_date date,
end_date date);
页:
[1]