Budget formula process errors with Incorrect syntax near ')'

(Doc ID 623985.1)

Last updated on APRIL 21, 2016

Applies to:

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

This document was previously published as Customer Connection Solution 200775817



Checked for relevance on 18-08-2009


Symptoms

The Budget Formula process is erroring with Incorrect syntax near ')'

Log will contain something like:
FAPBDGTF - BEGIN PROGRAM EXECUTION AT 16.11.32.100000 ON 2004-06-04

INSTITUTION: XXXXX
AID YEAR:    20XX
CAREER:      XXXX
TERM:        XXXX

Application Program Failed
 Action Type     : SQL SELECT
 In Pgm Section  : SQLRT: EXECUTE-STMT
 With Return Code: 08606
 Error Message   : [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
Incorrect syntax near ')'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
prepared. (SQLSTATE 37000) 8180
 Dynamic Stmt    : DYNAMIC
 SQL Statement   : SELECT A.EMPLID FROM PS_STDNT_BDGT_ASGN A WHERE () AND A.AID _YEAR = '200X' AND A.INSTITUTION = 'XXXXX' AND A.STRM ='XXXX' AND A.PROCESSING_MODE = 'B'

ERROR - DYSQL (SELECT)
ERROR ENCOUNTERED AT : DYSQL (SELECT)
FAPBUDPF did not finish at 16:11:33.32 !!!!!
PTPSQLRT - Error Encountered
No longer have connection to DB due to an error from previous
action: SQL SELECT. Bypassing current action: CLEAR-STMT.
Terminating Program.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms