erpSchools

Tag: users

  • API: FND_USER_PKG: Create User,reset Password and add Responsibilities

    1) API to create FND User BEGIN fnd_user_pkg.CreateUser ( x_user_name => ‘Operations’, x_owner => NULL, x_unencrypted_password =>’welcome1′, x_start_date => TO_DATE(’01-JAN-2000′), x_end_date => NULL, x_last_logon_date => NULL, x_description => ‘Operations User’, x_password_date => NULL, x_password_accesses_left => NULL, x_employee_id => NULL, x_email_address => NULL, x_fax => NULL, x_customer_id => NULL, x_supplier_id => NULL); COMMIT; END; 2) API…

  • Get List of responsibilities assigned to a user

    Get List of responsibilities assigned to a user select fu.user_name, frt.responsibility_name, furg.start_date, furg.end_date from fnd_user fu , fnd_user_resp_groups_direct furg , fnd_responsibility_vl frt where fu.user_id = furg.user_id and frt.responsibility_id = furg.responsibility_id and frt.application_id = furg.responsibility_application_id and nvl(furg.end_date,sysdate+1) > sysdate and nvl(frt.end_date,sysdate +1) > sysdate and fu.user_name = :p_user_name –and fu.user_name = :p_userid; ;