PS_EQTN_SQL_CHUNKS Does not Always Store the Correct/Complete SQL

(Doc ID 857932.1)

Last updated on MARCH 06, 2017

Applies to:

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

Symptoms

In Equation Engine, the SQL being stored in PS_EQTN_SQL_CHUNKS record is not always the complete SQL that is being saved through equation SQL routines. A comparison to the PS_EQTN_SQL_TBL will show the differences. Also, sometimes the equation will fail with a message like the following:

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

 

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