1. Administering Oracle Identity Cloud Service
  2. Support
  3. Troubleshoot Oracle Identity Cloud Service
  4. Import Users and Groups

Import Users and Groups

Learn about common problems that you might encounter when importing users and groups and learn how to solve them.

Topics

While importing users or groups, I am getting one of the following errors.

“Failure Reason: Unable to parse CSV file for upload….”

This error occurs when the CSV import file is invalid. Check the format of CSV file by opening the file in a standard spreadsheet application, such as Microsoft Excel or Google Sheets to make sure that each row contains same number of columns.

Tip:

This error also occurs if the CSV file that you are uploading is empty.

“Failure Reason: Mandatory CSV Header not found : <Header Name>.”

There are minimum set of headers that must be provided in the CSV file while importing users or groups.

  • For users, the CSV import file must contain “User ID”, “Last Name”, “First Name”, “Work Email” columns.

  • For groups, the CSV import file must contain "Display Name", "Description", and "User Members".

“Failure Reason: Invalid CSV headers found….”

This error means that the CSV file contains an extra CSV header, which is not permitted as a part of the CSV file.

  1. Open the file in a standard spreadsheet application, such as Microsoft Excel or Google Sheets, and then delete the column identified in the error message.

  2. Reimport the CSV file.

“Reading of CSV file unsuccessful : Import CSV records count exceeds records limit”

This error means that the CSV import file contains more records than the permissible limit. The maximum number of user accounts that can be imported in a single job must not exceed 100,000 user accounts. For optimal performance, Oracle recommends that you import your users in batches of 25,000. The maximum number of groups that can be imported in a single job must not exceed 100,000 groups. The maximum number of user members per group row in your CSV file must not exceed seven. For optimal performance, Oracle recommends that you import your groups in batches of 10,000.

“No data to process for import”.

This error means that the uploaded CSV import file contains no data in it. Check the file to make sure that it contains data.