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:

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

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