Deleting Portal User favorites
By Chris Malek | Tue, Jan 4, 2011
Here is a SQL that will delete user portal favorites. You may need this if a user has favorited a component that does not exist or that you no longer want them to favorite because you hide it or removed it from Structure and content.
DELETE PSPRUFDEFN where PORTAL_OBJNAME IN ('xxx', 'yyy');
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.