ERR rtncd=933 msg=ORA-00933: SQL command not properly ended when running budgets (Doc ID 618791.1)

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


Symptoms

 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.

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