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 ?
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>
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.