Finding Navigation path is More easier than anything!!!

After posting my last article, i just googled to find any other easier method to have the naviation path. I dumbed some more options for your views. I ranked it accordingly to the ease of user.

#Rank 1: use the search box at the top of the left hand menu on the homepage.Just type the Component Name in there and it’ll display your page and show you the navigation steps. Make sure Build Registry Search Index process run to sucess.[To find the other naviation,you should remeber this for once...lol]: PeopleTools > Portal > Build Registry Search Index

#Rank 2: Refer my previous posting.

Navidation path in words.. Very useful...

You can find the [PIA navigation path] for any page if you knows the component/page/SQR names.

Navigation path by Process

SELECT PRCSPNL.PRCSNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"
FROM PSMENUITEM MENU, PS_PRCSDEFNPNL PRCSPNL, PSMENUDEFN MNUDFN
WHERE MENU.PNLGRPNAME = PRCSPNL.PNLGRPNAME
AND MNUDFN.MENUNAME = MENU.MENUNAME
AND PRCSPNL.PRCSNAME LIKE 'KR045%'
-- SQR Name starts with "KR045"


Navigation path by Page

SELECT MENU.PNLGRPNAME, PNLGRP.MARKET, PNLGRP.ITEMNAME, PNLGRP.PNLNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || MENU.BARLABEL || ' > ' || MENU.ITEMLABEL "Path"
FROM PSMENUITEM MENU, PSMENUDEFN MNUDFN, PSPNLGROUP PNLGRP
WHERE MNUDFN.MENUNAME = MENU.MENUNAME
AND MENU.PNLGRPNAME = PNLGRP.PNLGRPNAME
AND PNLGRP.PNLNAME LIKE 'INFO_TBL_2'
-- Page Name ="INFO_TBL_2"


Navigation path by Component

SELECT MENU.PNLGRPNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"
FROM PSMENUITEM MENU, PSMENUDEFN MNUDFN
WHERE MNUDFN.MENUNAME = MENU.MENUNAME
AND MENU.PNLGRPNAME = 'INFO_TABLE'
-- Component Name ="INFO_TABLE"

Peoplesoft Interview Questions

1. what are the important tables in PS-HRMS?

2. when a user logs in to PS, how will the system know in which region the user comes ?

3. How many Grids can we insert in a single component or page?


4. What is the difference between a Grid and a scroll?

5. How many types of ways you can run an Application Engine program?

6. What are the Important SQC are need to be attached?

7. What is the difference between people soft TECHNICAL,FUNCTIONAL and TECHNO-FUNCTIONAL? What is Technical

8. How to use a Dynamic prompt table? what we need to do for it? what should be the length of the field

9. What is a state record?

10. Why cant the SQL and call Section Actions be present simultaneously in a single step?

12. What are the think-time functions?

13. What are the main differences between PeopleSoft financial 8.4 And 8.8/8.9 version?

14. What happens if you don't specify a Search Record for a Component?

15. Which Table contains Login User Id & Password in Peoplesoft Database?

16. What the main differences between versions of the foll.Peoplesoft CRM 8.8 and CRM 8.9? Peoplesoft HRMS

17. What are the functional differences for the BI / AR modules for versions 7.5, 8.4, 8.8 and 8.9?

18. Does SAVEEDIT saves first and then apply validations to all fields? OR does it apply validations to all

19. Difference between Save PreChanges and Save PostChanges w.r.t saveedit?

20. How to test an application engine program in 8.8?

Those are just a few. There's several more and if you do a google search for 'peoplesoft interview questions' you will see several sites with answers and questions.