Unable To Query Against Student Consolidated Statistics STDNT_CONS_STAT Record
(Doc ID 1096488.1)
Last updated on FEBRUARY 20, 2019
Applies to:PeopleSoft Enterprise CS Student Records - Version 9 to 9 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 20-May-2013***
On : 9 version, Consolidated Statistics
Find that users are unable to query student consolidate statistics (PS_STDNT_CONS_STAT) record even after security is removed from the record.
Expect data to be returned when the record is queried by Query Tool.
The issue can be reproduced at will with the following steps:
1. Navigate to "Set up SACR > Security > Secure Student Administration > User ID > Security Views" and cleared the security settings for the table in question. Saved it with the option "No Security" in the ES_SECURITY_LEVEL field. Also tied it with security set to Institution Level security
2. Run the process to apply the update.
3. Attempt to query the record results in no rows found.
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