Find PeopleSoft Navigation for a component using SQL

by Prashant on December 27, 2017

in PeopleSoft Basics, Quick Reference

You can use below SQL to find PeopleSoft Navigation to a component.

In below SQL replace the value of PORTAL_URI_SEG2 with your component name.

SELECT DISTINCT REVERSE(LTRIM(SYS_CONNECT_BY_PATH
(REVERSE(PORTAL_LABEL),’ >- ‘),’ >- ‘)) “NAVIGATION”
FROM PSPRSMDEFN P
WHERE PORTAL_OBJNAME = ‘PORTAL_ROOT_OBJECT’
START WITH PORTAL_URI_SEG2 = ‘PRCSDEFN’ — Replace with your Component Name
CONNECT BY PRIOR PORTAL_PRNTOBJNAME = PORTAL_OBJNAME
AND PORTAL_NAME = PRIOR PORTAL_NAME
AND PORTAL_REFTYPE = ‘F’ ;

This SQL will work most of the time but in some cases you might have to validate the component name from PSMENUITEM, PSAUTHITEM table.

There is an alternate way to find the navigation to a PeopleSoft component from PIA. 

 

Also Read:  What is Puppet and what's its significance in PeopleSoft?

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post: