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)
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.