My Oracle Support Banner

Invalid Value Error On Administrative Grade Roster After Applying CS Bundle 34 (Doc ID 2108730.1)

Last updated on JANUARY 23, 2020

Applies to:

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

Symptoms

PeopleSoft Enterprise Campus Solutions, Student Records, Grading

When attempting to enter grades on the grade roster, user is able to retrieve list of values to enter but then received an error:


Invalid value - press prompt button or hyperlink for a list of valid values (15, 11)

Steps to reproduce the issue:
1. Navigate to Curriculum Management>Grading>Grade Roster and retrieve a roster.
2. Click the prompt on the grade field and select a value.
3. Immediately the message "Invalid value -- press the prompt button or hyperlink for a list of valid values (15,11) appears.


Changes

 Prior to the update delivered in Bundle #34, GRADE_Roster.GBL.GRADE_ROSTER.Crse_Grade_Input.FieldEdit code was:
------------------------------------------------------------------------------------------------------------------------------
Else;

SQLExec("SELECT A.CRSE_GRADE_INPUT FROM PS_GRADE_TBL_VW A WHERE A.SETID = :1 AND A.GRADING_SCHEME = :2 AND A.EFFDT = (SELECT MAX(A1.EFFDT) FROM PS_GRADE_TBL_VW A1 WHERE A1.SETID = A.SETID AND A1.GRADING_SCHEME = A.GRADING_SCHEME AND A1.GRADING_BASIS_ENRL = A.GRADING_BASIS_ENRL AND A1.EFFDT <= %DATEIN(:3)) AND A.GRADING_BASIS_ENRL = :4 AND A.CRSE_GRADE_INPUT = :5", GRADE_TBL_LAMVW.SETID, GRADE_ROSTER.GRADING_SCHEME, TERM_TBL.TERM_BEGIN_DT, GRADE_ROSTER.GRADING_BASIS_ENRL, GRADE_ROSTER.CRSE_GRADE_INPUT, &CRSE_GRADE_INPUT);
End-If;

After applying Bundle #34, GRADE_Roster.GBL.GRADE_ROSTER.Crse_Grade_Input.FieldEdit code SQLExec is:
------------------------------------------------------------------------------------------------------------------------------
SQLExec("SELECT A.CRSE_GRADE_INPUT FROM PS_GRADE_TBL_VW A WHERE A.SETID = :1 AND A.GRADING_SCHEME = :2 AND A.EFFDT = (SELECT MAX(A1.EFFDT) FROM PS_GRADE_TBL_VW A1 WHERE A1.SETID = A.SETID AND A1.GRADING_SCHEME = A.GRADING_SCHEME AND A1.GRADING_BASIS_ENRL = A.GRADING_BASIS_ENRL AND A1.EFFDT <= %DATEIN(:3)) AND A.GRADING_BASIS_ENRL = :4 AND A.CRSE_GRADE_INPUT = :5", GetSetId(Field.INSTITUTION, INSTITUTION_TBL.INSTITUTION.Value, "STDNT_ENRL_VW", ""), GRADE_ROSTER.GRADING_SCHEME, TERM_TBL.TERM_BEGIN_DT, STDNT_ENRL.GRADING_BASIS_ENRL, GRADE_ROSTER.CRSE_GRADE_INPUT, &CRSE_GRADE_INPUT);

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.