By Chris Malek | Wed, Oct 13, 2010
This script will extract password as an update statement to be moved to another database. You will need to change the where clause per your requirements.
SELECT 'UPDATE PSOPRDEFN SET OPERPSWD = ''' || OPERPSWD || ''', LASTPSWDCHANGE = ''' | SYSDATE | ''' WHERE OPRID = ''' || OPRID || ''' ' ;' FROM PSOPRDEFN WHERE OPRID IN ('user1', 'user2') ORDER BY OPRID DESC;
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.