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.


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.

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.


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

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




To view full details, 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 a vibrant support community of peers and Oracle experts.