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.


On : 9 version, Student Records Enrollment

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.

Look up values should be unique

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.

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


To view full details, 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 a vibrant support community of peers and Oracle experts.