Veterans Benefits Process - Veterans Tuition Worksheet - Multiple Issues (Doc ID 1993169.1)

Last updated on MAY 19, 2016

Applies to:

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

Symptoms

On : 9 version, Bundle #35, Student Records Enrollment

You are testing the VA benefit functionality delivered by PeopleSoft and you have seen the following issues:
1. Even though the 'Enrollment Certification' for the student is in 'Reported Status', we see the error - 'Latest Enrollment Certification record is not in Reported status' on the 'Veterans Tuition Worksheet' for the same student.
  a. Create Benefits Summary Page for a student.
  b. Run Create/Update process to create the Enrollment Certificate Record for the Student.
  c. Open the Enrollment Certification Page and Certify couple of course and Change the status to 'Reported' and hit Save.
  d. Run Create/Update process to create the Tuition Worksheet for the student.
  e. Open the Tuition Worksheet , you will see the error 'Latest Enrollment Certification record is not in Reported status' on the 'Veterans Tuition Worksheet'
2. Tuition worksheets does not allow you to save in 'In-Review' mode for later use
  a. Create a tuition worksheet for a student by running the Create/update term process.
  b. Open the Tuition worksheet for the student, Add some calculations. Click Save and make sure the status be in 'In Review' Status.
  c. Come out of the page. (go to some place else or close the window)
  d. Go back to the same student on the Tuition Worksheet , make some modifications and hit save, you will see 'Data being added conflicts with existing data. (18,2) . '
3. Editing the second tuition worksheet is giving error.
  a. Create a tuition worksheet for a student by running the Create/update term process.
  b. Open the Tui wrkshet for the student, Add some calculations. Click Save and make sure the status be in 'Reported' Status.
  c. Run Create/Update process to create the Tuition Worksheet for the student.
  d. You will see another worksheet for the same student for the same term in 'In Review'. Add some mods, hit save. you will see 'Data being added conflicts with existing data. (18,2) .
4.   Bug in the code
This line of code in the SSR_VB_VETERANS_BENEFIT.SSR_VB_TUI_WRK.OnExecute is using incorrect parameters.
1st parameter is suppose to be Institution, but it is passing emplid.
SQLExec("SELECT SSR_VB_ENR_STATUS FROM %Table(SSR_VB_ENRL_HDR) WHERE institution=:1 and emplid=:2 and strm=:3  and SSR_VB_SEQUENCE =:4", &emplid, &institution, &strm, &seq, &enr_status);


ERROR
-----------------------
1. 'Latest Enrollment Certification record is not in Reported status
2. Data being added conflicts with existing data. (18,2) .



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot test the Veterans worksheet.

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