DECLARE lc_user_name VARCHAR2(100) := 'ISIPJ85'; lc_user_password VARCHAR2(100) := 'Oracle123'; ld_user_start_date DATE := TO_DATE(SYSDATE); ld_user_end_date VARCHAR2(100) := NULL; ld_password_date VARCHAR2(100) := TO_DATE(SYSDATE); ld_password_lifespan_days NUMBER := 90; ln_person_id NUMBER := NULL; lc_email_address VARCHAR2(100) := 'migs.isip.23@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; / SHOW ERR;
Take note that you would need enough database privilege to the APPS schema to run this script.
No comments:
Post a Comment