My Oracle Support Banner

Duplicate Values in Student Attributes Prompt Table in Student Program/Plan When Emplid has Program Actions on Same Eff Date (Doc ID 2408845.1)

Last updated on JUNE 07, 2018

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

ACTUAL BEHAVIOR
---------------
Duplicate values are populating in the Prompt table (stdnt_attr_VW) in the Student Attributes Page.

For emplid who is having the same effdt for both program actions (Active and Suspended) in the Student Attribute Page, duplicate rows coming in the prompt table.
The objects involved are PeopleSoft delivered objects.
Page – stdnt_attributes
View – stdnt_attr_vw
Prompt table – stdnt_attr_tbl.

In the view(stdnt_attr_vw), the duplicates are populating.



EXPECTED BEHAVIOR
-----------------------
Look up values should be unique

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Student Program/Plan, Add Program Actions ‘Activate’ and ‘Suspension’ on same effective date
2. Go to Student Attributes page
3. Click on Student Attribute look up.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can be confused seeing the duplicate values

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
References


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