My Oracle Support Banner

Loan Origination Fails on SQL Server With Error '[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect Syntax Near 'A'. Statement(s) could not be prepared. Stored Statement: FAPLBOG1_D_INVALIDPR' (Doc ID 2951262.1)

Last updated on JANUARY 25, 2024

Applies to:

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

Symptoms

Running the Loan Origination process (FAPLBOG1) using Pop Select on a Microsoft SQL Server database platform fails with the following error message.  This error does not occur on other database platforms when running Loan Origination.


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

  1.  Navigate to Financial Aid, Loans, Process Loans;
  2.  Select a Run Control;
  3.  Complete the Run Control,using Pop Select;
  4.  Submit the process to the process scheduler;
  5.  When the process fails, click the Details hyperlink in the Process Monitor for FAPLBOG1;
  6.  Click the View Log and note the reported error message.


Changes

 

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.