This content has been marked as final. Show 12 replies
There is no copy user functionality available.
you have to create your own program and do that using FND package
Thank you. Do you sugest any FND package ?
Note: 364898.1 - How To Update User Data Using a Supported API
Thank hsawwan, I found this :
procedure CreateUser (
x_user_name in varchar2,
x_owner in varchar2,
x_unencrypted_password in varchar2 default null,
x_session_number in number default 0,
x_start_date in date default sysdate,
x_end_date in date default null,
x_last_logon_date in date default null,
x_description in varchar2 default null,
x_password_date in date default null,
x_password_accesses_left in number default null,
x_password_lifespan_accesses in number default null,
x_password_lifespan_days in number default null,
x_employee_id in number default null,
x_email_address in varchar2 default null,
x_fax in varchar2 default null,
x_customer_id in number default null,
x_supplier_id in number default null)
dummy := fnd_user_pkg.CreateUserId(
in that package, but how to use it and how to use it for create like ?
can i ask yo a qusiton please, why do you need to create a user linked to another one.
it is not linked but it is like.
Because the functional staffs have asked to create some new users just like some others ancients users with the same responsabilities. But in OAM we did not see CREAT LIKE option. However it is available in OEM for oracle users.
Maybe you what you need is AddResp(username varchar2,
end_date date) instead.
General steps :
2. Use this query in cursor loop
select d.product_code,b.responsibility_key from FND_USER_RESP_GROUPS_ALL a,fnd_responsibility b,fnd_user c,fnd_application d
where a.user_id = c.user_id
and a.responsibility_id = b.responsibility_id
and b.application_id = d.application_id
and c.user_name = <username you want to copy>
3.and use FND_USER_PKG.AddResp
4. end loop
Hopefully it's clear enough.
We can use data loader programs to insert data in oracle forms (user creation forms). It will bring down the time needed for identical data insert.
Data loader is useful when MASS load is required
Just wanted to log a quick thank you to hsawwan and dgood76. I received a "can you help us add these 18 responsibilities to all of these 17 users, please?" request this week, and your pointers to the FND_USER_PKG API were very useful. Probably took as much time to write and debug my scripts as it would've taken to assign the responsibilities manually, but since we're likely to get more such requests over the life of our current project, we will certainly see an overall productivity savings in the group. :-)
You might also want to look at user management functionality. With user management you can create roles, which could be a series of responsibilities. You can then assign a role to a group of users and they will all get the same responsibilities.