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;

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete