Find Missing Component Interfaces for user
By Chris Malek | Wed, Oct 13, 2010
This sql should find component interfaces that a specific user does not have.
SELECT A.BCNAME, A.BCDISPLAYNAME, A.MENUNAME ,A.DESCR, A.DESCRLONG FROM PSBCDEFN A WHERE NOT EXISTS (SELECT B.CLASSID FROM PS_PSBCDEFN_VW B, PSOPRCLS C WHERE B.BCNAME = A.BCNAME AND C.OPRCLASS = B.CLASSID AND C.OPRID = 'UserID' ) ORDER BY A.BCNAME;
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.