Unable To Query Against Student Consolidated Statistics STDNT_CONS_STAT Record

(Doc ID 1096488.1)

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***

Symptoms



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.

EXPECTED BEHAVIOR
-----------------------
Expect data to be returned when the record is queried by Query Tool.

STEPS
-----------------------
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 

Changes

 n/a

Cause

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 hundreds of Community platforms