Bulk import Users and Groups using CSV in Oracle IDCS

 There are instances when we need to create multiple users and assign to different groups.

Doing it manually one by one will be very time consuming.

Oracle provides a way to upload CSV files for users and groups to import in IDCS.

We can get sample files from below:

Login to IDCS->Click on Menu icon

 

Select users-> then click on import icon 

 

The sample file for federated users import will look like below:

User ID,Last Name,First Name,Middle Name,Honorific Prefix,Honorific Suffix,Display Name,Nick Name,Profile URL,Title,User Type,Locale,Preferred Language,TimeZone,Active,Password,Work Email,Home Email,Primary Email Type,Work Phone,Mobile No,Work Street Address,Work City,Work State,Work Postal Code,Work Country,Federated,Employee Number,Cost Center,Organization,Division,Department,Manager Name
sumit_kumar,kumar,sumit,,,,,,,,,,,,TRUE,,sumit.kumar@abc.com,,work,,,,,,,,TRUE,,,,,,

After preparing the file we can click Select users-> then click on import icon  and browse the file :

 

Click on import.

This will submit a job in IDCS to import users.

We can see the status by clicking on Jobs in the menu:

 

 

 

We can see the details by clicking on View Details of the job:

it will look like below:

 

If there is any error , it will provide the reason for failure against each user record.

Similarly we can import Groups or Assign users to Existing group.

Select Groups-> then click on import icon->Browse file and click on import

The sample File for Group import/ user assignment to existing Groups will be like:

Display Name,Description,User Members
OICSit2ServiceEndUser,Sit2 Group for OIC Service EndUser,sumit_kumar;rahul_sharma;
OICSit2ServiceInvoker,Sit2 Group for OIC Service Invoker,sumit_kumar;rahul_sharma;
OICSit2ServiceUser,Sit2 Group for OIC Service User,sumit_kumar;rahul_sharma;
OICSit2ServiceViewerSit2 Group for OIC Service Viewer,sumit_kumar;rahul_sharma;

Again to see the job status we can go to jobs and see the status and more details.

This way we can import users and groups in bulk and save lot of time.