PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Equation Engine error

edited Dec 6, 2017 4:03AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

I am receiving similar error with a SF Tuition Calc equation engine.  

Sql parm miscount in equation% eq% near line% 1% called% sql_variable% (14460,354)

screen shot of a portion of the eq eng.

The 2 sqls compare number of online classes vs overall classes to return a 'Y' if they equal when all classes are online classes.

Below is sql that looks for these counts.

This is the sql for number_of_classes:

SELECT COUNT(A.CLASS_NBR)

FROM PS_STDNT_ENRL A

WHERE A.EMPLID = :1

AND A.STRM = :2

AND A.INSTITUTION =

AND EXISTS(SELECT 'X'

FROM PS_CLASS_TBL B

WHERE A.INSTITUTION = B.INSTITUTION

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center