Looking for documents or direction on how to make records accessible to PIA PS Query - Build Tables in PS - and Load table data.

Greetings fellow PeopleSoft-ians.

I am searching for any procedures or documents on how to do the following:

1.  Make a record that is currently not accessible in the PS Query tool available to query.  Currently when searching records to query on, the tables I am searching for do not come up.  I can find the tables using SQL Developer but no int PS.  It is not a security issue since I have all rights to the system.

2.  I am looking to create a table to house archived data from another system.  I have a .csv file that I want to load.  It will be stand alone data and read only.  There will not need to be any relationship to any other tables in the system.  I will want to be able to query off this table.

3.  I will need to load the .csv data to this new table I'm going to create.  I was thinking of using the Excel to CI load process but, again does anyone have any docs or procedures to do this?  The Excel to CI templates were already created when I started at my company so I have not created one yet.

NOTE:  I am not uber technical (no development) but I am more the functional administrator with enough technical skills to be dangerous.

We are on PS 9.2 PUM 15  PT 8.54.23 and we are an IaaS shop.

Thanks All.

Mike Bochantin

Hi.

For #1,  Yes this is a security issue.  You must add tables to a query security tree that you have access to.  Peopletools – Security – Query Security – Query Access Manager.    Query Trees  usually begin with QUERY_TREE_xxxx.     I suggest creating a new custom query tree,  since the (re)delivered query trees can be delivered in upgrades and patches.

You can see peoplebooks to read more about query security: https://docs.oracle.com/cd/E58500_01/pt854pbh1/eng/pt/tpsq/index.html

Here is some simple instructions for query security:  http://peoplesoftconcept.blogspot.com/2014/12/security-configuration-for-ps-query-or-peoplesoft-query.html

Pam