Find PeopleSoft Navigation for a component using SQL

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. 

 

Prashant
 

Click Here to Leave a Comment Below 0 comments