My Oracle Support Banner

Unable To Query Against Student Consolidated Statistics STDNT_CONS_STAT Record (Doc ID 1096488.1)

Last updated on NOVEMBER 23, 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.

Please also visit these valuable Campus Solutions sites: Community  Newsletters  Information_Centers  Maintenance_Advisor 




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.