Advisor Lookup on Student Advisor page fetches Inactive Advisors

(Doc ID 2193972.1)

Last updated on AUGUST 08, 2017

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.


Advisor lookup on the Student Advisor page (STDNT_ADVISOR) is showing Inactive Advisors.

On the STDNT_ADVISOR component, the advisor look up brings back deceases or inactive advisors. It appears that the INSTR_ADVSR_VW view does not look for effective date, so it brings all past active rows

Expect the advisor look up to fetch only the currently active advisors.

Database: N/A
PeopleTools Release: 8.55.10
Product: PeopleSoft Enterprise Campus Solutions release 9.2
System: Test

The issue can be reproduced at will with the following steps:
1. Navigate to Curriculum Management - Instructor/Advisor Information - Instructor/Advisor Table
2. Add a new effective dated row for an advisor to make him/her Inactive
3. Navigate to Records and Enrollment - Student Background Information - Student Advisor
4. Add a new effective dated for row a student and do an advisor look up
5. Notice the look up fetches the Inactive Advisor.


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