E-FLO: Null Date/Time Value Cause EditError When Reading Flat File via File Layout
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***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms