Student Advisor Assignment Process Assigns More Than One Advisor in Some Cases (Doc ID 2896803.1)

Last updated on NOVEMBER 09, 2022

Applies to:

Symptoms

When running the Student Advisor Assignment process using the same assignment code but on different days, the process assigns more than one advisor to students. The process should assign only one advisor.

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

1. Update Instructor/Advisor table for Advisor 1 with Academic Career, Program and Plan. Navigation: Records and Enrollment => Student Background Information => Student Advisor.
2. Update Advisor 2 with the same values.
3. Go to Student Assignment page and create a new code. Navigation: Records and Enrollment => Student Background Information => Student Advisor Assignment.
4. Enter required parameters, including Distribute Advisors by:Single and Assign Student Advisors at: Program/Plan.
5. Click 'Get Advisors'. Both Advisors display as expected.
6. In Self-Service => Student Center, update Student 1 with above Program and Plan.
7. Go back to Student Advisor Assignment and enter a newly created Assignment Code. Navigation: Records and Enrollment => Student Background Information => Student Advisor Assignment.
8. Press 'Get Students': Student 1 was added as expected.
9. Press 'Assign Advisors' button.
10. Check Student 1 assignment: Advisor 1 was assigned as expected.
11. On the next calendar day, in Self-Service => Student Center, update Student 2 with the same Program and Plan.
12. Go back to Student Advisement and using the same Assignment Code press 'Get Students' button.
13. Student 2 was added as expected.
14. Click 'Assign Advisors' button.
15. Check results for both students.
16. Got expected results for Student 2.
17. Results for Student 1: first Effective dated row shows only one advisor but the second Effective dated row shows that both advisors were assigned to the student.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.