Find Missing Portal Pagelets on a user’s home page
By Chris Malek | Wed, Oct 13, 2010
There are times when a user’s PeopleSoft Portal home page customization can get mixed up and pagelets go missing. For Example, if the user chose a two column layout but the tables that store the user’s homepage configuration have a pagelet set to display on the third column those pagelets will never be shown.
Here is query that will find those missing missing pagelets.
SELECT * FROM PSPRUHTABPGLT A, PSPRUHTAB B, PSOPRDEFN C WHERE A.PORTAL_NAME = B.PORTAL_NAME AND A.OPRID = B.OPRID AND A.PORTAL_COL_NUM > B.PORTAL_COLLAYOUT AND A.OPRID = C.OPRID AND ACCTLOCK = 0
To correct this you can get the user to switch to a 3 column layout, then flip them back to a 2 column layout. This will fix the invalid entries in portal tables.