Campus Solutions - PSFT (MOSC)

MOSC Banner

PS Query Access

edited Jan 29, 2014 6:57PM in Campus Solutions - PSFT (MOSC) 1 comment
 Hi,
We are implementing Peoplesoft Campus solution 9.0.

In our Test and Prod server, we are having only our institution related data and not PeopleSoft delivered employees.

We created a PS Query for list of students and their name. when we run the query, there is no output because Query is using some Security Records.

We analysis and found that emplid assigned to PS is not having access 
 SELECT * FROM PS_SJT_PERSON

SELECT * FROM PS_SJT_OPR_CLS WHERE OPRID = 'PS'
 SELECT * FROM PS_SJT_CLASS_ALL WHERE CLASSID = 'HCDPALL'

Please advice how to give security access for the emplid assigned to PS to query all the NAMES and other personal data related records.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT Campus Solutions Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center