Process NSLDS Files FAPTALRT Error Code 08616 or 08617, 'Invalid Date Format' in Stored Stmt FAPTALRT_I_ISIRDTL (Doc ID 2697827.1)

Last updated on NOVEMBER 02, 2022

Applies to:

Symptoms

When attempting to run the Process NSLDS files, FAPTALRT, to load a Financial Aid History file, the process errors with the following messaging displayed in the FAPTALRT COBOL log file. The log may also show error code 08617 instead, and additional messaging beyond the key parts captured in the blue code block.

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
3. In Process Monitor, note when process ends in 'Error' Status.
4. Click 'Details' link for the process instance, then the link that says 'View Log/Trace', then the .log file in the file list to see the detailed error message.

Cause

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