Example:

  for i in c_users_ loop
    begin
      fnd_user_ := UPPER(Convert_(substr(i.first_name, 1,2))||Convert_(i.last_name));
      Client_SYS.Clear_Attr(attr_);
      Client_SYS.Add_To_Attr('IDENTITY', fnd_user_, attr_);
      Client_SYS.Add_To_Attr('DESCRIPTION', i.name, attr_);
      Client_SYS.Add_To_Attr('ORACLE_USER', fnd_user_, attr_);
      Client_SYS.Add_To_Attr('WEB_USER', fnd_user_, attr_);
      Client_SYS.Add_To_Attr('ACTIVE', 'TRUE', attr_);
      Client_SYS.Add_To_Attr('ORACLE_PASSWORD', i.pass, attr_);
      Client_SYS.Add_To_Attr('EXPIRE_PASSWORD', 'FALSE', attr_);
      fnd_user_api.New__(info_, objid_, objversion_, attr_, 'DO');
      fnd_user_api.Set_Property(fnd_user_, 'PREFERRED_LANGUAGE','pl');
      fnd_user_api.Set_Property(fnd_user_, 'ALLOW_DB_AUTHENTICATION','TRUE');

end loop;

​@knepiosko thank you this gives me the api to create a user account but I would also like to assign a base permissionset so they could login, is there an api for assigning the default company and site?

Please let me know

​@knepiosko  or anyone, I am trying to find the API procedure to add additional Granted Permission Sets to the FND_USER_ROLE_RUNTIME_TAB? I have the procedure to add a ROLE but it only adds the top level role, how do you add the additional roles?

Thank you,

Hi ​@arebbeadle 

You need to grant role using this:

Security_sys.Grant_Role(role_, fnd_user_); → fnd_user_ =>’FND_ENDUSER’

After finishing process refresh security cache. Table FND_USER_ROLE_RUNTIME_TAB is populated during logon time as a summary of all permissions granted to enduser.

Here is a sample script that I used to setup a basic users. Let me know if it is helpful?