My Oracle Support Banner

Process NSLDS Files FAPTALRT Error Code 08616, 'Invalid Date Format' (Doc ID 2697827.1)

Last updated on AUGUST 07, 2020

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the Process NSLDS files, FAPTALRT, to load a Financial Aid History file, the following error occurs (note only the key parts of the error are shown):

Return Code: 08616
Error Message : [Microsoft][ODBC Driver 17 for SQL Server]Invalid date format (SQLSTATE 22007) 0
Stored Stmt : FAPTALRT_I_ISIRDTL
FAPTALRT - SQL ERROR IN SECTION: 20330-INSERT-ISIR-DTL (I-ISIRDTL)

The log may show some students processed successfully before the error occurs. The process may have also been running successfully prior to upgrading Tools.

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

  1. Run Financial Aid>File Management>Import Federal Data Files.
  2. Run Financial Aid>File Management>NSLDS>Process NSLDS Files for All School/Branch Codes






Cause

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
Symptoms
Cause
Solution


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