My Oracle Support Banner

FlatFileconnector Date Attribute Fails with "convertDataType : Exception while parsing..." (Doc ID 2167496.1)

Last updated on JULY 21, 2020

Applies to:

Identity Manager Connector - Version and later
Information in this document applies to any platform.


After installing Flat File connector FlatFile- and using FlatFile as Trusted Reconciliation, Date field fails to Reconcile.
- Works for all other attributes.

Tried date format (1999/11/02 10:00:00 IST), which gave following error:
convertDataType : Exception while parsing 1999/11/02 10:00:00 IST to yyyy-MM-dd

Changed date format to yyyy-MM-dd and tried date(1999-11-02)
then it is giving following error:
convertDataType : Exception while parsing 1999-11-02 to yyyy/MM/dd HH:mm:ss z

The issue can be reproduced at will with the following steps:

1. Created Resource Object Attribute of type Date
2. Mapped in Process definition to Hire Date with Recon Attribute
3. Mapped in Lookup.<>.ReconAttrMap with recon attribute and csv HireDate header
4. In made entry


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.