Friday 12 December 2014

Buyer Setup Query

begin
fnd_user_pkg.updateuser(x_user_name => 'Elango',
x_owner => '',
--x_unencrypted_password => 'welcome123',
x_session_number => 14,
x_start_date => (SYSDATE - 1),
x_end_date => null,
x_last_logon_date => (SYSDATE - 1),
--x_description => 'Elangovan Ragavan',
--x_password_date => (SYSDATE - 1),
x_password_accesses_left => null,
x_password_lifespan_accesses => null,
x_password_lifespan_days => null,
x_employee_id => 3672

--/Change this id by running below SQL/
/*
SELECT person_id
,full_name
FROM per_all_people_f
WHERE upper(full_name) LIKE ‘%’ ” upper(’full_name’) ” ‘%’
GROUP BY person_id
,full_name
*/,
x_email_address => null,
x_fax => null,
x_customer_id => null,
x_supplier_id => null);
end;

No comments:

Post a Comment