UPK: Error "mscorlib - String was not recognized as a valid DateTime" when Importing Users in KCenter with User Import Utility Tool (Doc ID 2177960.1)

Last updated on AUGUST 31, 2016

Applies to:

User Productivity Kit - Version 12.1.2 to 12.1.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms


The below error is received when trying to import users with User Import Utility from xlsx file:
"mscorlib - String was not recognized as a valid DateTime."

The issue can be reproduced at will with the following steps:
1. Open User Import Utility.
2. Start importing users from an xlsx having the following columns:
USERNAME PASSWORD FIRSTNAME LASTNAME MINIT EMAIL NTINTEGRATED USERGROUP STARTDATE ENDDATE
3. Receive the above error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms