Campus Solutions - PSFT (MOSC)

MOSC Banner

Callable SQL used in Equation

edited Oct 8, 2026 6:58PM in Campus Solutions - PSFT (MOSC) 2 commentsAnswered

I created a callable SQL however it errors due to missing expression.

Here's what the SQL looks like:

SELECT DL_TOTAL_LOAN_BATCH
FROM (SELECT NVL(SUM( A.OFFER_AMOUNT), 0) DL_TOTAL_LOAN_BATCH
FROM PS_PKG_BATCH_AWD A, PS_ITEM_TYPE_FA C
WHERE A.BATCH_SEQ_NBR = (SELECT MAX( B.BATCH_SEQ_NBR)
FROM PS_PKG_BATCH_AWD B
WHERE B.INSTITUTION = A.INSTITUTION
AND B.AID_YEAR = A.AID_YEAR
AND B.ACAD_CAREER = A.ACAD_CAREER
AND B.EMPLID = A.EMPLID)
AND C.EFFDT =
(SELECT MAX(C_ED.EFFDT) FROM PS_ITEM_TYPE_FA C_ED

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

PSFT Campus Solutions Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center