SQL Error In Enrollment Request
(Doc ID 2422997.1)
Last updated on FEBRUARY 08, 2019
Applies to:
PeopleSoft Enterprise CS Student Records - Version 9 and laterInformation in this document applies to any platform.
Symptoms
On : Canpus solutions 9 version, Student Records Enrollment
When attempting to run an enrollment request using an override date
the following error occurs.
ERROR
-----------------------
2,-1
Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 08605
Error Message : [Microsoft][SQL Server Native Client 11.0][SQL Server]An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
[Microsoft][SQL Server
Stored Stmt : SRPCEOVD_S_APRG
SQL Statement : SELECT A.PROG_ACTION FROM PS_ACAD_PROG A WHERE A.EMPLID=:1 A
ND A.ACAD_CAREER=:2 AND A.EFFDT=(SELECT MAX(A1.EFFDT) FROM
PS_ACAD_PROG A1 WHERE A1.EMPLID=A.EMPLID AND A1.ACAD_CAREE
R=A.ACAD_CAREER AND A1.STDNT_CAR_NBR = A.STDNT_CAR_NBR AND
A1.EFFDT<=:3) AND A.EFFSEQ = (SELECT MAX(A.EFFSEQ) FROM PS
_ACAD_PROG A2 WHERE A2.EMPLID = A.EMPLID AND A2.ACAD_CAREER
= A.ACAD_CAREER AND A2.STDNT_CAR_NBR = A.STDNT_CAR_NBR AND A
2.EFFDT = A.EFFDT) AND A.INSTITUTION=:4 AND A.ACAD_PROG=:5
AND A.PROG_STATUS='AC'
---------------SQL ERROR----------------------
PGM SECTION:EOVD:SQ:8050-CHECK-ACA
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Records and Enrollment > Enroll students > enrollment request.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot enroll student in this circumstance.
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 |