Before you learn how to secure PS Query, you must learn how to create a PS Query - This is very important part in PS query development. It simply means that when we create PS query in PeopleSoft, we have to secure it so that only intended users can have access to it. Securing PS query means securing the records used in it by adding them into an appropriate tree and the records in our case are JOB and NAMES but since these are very common delivered records hence it is quite obvious that they would already have been used in other queries which means that they are already secured. We don't need to secure them but still its very important to understand that how exactly this is done. Open the component 'Query Access Manager' (Navigation: PeopleTools >Security >Query Security >Query Access Manager). As I already mentioned that securing PS Query means securing the records used in it and before we do that we first have to identify which tree are we going to add our records into. For PeopleSoft HRMS the tree used for such purpose in most of the organization is 'QUERY_TREE_HR' but you can create your own tree depending upon your own requirement.

Running a query object. Calling a user-defined PeopleCode application class from within an application package. Trigger the action that is defined for the user event. The action that is taken will be either an email notification that was set up using the PeopleSoft notification template or a user-defined PeopleCode application class. How to create awe in peoplesoft, awe peoplesoft, simple awe peoplesoft. PeopleSoft Query Link. How to create awe in peoplesoft, awe peoplesoft, simple awe peoplesoft. Configuration, Approval Process & Generic Template Setup in thru PeopleSoft Portal. PeopleSoft Meta Data SQL Query Collection 1. PeopleTools Tips Sample Chapter Available. Can this be done through peoplesoft AWE and how can this be implemented.

Download Tonka Monster Truck Pc Game Free here. Enter the tree name in the text box as shown in the screenshot above and hit on search. From the search result select the max effective dated row for the tree 'QUERY_TREE_HR' to open the updated one. It opens the tree and the records currently added into it. But hold on, the records aren't added directly into the tree but into the Access Groups which is ultimately added into the tree.

The Access Groups are nothing but entities into which similar records are added. There can be more than one Access Groups in a tree and also an Access Group can be added inside Another Access Group. In the image above, the access group 'HR ACCESS GROUP' which is also the root Access Group is highlighted. Now we have to identify which Access Group we should add our records into? There is an easy trick for that if we don't know the desired Access Group. We can rather find out which Access Group other similar records are added and once we find that,,we can add our record in to the same. So, just click on 'Find' link as pointed in above image to open the search page.

Well, the results shows that the record 'TEST_RECORD' is added into Access Group 'NEW_EXIT_REC_AG' which is added in the Access Group 'HR_ACCESS_GROUP' which is ultimately added in the tree 'QUERY_TREE_HR'. Now we know that our record has to be added into the Access Group 'NEW_EXIT_REC_AG' so click on this group and then add the record into it. Click on the toolbar 'Insert Child Record' displayed right next to the Access Group name which will open the search page for the record that you wish to add. Enter the record name and then add it. Set Access Group Permission: I already mentioned earlier that securing a PS Query means securing the records added into it and at this point we have added these records into the appropriate tree. Now we have to add the tree (QUERY_TREE_HR) and it's Access Group (NEW_EXIT_REC_AG) into a permission list which then will be added to only those users profiles who are supposed to be able to access query 'TEST_QUERY_NEWHIRE'.

Open the permission list definition into which you want to add the tree and access group, go to the tab 'Query' and click on the link 'Access Group Permissions' to open below page.

Page Name Definition Name Navigation Usage User Profiles - Roles USER_ROLES select PeopleTools, then select Security, then select User Profiles, then select User Profiles, then select Roles Attach workflow roles to users. User Profiles - Workflow USER_WORKFLOW select PeopleTools, then select Security, then select User Profiles, then select User Profiles, then select Workflow Define workflow for user profiles. User List Definition EOAW_USER_LIST select Enterprise Components, then select Approvals, then select Approvals, then select User List Setup Define user lists. Edit Grub Menu Lst Puppy Linux Download here.