PERC Drop Letter Queries Contain Incorrect Criteria for Enrollment Action Reason (Doc ID 1338859.1)

Last updated on AUGUST 08, 2017

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms


ISSUE STATEMENT
---------------
In PeopleSoft Enterprise Campus Solutions release 9, the delivered queries for population selection for Drop Letters for Post Enrollment Requirement Checking (PERC) have incorrect criteria for the Enrollment Action Reason field.

WHAT IS WORKING
---------------
The other delivered queries for population selection for PERC are working, the issue is only with queries for Drop Letters.

ACTUAL BEHAVIOR
---------------
The queries for Drop Letters fetch zero rows because of the incorrect criteria for the Enrollment Action Reason field.

EXPECTED BEHAVIOR
---------------
Expect the queries to fetch the correct rows.

ENVIRONMENT
---------------
DB Platform - N/A
Tools Version - N/A
Application & Version - Campus Solutions release 9
System Name - Test

STEPS
---------------
The issue can be reproduced with the following steps:
1. Navigate to Reporting Tools - Query Manager
2. Open the Queries for the Drop Letters (SSR_PERC_DROP_LETTERS, SSR_PERC_DROP_PG_LETTERS or SSR_PERC_DROP_WL_LETTERS)
3. Go to the Criteria tab and notice that the criteria for Enrollment Action Reason field is a constant of REQS.

IMPACT
---------------
Incorrect criteria on the queries make them unusable, but the issue has a minimal impact to business as the criteria can be changed to the correct value of PERC.

Cause

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 hundreds of Community platforms