My Oracle Support Banner

"Incorrect syntax near the keyword 'AND' " Error When Running Student Group Process (SCC_STD_GRP) on Microsoft SQL Server (Doc ID 2465969.1)

Last updated on APRIL 04, 2019

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Symptoms

On : 9 version, Campus Community Other

In PeopleSoft Enterprise Campus Solutions Release 9.0, production environment, when a user attempts to run process student groups the following error occurs. Issue replicated in MICROSOFT SQL SERVER not in Oracle database.








STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Main Menu > Records and Enrollment > Career and Program Information > Process Student Group
2. Add New Run Control ID
3. Select External File as Selection Tool
4. Upload File & Select File Mapping
5. Enable Update Tuition Calc Required Checkbox
6. Run the SCC_STD_GRP process



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.