My Oracle Support Banner

Row Insert In ISIR Correction Page Fails On MSSQL - Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'SYSDATE'. (Doc ID 3007330.1)

Last updated on MARCH 19, 2024

Applies to:

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

Symptoms

On : 9.2 version, PUM 31 and PRP #1 Financial Aid Application Processing

When attempting to use the ISIR correction page the following error occurs:


Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'SYSDATE'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180

%CurrentDateIn should be used instead.

Steps to replicate:

1.Navigation - Home > Financial Aid > Federal Application Data > Correct ISIR Records
2. Search for any Student then click on the Add(+) button.

 

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
References


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