Header Ads

  • Breaking News

    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

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad

    ad728