My Oracle Support Banner

ISIR File Load FAPSAR00 Error Code 08631, 'Incorrect Syntax', in MSSQL Environment When Run for 2024-2025 After Applying Patch 35043037 (Doc ID 2999496.1)

Last updated on APRIL 17, 2024

Applies to:

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

Symptoms

When running the ISIR File Load, FAPSAR00 Cobol, the following error - abbreviated from the full message shown in the COBOL log - occurs in a Microsoft SQL Server (MSSQL) environment. The error has ONLY been reported to occur with MSSQL and not other database types or platforms.

Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 08631
Error Message : [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax
near '('.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword
'WHERE'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not
Stored Stmt : FAP00SLD_U_FTIM

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

  1. Navigate to Financial Aid > File Management > ISIR Import > Process ISIRs > ISIR File Load.
  2. Enter Aid Year 2025 along with other required parameters, and run the process.
  3. In Process Monitor, note when the process instance ends in 'Error'
  4. Click 'Details' then 'View Log/Trace' then the FAPSAR00 .log file in the file list to verify the full error message details.




Changes

The issue occurs after applying the fixes delivered in Patch 35043037 - 2024-2025 ISIR UPDATE: FAFSA SIMPLIFICATION

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
Changes
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.