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 JANUARY 23, 2020

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 and later
Information in this document applies to any platform.


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.

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.


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

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