Budget formula process errors with Incorrect syntax near ')'
Last updated on APRIL 30, 2018
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
The Budget Formula process is erroring with Incorrect syntax near ')'
Log will contain something like:
FAPBDGTF - BEGIN PROGRAM EXECUTION AT 188.8.131.52000 ON 2004-06-04
AID YEAR: 20XX
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.
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