'GRADING_BASIS_ENRL": invalid identifier' Error Importing Grades from SAIP into the Grade Roster. (Doc ID 2229933.1)

Last updated on FEBRUARY 02, 2017

Applies to:

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

Symptoms

On : 9 version, Student Records Enrollment

When on the Grade Roster component, clicking on the SAIP Import Grades button
returns the following error at SAE_GRADES.GradeRosterDB.OnExecute Name:isGradeValid peoplecode:


ERROR
-----------------------
SQLExec
 Error Position: 85
 Return: 904 - ORA-00904: "GRADING_BASIS_ENRL": invalid identifier
 Statement: select 1 from ps_grade_tbl_lamvw grd_vw where setid = :1 and
grading_scheme = :2 and GRADING_BASIS_ENRL = :3 AND CRSE_GRADE_INPUT = :4 AND
GRD_VW.EFFDT=(SELECT MAX(EFFDT) FROM PS_GRADE_TBL_VW GRADE_TBL_VW WHERE
GRADE_TBL_VW.SETID=GRD_VW.SETID AND
GRADE_TBL_VW.GRADING_SCHEME=GRD_VW.GRADING_SCHEME AND
GRADE_TBL_VW.GRADING_BASIS_ENRL=GRD_VW.GRADING_BASIS_ENRL AND
GRADE_TBL_VW.CRSE_GRADE_INPUT=GRD_VW.CRSE_GRADE_INPUT AND
GRADE_TBL_VW.EFFDT<=TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'))
 Original Statement: SELECT 1 FROM %Table(GRADE_TBL_LAMVW) GRD_VW WHERE
SETID = :1 AND GRADING_SCHEME = :2 AND GRADING_BASIS_ENRL = :3 AND
CRSE_GRADE_INPUT = :4 AND %EffdtCheck(GRADE_TBL_VW,GRD_VW, %currentDateIn




STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Navigate to Curriculum Management > Grading > Grade Roster.
  2. Click on the Grade Import button on the Grade Roster to import the grades from the Learning Management System.
  3. Error will occur.




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