ERR rtncd=933 msg=ORA-00933: SQL command not properly ended when running budgets
Last updated on APRIL 14, 2016
Applies to:PeopleSoft Enterprise CS Financial Aid - Version 7.6 to 9.2 [Release 7.6 to 9]
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 200743635
Checked for relevance on 03/09/2009
Checked for relevance on 20-APR-2011
The Create Student Budget > Build process ends in error. FAPBUDRC_*.out shows the following message:
Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 00933
Error Message : ORA-00933: SQL command not properly ended
Dynamic Stmt : DYNAMIC
SQL Statement : SELECT A.EMPLID FROM PS_STDNT_BDGT_ASGN A WHERE ( A.STRM <>
'0320' )) AND A.EMPLID = '0000094' AND A.AID_YEAR = '2003'
AND A.INSTITUTION = 'SPJC1' AND A.STRM = '0310' AND A.PROCES
SING_MODE = 'O'
ERROR - DYSQL (SELECT)
ERROR ENCOUNTERED AT : DYSQL (SELECT)
FAPBUDPF did not finish at 14:24:20.86 !!!!!
PTPSQLRT - Error Encountered
COBOL SQL trace of the process shows the following:
COM Stmt=SELECT A.EMPLID FROM PS_STDNT_BDGT_ASGN A WHERE ( A.STRM <> '0320' )) AND A.EMPLID = '0000094' AND A.AID_YEAR = '2003' AND A.INSTITUTION = 'SPJC1' AND A.STRM = '0310' AND A.PROCESSING_MODE = 'O'
11:37:46 1059 0.000 0.000 #14 RC=0 SSB column=1, type=SQLPBUF, length=11
11:37:46 1060 0.250 0.000 #14 RC=933 EXE
11:37:47 1061 0.661 0.000 #0 RC=933 ERR rtncd=933 msg=ORA-00933: SQL command not properly ended
11:37:48 1062 0.931 0.000 #14 RC=0 EPO error pos=0
11:37:48 1063 0.040 0.000 #14 RC=0 Rollback
11:37:48 1064 0.010 0.010 #14 RC=0 Disconnect
Notice that there is an open paren. missing at the beginning of the where clause.
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