My Oracle Support Banner

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.

Symptoms

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

ACTUAL BEHAVIOR
---------------
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

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

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

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

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


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