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