User Creation API in Oracle Apps

    Using the API fnd_user_pkg.createuser you can create user in Oracle Apps. You can find the below PL/SQL block to create user by passing the user details to the API as input parameter.

DECLARE lc_user_name VARCHAR2(100) := 'RG Hegde'; --User name lc_user_password VARCHAR2(100) := 'Oracle123'; --password ld_user_start_date DATE := SYSDATE; ld_user_end_date VARCHAR2(100) := NULL; --You can also pass the end date ld_password_date VARCHAR2(100) := SYSDATE+7; ld_password_lifespan_days NUMBER := 90; ln_person_id NUMBER ; lc_email_address VARCHAR2(100) := 'hegdesdp@gmail.com'; BEGIN fnd_user_pkg.createuser ( x_user_name => lc_user_name, x_owner => NULL, x_unencrypted_password => lc_user_password, x_start_date => ld_user_start_date, x_end_date => ld_user_end_date, x_password_date => ld_password_date, x_password_lifespan_days => ld_password_lifespan_days, x_employee_id => ln_person_id, x_email_address => lc_email_address ); COMMIT; EXCEPTION WHEN OTHERS THEN ROLLBACK; DBMS_OUTPUT.PUT_LINE(SQLERRM); END;

Once it is created you can check that from the database by using below query. SELECT * FROM fnd_user WHERE UPPER(user_name) ='RG HEGDE';

You can also verify this from the application

Log Into System Administrator Responsibility=>Security=>User=>Define
Press F11 and enter the user name =>Press CTRL+F11.