API to CREATE Oracle FND User
FND_USER_PKG --> Table Handler to insert or update data in FND_USER table.
DECLARE
v_user_name VARCHAR2(100) := 'TESTUSER';
v_user_password VARCHAR2(100) := 'Welcome123';
v_user_start_date DATE := sysdate;
v_user_end_date VARCHAR2(100) := NULL;
v_password_date VARCHAR2(100) := sysdate;
v_password_lifespan_days NUMBER := 90;
v_person_id NUMBER := 25;
v_email_address VARCHAR2(100) := 'nobody@localhost';
BEGIN
fnd_user_pkg.createuser ( x_user_name => v_user_name,
x_owner => NULL,
x_unencrypted_password => v_user_password,
x_start_date => v_user_start_date,
x_end_date => v_user_end_date,
x_password_date => v_password_date,
x_password_lifespan_days => v_password_lifespan_days,
x_employee_id => v_person_id,
x_email_address => v_email_address);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
/
SELECT * FROM PER_ALL_PEOPLE_F WHERE PERSON_ID=25;-- LIKE '%Stock%';
select * from fnd_user where user_name like 'TESTUSER';
