PS query is a delivered tool in PeopleSoft application. Using this tool, we can create private and public query. 

Public queries  

This query can be accessed by anyone. So there will be no issues in finding the view sql. 

Private queries  

This query cannot be accessed by anyone apart from the owner. So, there will be issues in finding the SQL. 

In this case first we can find the owner of that ID and ask them to assign new owner. 

Method -1 

Select qryname , lastupddttm, createoprid from psqrydefn where qryname = ‘your_query_name’; 

By this way we can find the ownerID and access the query  

Method -1 

Go to PeopleTools > Utilities > Administration >  Query Administration 



Kindly comment us if you have clarification in PeopleSoft

By admin

Related Post

Leave a Reply

Your email address will not be published. Required fields are marked *