11/13/11

Finding the Navigation of PeopleSoft Components - Part 4 - Yet Another SQL Query to find navigation of PS Component

SELECT DISTINCT( portal_objname ),
               portal_uri_seg2 AS 'COMPONENT'
FROM   psprsmdefn
WHERE  portal_uri_seg2 IN (SELECT pnlgrpname
                           FROM   pspnlgroup
                           WHERE  pnlname = '');

Go to the below navigation and then find the Menu item and Portal Object Name.
Peopletools > Portal > View Menu Item Details



Now run the below SQL query and search for the PORTAL_OBJNAME found above.
Menu path will provide the navigation of the desired Page.

No comments:

Post a Comment

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month