Unable To Query Against Student Consolidated Statistics STDNT_CONS_STAT Record
Last updated on NOVEMBER 03, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms