PeopleSoft Notes

How To Reset CRef Expire Dates From 2010-12-31

update PSPRSMDEFN set PORTAL_EXPIRE_DT = '' WHERE PORTAL_EXPIRE_DT is not null; commit;

HOW TO UNLOCK A USER IN PEOPLESOFT

UPDATE PSOPRDEFN SET ACCTLOCK = 0 WHERE OPRID = 'VP1'

How to Start / stop Pub/SUB

In psadmin menu select Tux admin shutdown -g PUBSUB
boot -g PUBSUB

Process Scheduler

psadmin -p start -d database (Start a Process Scheduler) psadmin -p stop -d database (Stop a Process Scheduler) psadmin -p configure -d database (Configure a Process Scheduler) psadmin -p status -d database (Show status of a Process Schedul psadmin -p kill -d database (Kill a Process Scheduler) psadmin -p create -d database -t template -ps ps_set (Create a new Process Scheduler)

Delete Process Scheduler Configuration

DELETE FROM PS_SERVERCLASS WHERE SERVERNAME= 'PSNT'; DELETE FROM PS_SERVEROPRTN WHERE SERVERNAME= 'PSNT'; DELETE FROM PS_SERVERDEFN WHERE SERVERNAME= 'PSNT'; DELETE FROM PS_SERVERACTVTY WHERE SERVERNAME = 'PSNT'; DELETE FROM PS_SERVERMESSAGE WHERE SERVERNAME = 'PSNT'; DELETE FROM PS_SERVERNOTIFY WHERE SERVERNAME = 'PSNT'; DELETE FROM PS_SERVERPURGLIST WHERE SERVERNAME = 'PSNT'; DELETE FROM PSPRCSQUE WHERE SERVERNAMERUN = 'PSNT'; DELETE FROM PS_CDM_TRANSFER WHERE SERVERNAMERUN = 'PSNT'; DELETE FROM PSPRCSRQST WHERE SERVERNAMERUN = 'PSNT'; DELETE FROM ps_servercategory WHERE SERVERNAME = 'PSNT';

Fix PeopleTools Client issues

1) Run this first on your PC - PS_HOME\setup\vcredist\vcredist_x86.exe. 2) Then run this : PS_HOME/bin/client/winx86/pscfg.exe

Turning Off Tablespace Allocation
If you do not want to see the Change Space dialog box every time a new record definition is saved, clear the Platform Compatibility Mode option. Follow these steps:
1. In the browser, select PeopleTools, Utilities, Administration, PeopleTools Options. 2. Clear the Platform Compatibility Mode check box. 3. Save the changes.

How do find Current PS users logged in
declare P_Hr number :=0; P_Date VARCHAR2(9) := TRUNC(SYSDATE); a number;b varchar2(10); begin For Z1 in 1..24 LOOP select count(1),P_Hr'-'(P_Hr+1) into a,b from psaccesslog where logindttm between to_date(P_Date' 'P_Hr':00:00','DD-MON-YY HH24:MI:SS') and to_date(P_Date' 'P_Hr':59:59','DD-MON-YY HH24:MI:SS')+1/24 and oprid not in 'GFAAPSRV'; DBMS_OUTPUT.PUT_LINE(a','b); P_Hr := P_Hr+1; END LOOP;end;

select count(1) "Login_Users",'12AM - 01AM' "Time" from psaccesslog where logindttm between to_date('04-AUG-11 00:00:00','DD-MON-YY HH24:MI:SS') and to_date('04-AUG-11 23:59:59','DD-MON-YY HH24:MI:SS') and oprid not in 'GFAAPSRV';

Weblogic WLS Server does not boot Unable to obtain lock on /home/psfsusr/ There was an error while opening the file store file "WLS_DIAGNOSTICS000000.DAT" Store:280021 Shutdown server clean up following directories /home/psfsusr/FS91DEMO/webserv/fs91demo/servers/PIA/logs /home/psfsusr/FS91DEMO/webserv/fs91demo/servers/PIA/tmp /home/psfsusr/FS91DEMO/webserv/fs91demo/servers/PIA/data/ldap /home/psfsusr/FS91DEMO/webserv/fs91demo/servers/PIA/data/store /home/psfsusr/FS91DEMO/webserv/fs91demo/servers/PIA/cache/diagnostics restart the web server