SQL is Wrong in PS_DEGR_PRG_PRC_VW, Causing a Loss of Data When a Student has More Than one Academic Career Number
(Doc ID 3045486.1)
Last updated on SEPTEMBER 04, 2024
Applies to:
PeopleSoft Enterprise CS Academic Advisement - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
The SQL in PS_DEGR_PRG_PRC_VW is wrong resulting in incorrect or incomplete data being returned when the SQL is executed.
When the SQL is executed in the delivered code, a student with more than one ACAD_CAREER does not return all rows from all careers. It is expected that all rows would be returned for any student with more then one ACAD_CAREER
The issue can be reproduced at will with the following steps:
1. Create a scenario where a student has more than one acad career number
2. Run the delivered SQL in SQL Developer and note only one row is returned.
3. Change the SQL so that the row AND A.EFFDT <= %CurrentDateIn to A1.EFFDT <= %CurrentDateIn and run the SQL.
4. Note that two rows are returned for each career number.
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 |