Query for Component Path within PeopleSoft Portal

 1) Run the below SQL to get the content reference name for your component

SELECT PORTAL_NAME, PORTAL_OBJNAME AS CONTENT_REFERENCE, PORTAL_LABEL, PORTAL_URI_SEG1 AS MENU, PORTAL_URI_SEG2 AS COMPONENT, PORTAL_URI_SEG3 AS MARKET FROM psprsmdefn WHERE PORTAL_NAME = 'EMPLOYEE' AND PORTAL_URI_SEG2 = :1;
-- Replace :1 with the component name you are looking for.

2) From the query above - copy the value in the CONTENT_REFERENCE field and replace the ":1" variable and you will have the path to your component.

WITH portal_registry AS (SELECT RTRIM(REVERSE(sys_connect_by_path(REVERSE(portal_label), ' >> ')), ' >> ') path, LEVEL lvl FROM psprsmdefn WHERE portal_name = 'EMPLOYEE' START WITH PORTAL_OBJNAME = :1 CONNECT BY PRIOR portal_prntobjname = portal_objname) SELECT path FROM portal_registry WHERE lvl = (SELECT MAX(lvl) FROM portal_registry);

 

So, the 1st query is to get the content reference for a component name that you know and then using Jim's query to find the path!