ACT 2016 Prospect Data Load (PDL) Setup - Invalid Date Value

(Doc ID 2145940.1)

Last updated on NOVEMBER 01, 2017

Applies to:

PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 and later
Information in this document applies to any platform.

Symptoms

On : 9 version, Prospect/Admissions Data Load

When attempting to Load ACT 2016 using PDL setup,
the following error occurs.

ERROR
-----------------------
Invalid date value, 5090, File Row Number 1, Field Name Test Date (14015,578)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using sample file - There are some weird characters at the start of the 2016 sample ACT file. You cannot see it in notepad or text pad or even Ultra-edit. You can only see it in ASCII. After I removed the characters it worked fine.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load given bad characters within file..

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