E-FLO: Null Date/Time Value Cause EditError When Reading Flat File via File Layout (Doc ID 1081945.1)

Last updated on MARCH 31, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 and later
Information in this document applies to any platform.
***Checked for relevance on 30-May-2014***

Symptoms


You are trying to read the date value from a csv file via file layout using ReadRowset() method. In order to verify the date value being read in correctly some extra code logic was added after the ReadRowset() call to check the isEditError property and see if an error occurred. According to solution below and PeopleBooks

949029.1 - E-FLO: How to check invalid formatted data when loading flat file via file layout?

This is working fine when the date in csv file was invalid format, e.g. 30/30/1900, but it did not work when a null/blank date value was provided. For example, if the csv file contained an empty/blank/null value for the date field, the isEditError property would still be set to true by the ReadRowset() function. As a result you would not be able to tell if the data file contained an invalid format date or a null date value.

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