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….”
Tip:
This error also occurs if the CSV file that you are uploading is empty.“Failure Reason: Mandatory CSV Header not found : <Header Name>.”
-
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….”
-
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.
-
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.