EBS 创建用户

DECLARE
  v_user_name   VARCHAR2(100) := upper('&Enter_User_Name');
  v_description VARCHAR2(100) := 'NEW Test User';
BEGIN
  fnd_user_pkg.createuser(x_user_name                  => v_user_name,
                          x_owner                      => NULL,
                          x_unencrypted_password       => '&input_password',
                          x_session_number             => 0,
                          x_start_date                 => SYSDATE,
                          x_end_date                   => NULL,
                          x_last_logon_date            => NULL,
                          x_description                => v_description,
                          x_password_date              => NULL,
                          x_password_accesses_left     => NULL,
                          x_password_lifespan_accesses => NULL,
                          x_password_lifespan_days     => NULL,
                          x_employee_id                => NULL,
                          x_email_address              => NULL,
                          x_fax                        => NULL,
                          x_customer_id                => NULL,
                          x_supplier_id                => NULL,
                          x_user_guid                  => NULL,
                          x_change_source              => NULL);
  COMMIT;
END;

  

posted @ 2025-03-10 15:23  Iven_lin  阅读(19)  评论(0)    收藏  举报