My Oracle Support Banner

Error in Student's Enrollment When Enrollment Security is Setup for an Academic Program in MSS database (Doc ID 2415430.1)

Last updated on AUGUST 20, 2018

Applies to:

PeopleSoft Enterprise CS Student Administration - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Campus Solutions - All

Error on submitting Enrollment Request

When user with limited enrollment security on Actions Enroll & Drop, is submitting the enrollment request, the following error appears It is working fine with FULL enrollment security.

ERROR
-----------------------
Remote Program SRPCERC failed with return code 8605. Reason: Microsoft SQL Server aggregate may not appear in the WHERE clause unless it is in sub-query contained in a HAVING clause or a select list , an the column being aggregated is an outer reference.


SQLRT : EXECUTE-STMTEOVD SQ 8050-CHECK_ACAD-PEOG (SELECT-APRG) (2,-1)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup the Enrollment Security for a user, Enrollment Access Group and Enrollment Access ID
2. Enter Enroll - 999, Drop - 999 in Enrollment Functions for an Enrollment Access ID
3. Login with the User and Submit Enrollment Request for Action - Enroll
4. An error will pop up

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot enroll students successfully

Changes

 

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
Changes
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.