Sometime back, I was approached with a request from a developer who had created a new record in Application Designer but was not able to view this record in Query Manager. So in this post, I will demonstrate the steps required to view a new or existing record in Query Manager. Below steps are from Tools version 8.47.02.

  1. New record HX_TEST has been created and we would like to use it in our PS Query.
  2. Navigate to PeopleTools > Security > Query Security > Query Access Manager
  3. Search for the Tree which should have access to this record.

Query_sec1


  1. Click on the hyperlink and add the record HX_TEST

Query_sec2

  1. Open the appropriate Permission List which has access to HX_TEST_TREE and click on the Query tab

Query_sec3

  1. Click on Access Group Permissions

Query_sec4

  1. Verify the access

Query_sec5

  1. Open PeopleSoft Query Manager and you should have access to this new record.

Query_sec6

Note that this activity is the realm of PeopleSoft Security Administrator since it needs careful analysis of the question

Posted by Nitin Pai
Comments (1)
September 3rd, 2007

Comments (1)

arun - November 11th, 2009

Thanks this worked for me

Comments are closed.