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.
Article Categories
Chris Malek
Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.
About Chris Work with ChrisPeopleSoft Simple Web Services (SWS)
Do you need a quick way to create web services?
Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.
Integration Broker - The Missing Manual
I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.