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

Last updated on FEBRUARY 19, 2016

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:


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

STEPS
-----------------------
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

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