My Oracle Support Banner

Equation Engine SQL is not Properly Saved in PS_EQTN_SQL_CHUNKS, With Result that Equation Running the SQL Fails With Error 'ORA-00936: missing expression' (Doc ID 857932.1)

Last updated on JANUARY 03, 2025

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When testing or running an equation, an error like the following occurs:

On-line message with testing:

Remote program FAPREQRN failed with return code: 936 .Reason: ORA-00936: missing expression. In section: SQLRT: EXECUTE-STMT. Check log file: /home/psadm2/psft/pt/8.54/appserv/APPDOM/LOGS/FAPREQRN_lcl_botheaj_0126104317.out in App Server for more info. Check log file: /home/FAPREQRN_xxx_012.out in App Server for more info (2,-1) SCC_EQUATION_ENGINE.Equation.OnExecute Name:Execute PCPC:5079 Statement:114

Message in the log file where the equation ran:

Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 00936
Error Message : ORA-00936: missing expression

An examination of the underlying data in the equation tables reveals that the SQL is not properly saved in its entirety in the table PS_EQTN_SQL_CHUNKS, compared to the table PS_EQTN_SQL_TBL which does show the full SQL saved.

The issue can be reproduced with the following steps:

  1. Navigate to Set Up SACR > Common Definitions > Equation Engine > Equation SQL Routines and enter the SQL.
  2. Navigate to Set Up SACR > Common Definitions > Equation Engine > Equation Editor and write the equation using the SQL from step 1.
  3. Navigate to Set Up SACR > Common Definitions > Equation Engine > Equation Test Data and populate any necessary variables.
  4. Click 'Test' button and note the error displayed on the page.
  5. Verify the data for the SQL in the tables PS_EQTN_SQL_CHUNKS, compared to the table PS_EQTN_SQL_TBL.

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


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