Monday, August 31, 2009

creation of fnd_user via api

The following API provided adds the user and its password in fnd_table.The following code is working version of procedure to create new user.
leave the quotation '' as it is unless u have to sepcify some values of your own.


p_session_id INTEGER := userenv('sessionid');

FND_USER_PKG.CREATEUSER( x_user_name => rec.customer_user_id
,x_owner => ''
,x_unencrypted_password => rec.customer_password
,x_session_number => p_session_id
,x_start_date => rec.customer_creation_date
,x_end_date => NULL
,x_last_logon_date => SYSDATE - 10
,x_description => NULL
,x_password_date => SYSDATE - 10
,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 => ''
,x_customer_id => ''
,x_supplier_id => ''
);

after addition find the user name in fnd_user.

No comments:

Post a Comment