PS Query Migration Validation SQLs
Oracle Peoplesoft
While PeopleSoft PeopleTools Application Designer is the best way to validate query migrations, sometimes a few SQL scripts can be helpful when verifying that queries and associated tree exist in an environment with the necessary nodes. This SQL can be run in the appropriate SQL editor and was written against an Oracle RDBMS.
Is The Query in the Environment?
SELECT DISTINCT QRYNAME
FROM PSQRYFIELD
WHERE QRYNAME LIKE ’<<QUERYNAME>>%’;
Is Query Tree in Environment?
SELECT TREE_NAME
FROM PSTREENODE
WHERE TREE_NAME =’<<TREENAME>>’
ORDER BY 1;
Is Record in Query Security Tree?
SELECT TREE_NODE
FROM PSTREENODE
WHERE TREE_NAME =’<<TREENAME>>’
AND TREE_NODE LIKE ’%<<RecordName>>%’;